Re: Dump all in several files

On Tue, 15 Mar 2005 12:15:39 -0400, Alvaro Herrera
<alvherre(at)dcc(dot)uchile(dot)cl> wrote:
> On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote:
> > Lonni J Friedman wrote:
> > >On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
> > ><frederic(at)juliana-multimedia(dot)com> wrote:
> > >
> > >>Hi,
> > >>
> > >>On the PostgreSQL 6.5 server I use this shell script (see below) for the
> > >>backup all of the database in several files, one file per database.
> > >
> > >Maybe i'm just not following you, but why can't you just do:
> > >pg_dump $DBNAME >$DB_NAME
> > >
> > >where $DB_NAME is the name of each database on the box?
> > >
> >
> > This script is called in a crontab the every day at 6 o'clock in the
> > morning.
>
> You can obtain the list of databases for scripting with
>
> psql -tlA | cut -d\| -f1
>

i didn't know that. very nice. try:

psql -Upostgres -tlA |cut -d\| -f1|xargs -i pg_dump -Upostgres -f
'{}'.dump.sql '{}'

javier