| From: | Tomka Gergely <tomka(at)zeus(dot)gau(dot)hu> |
|---|---|
| To: | Cody Phanekham <Cody(dot)Phanekham(at)salmat(dot)com(dot)au> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Restoring the database |
| Date: | 2003-09-02 06:28:41 |
| Message-ID: | Pine.LNX.4.33.0309020826190.31338-100000@zeus.gau.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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..."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffrey Melloy | 2003-09-02 07:34:27 | Re: SELECT woes |
| Previous Message | Cody Phanekham | 2003-09-02 04:35:01 | Restoring the database |