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

Re: Automating Postgres Backup

From: "gcj" <gauss21(at)comcast(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Automating Postgres Backup
Date: 2008-11-12 03:18:19
Message-ID: 23DEF153BB1942928D4A02372ED41141@Serotonin (view raw or whole thread)
Lists: pgsql-novice
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


Any suggestions on how to troubleshoot pgAgent?









From: Obe, Regina [mailto:robe(dot)dnd(at)cityofboston(dot)gov] 
Sent: Tuesday, November 11, 2008 8:27 AM
To: gcj
Subject: RE: [NOVICE] Automating Postgres Backup


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

Hope that helps,

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


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.




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


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

In response to


pgsql-novice by date

Next:From: Obe, ReginaDate: 2008-11-12 05:53:37
Subject: Re: Automating Postgres Backup
Previous:From: Steve HenryDate: 2008-11-12 01:37:35
Subject: Unable to connect to a server

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