Re: Dump all in several files

From: Frederic Massot <frederic(at)juliana-multimedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump all in several files
Date: 2005-03-15 16:01:39
Message-ID: d170t3$den$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
==============================================
| FREDERIC MASSOT |
| http://www.juliana-multimedia.com |
| mailto:frederic(at)juliana-multimedia(dot)com |
===========================Debian=GNU/Linux===

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message javier wilson 2005-03-15 16:14:00 Re: Dump all in several files
Previous Message Lonni J Friedman 2005-03-15 15:54:01 Re: Dump all in several files