Harald Armin Massa wrote:
- is pg_dump supposed to produce a "ordered dump" with --data-only?
(within documentation there is only a warning that --table will not dump
the depending ones)
[than I have to create a extract to reproduce that "bug"]
- or if it is simply not implemented and an enhan
Florian, thank you very much for those solutions; I shortened them, resend them for "increased google presence" :)
1) Use [...] --disable-trigger option [...]
2) foreign keys as "deferrable", do "set contraints alldeferred" before loading the data. 3) split the schema dump into two files, a) tab
Harald Armin Massa wrote:
I migrated one database from 8.0 to 8.1
That I used to do add "without oids" to all tables.
First step so:
pg_dump --schema-only -U user database
the file was edited, all tables to "withoud oids"; and reloaded in 8.1
After that I
pg_dump --data-only -U user databa
Harald Armin Massa wrote:
> [snipped text]
pg_dump --data-only -U user database
and tried to reload the data. But it fails on foreign keys: depending tables
are being dumped before the tables they depend on.
I solved it by manually dumping the relevant tables and reloading them,
Now I cannot f
I migrated one database from 8.0 to 8.1That I used to do add "without oids" to all tables.First step so:pg_dump --schema-only -U user databasethe file was edited, all tables to "withoud oids"; and reloaded in
8.1After that I pg_dump --data-only -U user databaseand tried to reload the data. But it
