beginners postgres question

graham graham at theseamans.net
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

Graham
> tjc



More information about the london.pm mailing list