Re: pg_dump in cycle

Use pg_dump instead of pg_dumpall

example:
pg_dump databaseName > databaseDumpFile

if u have many databases, you can make a script that dumps each database in
it's own file ....



----- Original Message -----
From: "Ilia Chipitsine" <ilia@paramon.ru>
To: <pgsql-general@postgresql.org>
Sent: Thursday, September 16, 2004 8:08 AM
Subject: [GENERAL] pg_dump in cycle


> Dear Sirs,
>
> I want to dump all databases, but separately each database in its own
> file, not all databases in one single file as pg_dumpall does.
>
> How can I implement that ?
>
> Cheers,
> Ilia Chipitsine
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>