Re: [GENERAL] Schema-only dump dumps no constraints, no triggers

2012-07-29 Thread Marek Kielar
Hi, Dnia 28 lipca 2012 1:10 Adrian Klaver napisaƂ(a): > What where the deleted files? >WAL, Logs, other? > What type of WAL replication are you doing? >Streaming, log shipping, etc? > What are your settings for the WAL replication? >In particular wal_keep_segments ? > Is the WAL rep

Re: [GENERAL] Schema-only dump dumps no constraints, no triggers

2012-07-27 Thread Adrian Klaver
On 07/27/2012 09:32 AM, Marek Kielar wrote: Hi, again, I'm sorry about the lack of version information - I concentrated so much on describing the problem correctly, that I forgot to provide basic information. The version at locations is 9.1.4 (though this is irrelevant now), the server is 9.0

Re: [GENERAL] Schema-only dump dumps no constraints, no triggers

2012-07-27 Thread Marek Kielar
Hi, again, I'm sorry about the lack of version information - I concentrated so much on describing the problem correctly, that I forgot to provide basic information. The version at locations is 9.1.4 (though this is irrelevant now), the server is 9.0.4. We found what the problem was. Another pr

Re: [GENERAL] Schema-only dump dumps no constraints, no triggers

2012-07-26 Thread Adrian Klaver
On 07/26/2012 04:09 PM, Marek Kielar wrote: Hi, we are using "pg_dump -s" (schema-only) to copy the structure of a template/prototype database as a set-up for several dozen Fedora boxes. The dump used to work alright until very recently. Now, across new machines that are to be introduced into

[GENERAL] Schema-only dump dumps no constraints, no triggers

2012-07-26 Thread Marek Kielar
Hi, we are using "pg_dump -s" (schema-only) to copy the structure of a template/prototype database as a set-up for several dozen Fedora boxes. The dump used to work alright until very recently. Now, across new machines that are to be introduced into the network it consistently refuses to dump