where I can find the error message for pgagent jobs

Please use "pgadmin-support@postgresql.org" for any pgAdmin/pgAgent related
questions, bugs.

On Mon, Jun 11, 2018 at 9:33 AM, a <372660931@qq.com> wrote:

Hi all

I set up a pgagent job, but it says the job was failed.

But where I can have a look on error report message??

I'm using pgadmin 4.3, pgagent 3.4, postgresql 10, the platform is windows
server 2008

You can find them in window's EventViewer.

-- Thanks, Ashesh

Hey thanks so much.

I found the error msg as "Couldn't get a connection to the database!"

I've searched internet with the issue, some may say replace pgpass.conf as follow:

"localhost:5432:[dbname]:postgres:[password]"

but after I changed, the job returns a "i" as last result, which is a internal failure if I'm not wrong.

do you have any idea of how to get it work?

------------------ Original ------------------
From: "Ashesh Vashi";<ashesh.vashi@enterprisedb.com>;
Send time: Monday, Jun 11, 2018 12:39 PM
To: "a"<372660931@qq.com>;
Cc: "pgsql-general"<pgsql-general@postgresql.org>;
Subject: Re: where I can find the error message for pgagent jobs

Please use "pgadmin-support@postgresql.org" for any pgAdmin/pgAgent related questions, bugs.

On Mon, Jun 11, 2018 at 9:33 AM, a <372660931@qq.com> wrote:
Hi all

I set up a pgagent job, but it says the job was failed.

But where I can have a look on error report message??

I'm using pgadmin 4.3, pgagent 3.4, postgresql 10, the platform is windows server 2008
You can find them in window's EventViewer.

-- Thanks, Ashesh

Thank you so much.

On Mon, Jun 11, 2018 at 9:56 AM, a <372660931@qq.com> wrote:

Hey thanks so much.

I found the error msg as "Couldn't get a connection to the database!"

I've searched internet with the issue, some may say replace pgpass.conf as
follow:

"*localhost:5432:[dbname]:postgres:[password]*"

but after I changed, the job returns a "i" as last result, which is a
internal failure if I'm not wrong.

do you have any idea of how to get it work?

Please share the content of the table: 'pgagent.pga_jobsteplog'.

-- Thanks, Ashesh

Hey, the following is the table :
1 1 1 "f" 1 "2018-06-11 11:38:33.163731+08" "00:00:00.033002" "Couldn't get a connection to the database!"
2 2 1 "f" 1 "2018-06-11 11:45:03.406061+08" "00:00:00.033002" "Couldn't get a connection to the database!"
3 3 1 "f" 1 "2018-06-11 11:46:53.543062+08" "00:00:00.034002" "Couldn't get a connection to the database!"
4 63 1 "f" 1 "2018-06-11 12:19:06.21886+08" "00:00:00.033002" "Couldn't get a connection to the database!"
5 147 1 "f" -1 "2018-06-11 12:35:10.29625+08" "00:00:00.046003" "ERROR: column "?¤???????????????·" does not exist
LINE 4: ?¤???????????????·,
^"
6 148 1 "f" -1 "2018-06-11 12:36:30.354773+08" "00:00:00.040002" "ERROR: column "?¤???????????????·" does not exist
LINE 4: ?¤???????????????·,
^"
7 149 1 "s" 0 "2018-06-11 12:42:05.508192+08" "00:00:00.69604"

I actually restarted the service and it works. But the chinese character is the pain in ass........

------------------ Original message ------------------
From: "Ashesh Vashi";
Sendtime: Monday, Jun 11, 2018 1:03 PM
To: "a"<372660931@qq.com>;
Cc: "pgsql-general";
Subject: Re: where I can find the error message for pgagent jobs

On Mon, Jun 11, 2018 at 9:56 AM, a <372660931@qq.com> wrote:

Hey thanks so much.

I found the error msg as "Couldn't get a connection to the database!"

I've searched internet with the issue, some may say replace pgpass.conf as follow:

"localhost:5432:[dbname]:postgres:[password]"

but after I changed, the job returns a "i" as last result, which is a internal failure if I'm not wrong.

do you have any idea of how to get it work?

Please share the content of the table: 'pgagent.pga_jobsteplog'.

-- Thanks, Ashesh

------------------ Original ------------------
From: "Ashesh Vashi";<ashesh.vashi@enterprisedb.com>;
Send time: Monday, Jun 11, 2018 12:39 PM
To: "a"<372660931@qq.com>;
Cc: "pgsql-general"<pgsql-general@postgresql.org>;
Subject: Re: where I can find the error message for pgagent jobs

Please use "pgadmin-support@postgresql.org" for any pgAdmin/pgAgent related questions, bugs.

On Mon, Jun 11, 2018 at 9:33 AM, a <372660931@qq.com> wrote:
Hi all

I set up a pgagent job, but it says the job was failed.

But where I can have a look on error report message??

I'm using pgadmin 4.3, pgagent 3.4, postgresql 10, the platform is windows server 2008
You can find them in window's EventViewer.

-- Thanks, Ashesh

Thank you so much.

On Mon, Jun 11, 2018 at 10:12 AM, a <372660931@qq.com> wrote:

Hey, the following is the table :
1 1 1 "f" 1 "2018-06-11 11:38:33.163731+08" "00:00:00.033002" "Couldn't
get a connection to the database!"
2 2 1 "f" 1 "2018-06-11 11:45:03.406061+08" "00:00:00.033002" "Couldn't
get a connection to the database!"
3 3 1 "f" 1 "2018-06-11 11:46:53.543062+08" "00:00:00.034002" "Couldn't
get a connection to the database!"
4 63 1 "f" 1 "2018-06-11 12:19:06.21886+08" "00:00:00.033002" "Couldn't
get a connection to the database!"
5 147 1 "f" -1 "2018-06-11 12:35:10.29625+08" "00:00:00.046003" "ERROR:
column "?¤???????????????·" does not exist
LINE 4: ?¤???????????????·,
^"
6 148 1 "f" -1 "2018-06-11 12:36:30.354773+08" "00:00:00.040002" "ERROR:
column "?¤???????????????·" does not exist
LINE 4: ?¤???????????????·,
^"
7 149 1 "s" 0 "2018-06-11 12:42:05.508192+08" "00:00:00.69604"

I actually restarted the service and it works.

Yeah - that's probably.
You may have changed the pgpass.conf file, which was not loaded again
without restart.

-- Thanks, Ashesh