Re: pgAgent service problem - Mailing list pgadmin-support

From Sabin Coanda
Subject Re: pgAgent service problem
Date
Msg-id ete6r0$2pea$1@news.hub.org
Whole thread Raw
In response to pgAgent service problem  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Responses Re: pgAgent service problem  (Dave Page <dpage@postgresql.org>)
List pgadmin-support
...
> No idea, noone ever reported such a crash before. Can you supply a level
> 2 (debug) log from when the crash occurs? A pg_dump of your pgagent
> schema would help as well.
>
> Regards, Dave

Hi Dave,

I just captured the significant event log sequence and I attached it.
However, I found that sometimes it runs well at the same job step.

The step command is the following:
"C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -F p -v -U 
postgres -d -D -f "C:\Program 
Files\PostgreSQL\8.2\data\bak\dipDB_%DATE:~0,2%%DATE:~3,2%%DATE:~6,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%.sql" 
"dbTest_local"

Regards, Sabin 


begin 666 0703161530_pgagentEvent.zip
M4$L#!!0````(`#Q\<#;P:D%#9 $``,P#```O````,#<M,#,M,38@179E;G0@
M3&]G<R\P-S S,38Q-3,P7W!G86=E;G1%=F5N="YT>'2MDEUKPC 4AJ\C^!_.
MI8)DB46+!2_JQT!P>N%V)XRT/:W=:A*2=/-JOWVI'R"[&E0"(0G)\S[D'#ZF
M+*!#QD+"1U' (LY)K'55IL*52L+2&&7(9>YQQOK$3XQLGF*RBV>K#7D6=>5*
M68"X>Z6+N$#I*)YP`%]H;'/(Z9@.Z60R@/SVYJBRNL)_70>190:M!7;R`FS$
M\HQV._RO/AN1*XVL9*[,\2Q$-DHBN==>GC"MSPXV-:5VD)<51C"/]HOM_.UE
M^</W5B2EW*^W\WB]\]M7/.J]+D0P&U/GE\%[2!/A'N+@.>D!K$,-(?2T, Y4
M#A\J@:#?(F!7(6K/I[3-5^V<]VDLO4\$00M27%6JZ1#/DO@-J9(2TW/#. 69
M<"(1UG>#LJ[PI6X1-#=XB5G,[E(B.'ATTT=3/@PI\X,#U!;-])8)62+%$:>/
M=&C*Z Y^EX&_?JEJ&^X!T\^&>X79YO-,+;N=7U!+`0(4`!0````(`#Q\<#;P
M:D%#9 $``,P#```O``````````$`( `````````P-RTP,RTQ-B!%=F5N="!,
M;V=S+S W,#,Q-C$U,S!?<&=A9V5N=$5V96YT+G1X=%!+!08``````0`!`%T`
(``"Q`0``````
`
end



pgadmin-support by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: pgAgent service problem
Next
From: Dave Page
Date:
Subject: Re: pgAgent service problem