Re: Dump a database excluding one table DATA? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Dump a database excluding one table DATA?
Date
Msg-id 201108181336.12330.adrian.klaver@gmail.com
Whole thread Raw
In response to Re: Dump a database excluding one table DATA?  (Dmitry Koterov <dmitry@koterov.ru>)
Responses Re: Dump a database excluding one table DATA?
List pgsql-general
On Thursday, August 18, 2011 1:23:25 pm Dmitry Koterov wrote:
> 1. I need to shorten pg_dump results (for backup purposes), so pg_restore
> is too late for that..

>
> 2. If I use "pg_dump -s" separately, the data may not load (or load to
> slow) after that, because all indices/foreign keys are already there. Is
> there a way to split "pg_dump -s" into 2 parts: the first part dumps
> everything excluding indices, checks and foreign keys, and the second part
> - only them? Not sure it is possible at all, because I think pg_dump may
> dump data not between these two blocks of DDLs...
>

I am not sure I follow. Are you saying you eventually restore the data for that
table as a separate step? If so, from the previous link, this might help:

"
--disable-triggers

    This option is only relevant when performing a data-only restore. It
instructs pg_restore to execute commands to temporarily disable triggers on the
target tables while the data is reloaded. Use this if you have referential
integrity checks or other triggers on the tables that you do not want to invoke
during data reload.

    Presently, the commands emitted for --disable-triggers must be done as
superuser. So, you should also specify a superuser name with -S, or preferably
run pg_restore as a PostgreSQL superuser.
"



--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Erwin Brandstetter
Date:
Subject: Retrieve number of rows from COPY command inside a plpgsql function
Next
From: Dmitry Koterov
Date:
Subject: Re: Dump a database excluding one table DATA?