Thread: pgagent jobs Could not connect to the database !

pgagent jobs Could not connect to the database !

From
sambsa
Date:
I have created a job using pgagent as follows:

<http://postgresql.nabble.com/file/n5834094/pic1.png>
<http://postgresql.nabble.com/file/n5834094/pic2.png>
<http://postgresql.nabble.com/file/n5834094/pic3.png>
<http://postgresql.nabble.com/file/n5834094/pic4.png>

But when I am running the job I am getting error as follows:
<http://postgresql.nabble.com/file/n5834094/pic5.png>
<http://postgresql.nabble.com/file/n5834094/pic6.png>

Error is like the following:

Could not connect to the database !

Please help me guys. How can I solve this??



--
View this message in context:
http://postgresql.nabble.com/pgagent-jobs-Could-not-connect-to-the-database-tp5834094.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: pgagent jobs Could not connect to the database !

From
Adrian Klaver
Date:
On 01/15/2015 08:07 AM, sambsa wrote:
> I have created a job using pgagent as follows:

Did you install the pgAgent daemon/service?:

http://www.pgadmin.org/docs/dev/pgagent-install.html#daemon-installation-on-unix

>
> <http://postgresql.nabble.com/file/n5834094/pic1.png>
> <http://postgresql.nabble.com/file/n5834094/pic2.png>
> <http://postgresql.nabble.com/file/n5834094/pic3.png>
> <http://postgresql.nabble.com/file/n5834094/pic4.png>
>
> But when I am running the job I am getting error as follows:
> <http://postgresql.nabble.com/file/n5834094/pic5.png>
> <http://postgresql.nabble.com/file/n5834094/pic6.png>
>
> Error is like the following:
>
> Could not connect to the database !
>
> Please help me guys. How can I solve this??
>
>
>
> --
> View this message in context:
http://postgresql.nabble.com/pgagent-jobs-Could-not-connect-to-the-database-tp5834094.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com