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: | AANLkTik6zYKUb5ZOOqe-GDqtX3NWmG33PuSCGS+XZaqi@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
Windows::
http://wiki.postgresql.org/wiki/Automated_Backup_on_Windows
--Raghu Ram
> Respectfully,
> Jorge Maldonado
>
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Barnes | 2011-03-07 21:04:17 | Re: Simple table creation |
Previous Message | JORGE MALDONADO | 2011-03-07 18:18:54 | Backing up several databases |