Search Postgresql Archives
Tape backup, 2 versions, same database name, which is pg_dump backing up
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]