Skip site navigation (1) Skip section navigation (2)

Re: Backing up several databases

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Backing up several databases
Date: 2011-03-07 18:54:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Mon, Mar 7, 2011 at 11:48 PM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>wrote:

> I have several PostgreSQL databases in a server. Please recommend a
> procedure to get a backup of each one of them automatically. I would like to
> run a backup process from Monday to Sunday so I can have 7 backups for each
> DB.
> pgAdmin III is a good choice to perform this task manually but my
> application hosts one database per client and, in the long run, it would be
> inefficient to do it this way. I guess that having a pg_dump command for
> each database running in a batch file could be an answer but I wonder if
> there is any disadvantage doing it this way. Also, I do not know if pg_dump
> commands can be run in a batch file.

Try to follow the below link to get more details on automated backup on

--Raghu Ram

> Respectfully,
> Jorge Maldonado

In response to

pgsql-novice by date

Next:From: Craig BarnesDate: 2011-03-07 21:04:17
Subject: Re: Simple table creation
Previous:From: JORGE MALDONADODate: 2011-03-07 18:18:54
Subject: Backing up several databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group