System dump, but not in the default format
I would like to do a dump of all the DBs in a postgres system in the manner
of pg_dumpall, but dumping the DBs out to individual files rather than one
big one, and using a binary dump to make individual table restores easier.
Can I do this with options to pg_dumpall (or some other command I have not
noticed), or do I need to take a copy and modify the copy to do what I need?
I am running a 7.2 system if that makes a difference.
Thanks in advance
David
I would suggest using pg_dumpall only to dump the global postgres info
and then use pg_dump with the -Fc option for the databases .From that
you can use pg_restore for individual tables.
Show quoted text
On Fri, 2003-03-28 at 08:24, David Goodenough wrote:
I would like to do a dump of all the DBs in a postgres system in the manner
of pg_dumpall, but dumping the DBs out to individual files rather than one
big one, and using a binary dump to make individual table restores easier.Can I do this with options to pg_dumpall (or some other command I have not
noticed), or do I need to take a copy and modify the copy to do what I need?I am running a 7.2 system if that makes a difference.
Thanks in advance
David
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
David Goodenough writes:
I would like to do a dump of all the DBs in a postgres system in the manner
of pg_dumpall, but dumping the DBs out to individual files rather than one
big one, and using a binary dump to make individual table restores easier.
for d in $(psql -At -c 'select datname from pg_database'); do pg_dump $d >$d.sql; done
--
Peter Eisentraut peter_e@gmx.net