Re: dumping strategy - Mailing list pgsql-general

From Tom Lane
Subject Re: dumping strategy
Date
Msg-id 25243.991356549@sss.pgh.pa.us
Whole thread Raw
In response to Re: dumping strategy  (Neil Conway <nconway@klamath.dyndns.org>)
Responses Re: dumping strategy  (Philip Hallstrom <philip@adhesivemedia.com>)
List pgsql-general
Neil Conway <nconway@klamath.dyndns.org> writes:
>> It's just
>> for i in t1 t2 t3; do pg_dump -t$i mydb > $i.tbl; done

> Although with a strategy like this, they're no guarantee that the
> snapshot you get will be consistent. And if you're using refential
> integrity it might not even restore properly.

Good point.  So who wants to tweak pg_dump to accept multiple -t
switches?  Seems like

    pg_dump -t foo -t bar -t baz dbname

is a reasonably non-ambiguous syntax.

            regards, tom lane

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: RE: Postgres docs in .chm format --- is this possible?
Next
From: Tom Lane
Date:
Subject: Re: A question on EFFECTIVE_CACHE_SIZE