Clean restore from PostgreSQL dump

Question

I want to restore a database from backup and rewrite all data that is there with backup data.

My current command is like this:

pg_restore -h localhost -U postgres -d dbName -v autobackup_file.dmp

How to restore and rewrite all data?
I've seen an option -c; is that the correct way?
And where should I put it in my command?

Laurenz Albe · Accepted Answer · 2018-08-21 08:23:21Z

1

-c can be anywhere, e.g. immediately after pg_restore.

It will DROP all restored objects before restoring them, but it will not drop any objects that are not in the dump.

To drop and recreate the whole database so you get a clean copy, you can use -C -c.

answered Aug 21, 2018 at 8:23

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1