System dump, but not in the default format

From: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: System dump, but not in the default format
Date: 2003-03-28 13:24:34
Message-ID: 20030328132457.1A7B047633A@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Rust 2003-03-28 13:25:14 User based permission on a table
Previous Message Ian Barwick 2003-03-28 10:36:26 Re: DOES THE UNDERSCORE(_) WILD CARD EXISTS IN POSTGRESQL