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

• Dump and Restore at 2004-08-24 13:40:32 from Eduardo S. Fontanetti

pgsql-admin by date

Next:	From: Eduardo S. Fontanetti	Date: 2004-08-24 16:36:18
	Subject: Re: [GENERAL] Dump and Restore
Previous:	From: Thilina Gunasekara	Date: 2004-08-24 15:38:19
	Subject: Re: [GENERAL] Dump and Restore

pgsql-general by date

Next:	From: Tom Lane	Date: 2004-08-24 16:30:57
	Subject: Re: Invalid input for integer on VIEW
Previous:	From: Tom Lane	Date: 2004-08-24 16:17:50
	Subject: Re: No connection to a PG 8.0 Beta 1 win32 server