Re: Dump and Restore

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

In response to

Browse pgsql-admin by date

  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

Browse pgsql-general by date

  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