Re: Restoring the database

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..."