Re: Dump and Restore

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