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
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?
Postgres version?
Is there more than one version of PG on machine?
The dump made with PgAdmin uses the same parameters?
Any errors in the logs on either the dump or restore side?
Best regards,
Marek Kielar
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
