From: | javier wilson <javier(dot)wilson(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dump all in several files |
Date: | 2005-03-15 16:14:00 |
Message-ID: | da884c20050315081438f5453d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 15 Mar 2005 17:01:39 +0100, Frederic Massot
<frederic(at)juliana-multimedia(dot)com> 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.
i have a /etc/backup/data.pgsql where i list all databases
i want to dump, then a script in /etc/cron.daily reads this file
and call pg_dump:
pg_dump -U postgres $1>$1.dump.sql
javier
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-03-15 16:15:39 | Re: Dump all in several files |
Previous Message | Frederic Massot | 2005-03-15 16:01:39 | Re: Dump all in several files |