On Mon, Jun 11, 2018 at 10:12 AM, a <372660...@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 > But the chinese character is the pain in ass........ > > > ------------------ Original message ------------------ > *From:* "Ashesh Vashi"; > *Sendtime:* Monday, Jun 11, 2018 1:03 PM > *To:* "a"<372660...@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 <372660...@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.va...@enterprisedb.com>; >> *Send time:* Monday, Jun 11, 2018 12:39 PM >> *To:* "a"<372660...@qq.com>; >> *Cc:* "pgsql-general"<pgsql-gene...@postgresql.org>; >> *Subject: * Re: where I can find the error message for pgagent jobs >> >> >> Please use "pgadmin-supp...@postgresql.org" for any pgAdmin/pgAgent >> related questions, bugs. >> >> On Mon, Jun 11, 2018 at 9:33 AM, a <372660...@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. >>> >> >> >
