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. >> > >
