pgAgent on workstation/client
От | Milan Cirovic |
---|---|
Тема | pgAgent on workstation/client |
Дата | |
Msg-id | 433319c50712240409j44a2ef4cv538272eb67c84ea4@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pgAgent on workstation/client
|
Список | pgsql-novice |
Hi,
I am using *.bat file for database backup on client/workstation. I run bat file from the same client machine manually. Contents of file are:
-----
cd C:\"Program Files"\"pgAdmin III"\1.8\
pg_dump -h host -U postgres -f "D:\dbackup\%date%.sql" dbasename
-----
Now, I want to automate process with pgAgent if possible. I have installed pgAgent from pgAdminIII running sql script as it is stated on http://www.pgadmin.org/docs/1.4/pgagent-install.html.
From command line, service is created: C:\"Program Files"\"pgAdmin III">pgAgent INSTALL pgAgent hostaddr= hos.tad.dre.ss dbname=dbasename user=postgres
Service is running.
Now, following online installation there should be jobs when I connect to database in which pgAgent is installed, but there are none. PgAgent is just in catalogs, no changes in schemas tree.
I did something wrong, or I should create jobs manually?
Regards
I am using *.bat file for database backup on client/workstation. I run bat file from the same client machine manually. Contents of file are:
-----
cd C:\"Program Files"\"pgAdmin III"\1.8\
pg_dump -h host -U postgres -f "D:\dbackup\%date%.sql" dbasename
-----
Now, I want to automate process with pgAgent if possible. I have installed pgAgent from pgAdminIII running sql script as it is stated on http://www.pgadmin.org/docs/1.4/pgagent-install.html.
From command line, service is created: C:\"Program Files"\"pgAdmin III">pgAgent INSTALL pgAgent hostaddr= hos.tad.dre.ss dbname=dbasename user=postgres
Service is running.
Now, following online installation there should be jobs when I connect to database in which pgAgent is installed, but there are none. PgAgent is just in catalogs, no changes in schemas tree.
I did something wrong, or I should create jobs manually?
Regards
В списке pgsql-novice по дате отправления: