Re: [GENERAL] Postgres Dump out of order

2009-12-02 Thread Tom Lane
Craig Ringer writes: > On 2/12/2009 3:41 PM, silly wrote: >> pg_dump dumps data first and then the constraints (including FK) so >> there shouldn't be any problems when you import the dump. > ... assuming you're using a sufficiently recent version of pg_dump. > Wasn't that added fairly recen

Re: [GENERAL] Postgres Dump out of order

2009-12-02 Thread A. Kretschmer
In response to Helio Campos Mello de Andrade : > Hi guys, > >  - I'm having a problem when i want to make a backup of my system. >  - Postgres generated dump was created out of "foreing key" order and when i > try to recreate my database structures, data and functions. Does someone have > this sam

Re: [GENERAL] Postgres Dump out of order

2009-12-02 Thread Craig Ringer
On 2/12/2009 3:41 PM, silly wrote: pg_dump dumps data first and then the constraints (including FK) so there shouldn't be any problems when you import the dump. ... assuming you're using a sufficiently recent version of pg_dump. Wasn't that added fairly recently? -- Craig Ringer -- Sent

Re: [GENERAL] Postgres Dump out of order

2009-12-01 Thread silly8888
pg_dump dumps data first and then the constraints (including FK) so there shouldn't be any problems when you import the dump. On Wed, Dec 2, 2009 at 2:16 AM, Helio Campos Mello de Andrade wrote: > Hi guys, > >  - I'm having a problem when i want to make a backup of my system. >  - Postgres gene

Re: [GENERAL] Postgres Dump out of order

2009-12-01 Thread Rikard Bosnjakovic
On Wed, Dec 2, 2009 at 08:16, Helio Campos Mello de Andrade wrote: > - Postgres generated dump was created out of "foreing key" order and when i > try to recreate my database structures, data and functions. I think there's some information missing here. What happens when you recreate your data

[GENERAL] Postgres Dump out of order

2009-12-01 Thread Helio Campos Mello de Andrade
Hi guys, - I'm having a problem when i want to make a backup of my system. - Postgres generated dump was created out of "foreing key" order and when i try to recreate my database structures, data and functions. Does someone have this same issue? Someone knows of some app that do the job? Regard