beginners postgres question

graham graham at
Mon Oct 8 12:23:40 BST 2007

Toby Corkindale wrote:

> The --disable-triggers flag to pg_restore?

Thanks Toby!

For any future googlers with this problem (ie reloading a dump into a 
running database with a schema altered since the dump)

-- do NOT use pg_dump --no-data

-- use pg_dump --format=archive to dump everything including the data

-- [alter schema as desired (assuming still compatible with old data)]

-- use pg_restore --data-only --disable-triggers to restore without 
overwriting the schema changes or getting caught by the constraints

> tjc

More information about the mailing list