You'll need to specify the non-default port explicitly in your pg_dump command in order to back up the postmaster running on 55432. E.g., pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date+%F)owl.sql owl By default, the postgres command-line utilities attempt to connect to 5432 (or $PGPORT or whatever is configured as the default port). In the meantime, you're still backing up the 7.3.4 postmaster with that script. -- Thomas F. O'Connell Sitening, LLC 3004B Poston Avenue Nashville, TN 37203-1314 615-469-5150 x802 615-469-5151 (fax)On Aug 2, 2006, at 3:47 PM, [EMAIL PROTECTED] wrote: Yesterday a consultant upgraded me from 7.3.4 to 8.1.4 on a RedHat 9 server. To make sure everything was okay we left the server so that both versions of Postgresql load. 7.3.4 loads on the default port of 5432 and 8.1.4 loads on port 55432 . My database was moved into the new version so both the old and new databases have the same name. |
- [GENERAL] Tape backup, 2 versions, same database name,... MargaretGillon
- Re: [GENERAL] Tape backup, 2 versions, same datab... Thomas F. O'Connell
- Re: [GENERAL] Tape backup, 2 versions, same d... MargaretGillon
- Re: [GENERAL] Tape backup, 2 versions, sa... Thomas F. O'Connell
- Re: [GENERAL] Tape backup, 2 versions... MargaretGillon
- Re: [GENERAL] Tape backup, 2 ver... Thomas F. O'Connell
- Re: [GENERAL] Tape backup, 2... Richard Huxton
- Re: [GENERAL] Tape backu... MargaretGillon