Postgres Pro
Downloads
Home   >   mailing lists

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

From David Goodenough
Subject System dump, but not in the default format
Date
Msg-id 20030328132457.1A7B047633A@postgresql.org
Whole thread Raw
Responses Re: System dump, but not in the default format  (Dave Smith <dave.smith@candata.com>)
Re: System dump, but not in the default format  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ian Barwick
Date:
Subject: Re: DOES THE UNDERSCORE(_) WILD CARD EXISTS IN POSTGRESQL
Next
From: Andreas Rust
Date:
Subject: User based permission on a table