Re: pg_dump | pg_sql: insert commands and foreign key constraints

On 2008-09-24 18:01, William Garrison wrote:

> Then I commented-out the constraints from the schema. Then I loaded
> the data.

Don't forget to restore these constraints back after loading data.

> I made a schema only dump, then a data only dump with --inserts. (...)
> Unfortunately, the INSERT statements take 24 hours instead of 4 hours to
> restore. When you say the "default" options - what format does that
> write? Should I have used -Fp to make a plain text backup but not
> --inserts? Then it would be doing a COPY instead of an INSERT and maybe
> that would be faster.

Indeed.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh