Re: Automating Postgres Backup

Thank you very much for your suggestion.  I read the information in the link you sent.

I installed pgAgent, got the Windows PostgreSQL Scheduling Agent service running using an administrator account, created a pgpass.conf file with my server’s settings and password, and created a script file to run pg_dump.

Unfortunately, my pgAgent job shows “Last Result” as running, but never creates the backup file.  I can run the script file manually by double-clicking it – it prompts me for a password and after I enter it, I get my pg_dump export file.

I’m not sure what I’m missing – my pgpass.conf file is in c:\users\adminuser\AppData\postgresql\ and the scheduling agent service is running.

Any suggestions on how to troubleshoot pgAgent?

Regards,

gcj

I use pgAgent packaged with PostgreSQL to schedule pg_dump backups.  Pg_dump doesn't require the db to be offline.


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