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: 530
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