| From: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
|---|---|
| To: | "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Dump and Restore |
| Date: | 2004-08-24 16:28:15 |
| Message-ID: | 412B6C9F.8070301@syscor.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Eduardo S. Fontanetti wrote:
>How can I do a test if my dumping is really working, I
>can't apply the dump in my database, because it will
>overwrite a lot of data. I was thinking about restore
>in another database name, but I can't, it always
>restore on the original database.
>
>Somebody have a cooking recipe about to test if my
>backup is working fine, and will help if I need
>sometime?
>
>
<snip>
OK here's a recipe:
If you're using pg_dump as in:
pg_dump dbName > fileName
create your new database:
createdb myNewDB (don't forget your encoding)
and then restore from the dump:
psql -d myNewDB -f fileName
Ron
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eduardo S. Fontanetti | 2004-08-24 16:36:18 | Re: [GENERAL] Dump and Restore |
| Previous Message | Thilina Gunasekara | 2004-08-24 15:38:19 | Re: [GENERAL] Dump and Restore |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-24 16:30:57 | Re: Invalid input for integer on VIEW |
| Previous Message | Tom Lane | 2004-08-24 16:17:50 | Re: No connection to a PG 8.0 Beta 1 win32 server |