Re: Tape backup, 2 versions, same database name, which is pg_dump backing up

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

http://www.sitening.com/
3004B Poston Avenue
Nashville, TN 37203-1314
615-469-5150 x802
615-469-5151 (fax)

On Aug 2, 2006, at 3:47 PM, MargaretGillon(at)chromalloy(dot)com 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.
>
> 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.