Dump all databases to corresponding files

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dump all databases to corresponding files
Date: 2006-11-06 03:03:53
Message-ID: 20061106030353.49440.qmail@web52915.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-11-06 03:12:35 Re: Dump all databases to corresponding files
Previous Message Joshua D. Drake 2006-11-06 02:28:42 Need replacement booth member for USENIX Lisa