Dump all databases to corresponding files - Mailing list pgsql-general

From CSN
Subject Dump all databases to corresponding files
Date
Msg-id 20061106030353.49440.qmail@web52915.mail.yahoo.com
Whole thread Raw
Responses Re: Dump all databases to corresponding files  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Dump all databases to corresponding files  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Dump all databases to corresponding files  (Tomasz Ostrowski <tometzky@batory.org.pl>)
List pgsql-general
Anybody know of a script that dumps all databases into corresponding dump files, e.g.

$ ./dump
template0 -> template0.sql
template1 -> template1.sql
db1 -> db1.sql
db2 -> db2.sql
...

Also, would this approach add up to equal the output of pg_dumpall, or does pg_dumpall dump
additional things (if so, please describe how they'd also be dumped)?

Thanks,
csn



____________________________________________________________________________________
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates
(http://voice.yahoo.com)


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Need replacement booth member for USENIX Lisa
Next
From: "Merlin Moncure"
Date:
Subject: Re: Dump all databases to corresponding files