Re: pg_restore --no-post-data and --post-data-only - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: pg_restore --no-post-data and --post-data-only
Date
Msg-id 25186b6e3e427e6eed929469d0ef9ddc@biglumber.com
Whole thread Raw
In response to Re: pg_restore --no-post-data and --post-data-only  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pg_restore --no-post-data and --post-data-only
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> Well, notwithstanding my well known love of perl, that strikes me as 
> spending a pound to save a penny. And custom format dumps rock ;-) Also, 
> your recipe above is buggy, BTW. A CREATE INDEX statement might well not 
> be the first item in the post-data section.
> 
> But we could also add these switches to pg_dump too if people feel it's 
> worthwhile. I haven't looked but the logic should not be terribly hard.

A big +1 to --pre-data and --post-data, but until we get there, or 
if you have an existing dump file (schema *or* schema+data) that needs 
parsing, there is an existing tool:

http://blog.endpoint.com/2010/01/splitting-postgres-pgdump-into-pre-and.html

Once these new flags and the ability to custom format dump pg_dumpall 
is done, I'll have very little left to complain about with pg_dump :)

- -- 
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201108271855
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk5ZdfwACgkQvJuQZxSWSsipDQCgpmNtD/I/2gfAzm2b3jouD8nS
qhgAn33t5VLiF8HeslBwCqyMzQJy6VN5
=PfK7
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cryptic error message in low-memory conditions
Next
From: Jeff MacDonald
Date:
Subject: Re: Inputting relative datetimes