Re: pg_dump in cycle - Mailing list pgsql-general

From Najib Abi Fadel
Subject Re: pg_dump in cycle
Date
Msg-id 007b01c49bd0$afe41600$f664a8c0@najib
Whole thread Raw
In response to pg_dump in cycle  (Ilia Chipitsine <ilia@paramon.ru>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: "Leonardo Francalanci"
Date:
Subject: table partitioning
Next
From: "Najib Abi Fadel"
Date:
Subject: Re: pg_dump in cycle