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)
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.
I have a little .sh file that runs a tape backup using pg_dump and I am wondering if both versions are running how do I know which version of the pg_dump is running and which version of the database is being backed up?
The backup command I use is
pg_dump -U postgres -C -D -f /tmp/$(date+%F)owl.sql owl
then I use tar to copy the file to tape.
Please answer to me as well as the list, I am on digest.
Thanks,
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message.
