Thread: Restoring the database

Restoring the database

From
"Cody Phanekham"
Date:
Hi,

Im trying to restore a postgresql database from a backup that was done a few days ago. The backup is on CD and was a
straightcopy of everything in the /$postgresql_install_path/ 

The problem is i want to restore a certain database and not every database. How would i know what files correspond to
whichdatabase ? 

eg. I've got 3 databases called 'books', 'dvds' and 'videos'. I only want to restore 'dvds' from the CD.

----------
Regards

Cody Phanekham



*************************************************************************************
This e-mail, including any attachments to it, may contain confidential and/or personal information.
If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action
based on the information contained within it.

Please notify the sender immediately by return e-mail of the error and then delete the original e-mail.

The information contained within this e-mail may be solely the opinion of the sender and may not necessarily
reflect the position, beliefs or opinions of Salmat on any issue.

This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems.

For more information, visit our website at  www.salmat.com.au.
*************************************************************************************


Re: Restoring the database

From
Tomka Gergely
Date:
2003-09-02 ragyogó napján Cody Phanekham ezt üzente:

> Hi,
>
> Im trying to restore a postgresql database from a backup that was done
> a few days ago. The backup is on CD and was a straight copy of
> everything in the /$postgresql_install_path/
>
> The problem is i want to restore a certain database and not every
> database. How would i know what files correspond to which database ?
>
> eg. I've got 3 databases called 'books', 'dvds' and 'videos'. I only
> want to restore 'dvds' from the CD.

I think for this you need to know the OID of the database. This is not
easy without running db. So restore the full db, and next time use pg_dump
<databasename> > dbsave.sql for backup.



--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."