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 money motivation

Opscomplete powered by makandra brand

Save money by migrating from AWS to our fully managed hosting in Germany.

  • Trusted by over 100 customers
  • Ready to use with Ruby, Node.js, PHP
  • Proactive management by operations experts
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)