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

From: MargaretGillon(at)chromalloy(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Tape backup, 2 versions, same database name, which is pg_dump backing up
Date: 2006-08-02 20:47:27
Message-ID: OF9C88A54C.ED75F333-ON882571BE.0070FEC5-882571BE.0072360A@CHROMALLOY.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2006-08-02 21:02:15 Re: logic/db question
Previous Message Joshua D. Drake 2006-08-02 20:30:50 Re: Best Procedural Language?