PostgreSQL automatic backup

Posted by Ragnar123 on Server Fault See other posts from Server Fault or by Ragnar123
Published on 2011-04-18T00:21:40Z Indexed on 2012/12/15 5:09 UTC
Read the original article Hit count: 533

I have been trying to set up a backup script on a windows server. I have used pgAgent (scheduling for pgAdmin), to run the backup script. No problems with the backup script.

However, my jobs are not running like they should. I have set both the schedule, and the steps.

I am fairly certain, that I am running the service under a wrong user or a user without the required permissions.

I run the service like this: "C:\Program Files\pgAdmin III\pgAgent" INSTALL pgAgent -u postgres -p secret hostaddr=127.0.0.1 dbname=pgadmin user=postgres

And I get an error, telling me that there was an error with the login information, though I know it's correct. When I go under services (controlpanel --> administration --> services), I am able to start the service with the local user.

Can this be the problem?

Where can I see or change the permissions on the postgres user?

© Server Fault or respective owner

Related posts about windows-server-2008-r2

Related posts about postgresql