Re: System dump, but not in the default format - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: System dump, but not in the default format
Date
Msg-id Pine.LNX.4.44.0303281502560.2204-100000@peter.localdomain
Whole thread Raw
In response to System dump, but not in the default format  (David Goodenough <david.goodenough@btconnect.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Georg Steffers
Date:
Subject: Re: Ideas, suggestions to rules (based on a real problem)
Next
From: Bruce Momjian
Date:
Subject: Re: DROP LANGUAGE error in pg_dump?