Schema-only dump dumps no constraints, no triggers

From: Marek Kielar <mkielar(at)go2(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Schema-only dump dumps no constraints, no triggers
Date: 2012-07-26 23:09:50
Message-ID: 175a5c14.6d629c49.5011ce3e.32ef4@go2.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 constraints and triggers - seems pg_dump just skips over them. Otherwise the dump seems to be complete, the schema-table-column layout is complete. We thought it was the template server problem, but the oddity is that a dump made with Windows version of pgAdmin3 comes out complete.

The command we use is:
/usr/bin/pg_dump -h <SERVER_IP> -p <SERVER_PORT> -U <SERVER_USER> -F p -N '*somename*' -N 'somename2' -N 'somename3' -N 'somename4' -N 'somename5' -T '*somename6*' -s -v -f /some/dir/schemacopy.sql <DATABASE_NAME>

The dump is made using a script we consider to be stable and therefore it hasn't changed since a long while ago. We also weren't able to pin down any other change between the systems where it previously worked and the ones where it now refuses to - the operating system (Fedora 16) is the same, the hardware is the same, the template database server is the same. It doesn't matter whether we are running the script on an up-to-date system or an outdated-off-liveCD-installation version, so it most probably is not update-related. The server (as a system) is sometimes under pretty much load so it might be resource-related - be it currently or previously.

Searching through the archives, I have only stumbled upon a post from 2003 about a similar issue (http://archives.postgresql.org/pgsql-admin/2003-08/msg00239.php) which might be connected, however, since the reporter gave up quickly, the issue remained unsolved.

How can we dig into this further? What might be happening?

Best regards,
Marek Kielar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-07-26 23:53:53 Re: Replication/cloning: rsync vs modification dates?
Previous Message hartrc 2012-07-26 22:07:52 postgres maintenance db