Thread: pg_dump question
Hi, I would like to use pg_dump to backup a list of tables to one file, but it looks like the -t option only supports one file. So, pg_dump gives you the option of backing up and entire database or one file, but nothing in between. Am I missing something? Is there a way to backup multiple tables (but not the whole database)? Thanks, Tom Burns
am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes: > Hi, > > I would like to use pg_dump to backup a list of tables to one file, > but it looks like > the -t option only supports one file. So, pg_dump gives you the > option of backing > up and entire database or one file, but nothing in between. Am I > missing something? > Is there a way to backup multiple tables (but not the whole database)? You can wait for 8.2, this version supports multiple -t - options. Or you can concat several table-dumps to one big dump. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
A. Kretschmer wrote: > am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes: > > Hi, > > > > I would like to use pg_dump to backup a list of tables to one file, > > but it looks like > > the -t option only supports one file. So, pg_dump gives you the > > option of backing > > up and entire database or one file, but nothing in between. Am I > > missing something? > > Is there a way to backup multiple tables (but not the whole database)? > > You can wait for 8.2, this version supports multiple -t - options. > Or you can concat several table-dumps to one big dump. Note that the latter option does not guarantee that you get a consistent dump. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera <alvherre@commandprompt.com> schrieb: > > > I would like to use pg_dump to backup a list of tables to one file, > > > but it looks like > > > the -t option only supports one file. So, pg_dump gives you the > > > option of backing > > > up and entire database or one file, but nothing in between. Am I > > > missing something? > > > Is there a way to backup multiple tables (but not the whole database)? > > > > You can wait for 8.2, this version supports multiple -t - options. > > Or you can concat several table-dumps to one big dump. > > Note that the latter option does not guarantee that you get a consistent > dump. Yes, of course. Ref. integrity, for instance. But i don't know, how 8.2 solve this problem. Can you explain this? Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11/02/06 09:56, Alvaro Herrera wrote: > A. Kretschmer wrote: >> am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes: >>> Hi, >>> >>> I would like to use pg_dump to backup a list of tables to one file, >>> but it looks like >>> the -t option only supports one file. So, pg_dump gives you the >>> option of backing >>> up and entire database or one file, but nothing in between. Am I >>> missing something? >>> Is there a way to backup multiple tables (but not the whole database)? >> You can wait for 8.2, this version supports multiple -t - options. >> Or you can concat several table-dumps to one big dump. > > Note that the latter option does not guarantee that you get a consistent > dump. What about creating a new schema that "just" has views back to the base tables you want to dump. Then pg_dump the schema. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFSheIS9HxQb37XmcRAh87AKDnrDQj2sL/J8kv1+ZEz/7Ml4mb1QCglkc0 IfDD3/ISk7Jew8hdtpSyWNI= =1pD9 -----END PGP SIGNATURE-----
Andreas Kretschmer wrote: > Alvaro Herrera <alvherre@commandprompt.com> schrieb: > > > > I would like to use pg_dump to backup a list of tables to one file, > > > > but it looks like > > > > the -t option only supports one file. So, pg_dump gives you the > > > > option of backing > > > > up and entire database or one file, but nothing in between. Am I > > > > missing something? > > > > Is there a way to backup multiple tables (but not the whole database)? > > > > > > You can wait for 8.2, this version supports multiple -t - options. > > > Or you can concat several table-dumps to one big dump. > > > > Note that the latter option does not guarantee that you get a consistent > > dump. > > Yes, of course. Ref. integrity, for instance. But i don't know, how 8.2 > solve this problem. Can you explain this? It dumps all tables in a single SERIALIZABLE transaction. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support