Re: Automating Postgres Backup - Mailing list pgsql-novice

From Obe, Regina
Subject Re: Automating Postgres Backup
Date
Msg-id 53F9CF533E1AA14EA1F8C5C08ABC08D204D7F00A@ZDND.DND.boston.cob
Whole thread Raw
In response to Automating Postgres Backup  ("gcj" <gauss21@comcast.net>)
Responses Re: connecting /sharing tables across databases
List pgsql-novice

I use pgAgent packaged with PostgreSQL to schedule pg_dump backups.  Pg_dump doesn't require the db to be offline.  The nice thing about PgAgent is that it works
both on Linux and Windows.


Here is a quick primer on how to do it
http://www.postgresonline.com/journal/index.php?/archives/19-Setting-up-PgAgent-and-Doing-Scheduled-Backups.html

Hope that helps,
Regina


-----Original Message-----
From: pgsql-novice-owner@postgresql.org on behalf of gcj
Sent: Tue 11/11/2008 10:23 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Automating Postgres Backup

Hi,



I'm using Postgres 8.3 on Windows Server to store data from an Apache/Tomcat
Web Application.  I'm using pg_dump to backup the database manually on a
daily basis.



Can someone recommend a solution or 3rd party application to automate the
backup process?  Ideally, I would like to do this without taking the
application off-line.



Thanks,



gcj




The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.


Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper.

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: Automating Postgres Backup
Next
From: "gcj"
Date:
Subject: Re: Automating Postgres Backup