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(at)paramon(dot)ru>
To: <pgsql-general(at)postgresql(dot)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
>