Re: where I can find the error message for pgagent jobs

On Mon, Jun 11, 2018 at 10:12 AM, a <372660931(at)qq(dot)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

> 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(at)qq(dot)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(at)qq(dot)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(dot)vashi(at)enterprisedb(dot)com>;
>> *Send time:* Monday, Jun 11, 2018 12:39 PM
>> *To:* "a"<372660931(at)qq(dot)com>;
>> *Cc:* "pgsql-general"<pgsql-general(at)postgresql(dot)org>;
>> *Subject: * Re: where I can find the error message for pgagent jobs
>>
>>
>> Please use "pgadmin-support(at)postgresql(dot)org" for any pgAdmin/pgAgent
>> related questions, bugs.
>>
>> On Mon, Jun 11, 2018 at 9:33 AM, a <372660931(at)qq(dot)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.
>>>
>>
>>
>