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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
