Read more

Heads up: pg_restore --clean keeps existing tables

Arne Hartherz
January 16, 2019Software engineer at makandra GmbH

When restoring a PostgreSQL dump using pg_restore, you usually add the --clean flag to remove any existing data from tables.

Illustration web development

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

  • We build reliable cloud solutions with Infrastructure as code
  • We are experts in security, Linux and databases
  • We support your dev team to perform
Read more Show archive.org snapshot

Note that this only removes data from tables that are part of the dump and will not remove any extra tables. You need to do that yourself.

Posted by Arne Hartherz to makandra dev (2019-01-16 11:49)