By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,775 Members | 1,432 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,775 IT Pros & Developers. It's quick & easy.

Should a database be cleared before restoration?

P: 1
I have a dumpfile created with pg_dumpall. If I need to restore a database from it to bring it up to date with another database system, do I need to clear out the contents of the database first? I don't want to create duplicate records by pulling in the dumpfile.
May 30 '13 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 700
I did not use postgres for a very long time but as far as I remember if you do not use -F then the dump will be sql text file. You can check if the dump contains drop table statements before creating table from dump (I think tables are dropped before recreating).
Jun 8 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.