pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dario <dario_d_s@unitech.com.ar>
To: pgsql-admin@postgresql.org
Subject: Re: excluding a table from pg_dump
Date: Thu, 27 Oct 2005 18:45:36 -0300
Message-ID: <MHEDJHCKDNOEHJKHIOCJAEBCCJAA.dario_d_s@unitech.com.ar> (raw)
In-Reply-To: <874q75sdg8.fsf@srv.protecting.net>

May be... you could dump your schema in plain format, (dump only schema),
create a new database, restore schema, and then do something like

psql -c "select \'pg_dump --table=\'||name||\'--disable-triggers
database_\' from pg_class where (condition that filters system
tables)">dumper.sh

(I'm not sure about escaping (or lack of) in quotes and pipes...)

your file will be full of:
pg_dump --table=table1 --disable-triggers  database_
pg_dump --table=table2 --disable-triggers  database_

then you could edit that file and delete the large table dump.
run the script to a generate your dump and filter for undesired things. then
run the file with psql. When things go wrong, start all over. This only is
usefull if you need to do it in a periodically basis. Otherwise I assume it
will be easier to do it by hand.

I never did it in postgresql. I will try to make it work and give you more
detail about the necesary steps, but only the next wednesday. May be someone
could complete (or refute this idea)


(My english is definitly bad)

greetings. long life and beer.

-----Mensaje original-----
De: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]En nombre de Harald Fuchs
Enviado el: martes, 25 de octubre de 2005 14:40
Para: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] excluding a table from pg_dump


In article <60zmoxblq0.fsf@dba2.int.libertyrms.com>,
Chris Browne <cbbrowne@acm.org> writes:

> A usual reason why I would want to dump everything except for a few
> tables is that those few tables are particularly enormous and
> particularly useless (at least, for the purposes of my dump).

> In that case, the LAST thing I want to do is to make extra copies of
> the *useless* tables.

As long as we don't have "pg_dump -X" (or something like that) you
could put the tables you don't want to dump into another schema.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq




view thread (7+ messages)

Message-ID: <MHEDJHCKDNOEHJKHIOCJAEBCCJAA.dario_d_s@unitech.com.ar>
Permalink:  ../MHEDJHCKDNOEHJKHIOCJAEBCCJAA.dario_d_s@unitech.com.ar/
Also on:    postgresql.org/message-id/MHEDJHCKDNOEHJKHIOCJAEBCCJAA.dario_d_s@unitech.com.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dario_d_s@unitech.com.ar
  Subject: Re: excluding a table from pg_dump
  In-Reply-To: <MHEDJHCKDNOEHJKHIOCJAEBCCJAA.dario_d_s@unitech.com.ar>
  References: <874q75sdg8.fsf@srv.protecting.net> <MHEDJHCKDNOEHJKHIOCJAEBCCJAA.dario_d_s@unitech.com.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox