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 online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
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)