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