Hello all, I am new to POSTGRESQL and I am trying to dump and load a database...using the steps below I get DUP errors when trying to LOAD the file into an existing database...
Do I have to DROP \ recreate and load the target database (this is what I currently do)? is there a way to just do an IN PLACE load like in other RDBMS environments??? pg_dump proddb | gzip > proddb_082107.sql.gz gunzip < proddb_082107.sql.gz | psql -d testdb -f - Thanks, Michelle. -- View this message in context: http://www.nabble.com/Dump---Load-a-database----tf4305692.html#a12256258 Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
