> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 13 April 2006 17:41
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> > Here is filemon log with filter pgagent
>
> Full log (with
> Here is filemon log with filter pgagent
Full log (without any filters applied) is added to this letter.
Andrus.
begin 666 unfiltered.zip
M4$L#!!0(`+F2[;,W8O\#GS="C*H"ZLMOLDC9BBN3NJ)L
[EMAIL PROTECTED](*26S)C*%)#TAY[-G9^^ZVN)JNK"IFG`&2BFWZ8\8<:IY#(/ `2!XG\
MF[S]UN3?ENTW=_+X[.R;TZ_WES?7=]
> Hmm, nothing useful there then. OK, can you grab filemon from
> www.sysinternals.com and try to capture the job failing please? With a
> little luck it'll show what filesystem operation is actually failing.
Here is filemon log with filter pgagent
1 19:17:08 pgagent.exe:2588 OPEN C:\DOCUME~1\po
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 13 April 2006 15:56
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> > Can you reinstall the agent service with the '-l 2' option
> Can you reinstall the agent service with the '-l 2' option (no quotes)
> and see if anything useful gets logged in the event log please?
Here is application log:
13.04.2006 17:46:25 pgAgent Information None 0 N/A STAR Clearing inactive
connections
13.04.2006 17:46:15 pgAgent Information None 0
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 13 April 2006 12:38
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> >> pgagent tries to execute 1_1.bat file !
> >
> > That's nor
>> Using pgAgent allows me to monitor backup status remotely
>> using pgadmin or making sql queries to pgagent schema,
>> without need to log-in and open RDP port in server.
>>
>> So I'd prefer to use pgAgent even for simple backup if possible.
>>
> Good point.
I receive error that could not execu
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 13 April 2006 11:43
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> > To be honest for a simple backup on the local machine
> yo
>> pgagent tries to execute 1_1.bat file !
>
> That's normal - the script you enter in pgAdmin is written to the
> temporary batch file at runtime and executed. That's required to allow
> you to target scripts at any agent host.
>
> So anyway, does C:\DOCUME~1\postgres\LOCAL~1\Temp\pgaD591.tmp\1_1.
> To be honest for a simple backup on the local machine you'll be better
> off running it from task scheduler. pgAgent is better suited to running
> batch processing jobs that may run on any one of a number of nodes, or
> SQL jobs that run directly on the database.
Using pgAgent allows me to monit
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 13 April 2006 10:25
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> >> Couldn't execute script
> >> C:DOCUME~1\postgres\LOCAL~1Te
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 13 April 2006 10:28
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> >> Couldn't execute script
> >> C:\DOCUME~1\postgres\LOCAL~1\
>> Couldn't execute script
>> C:DOCUME~1\postgres\LOCAL~1TemppgaD591.tmp1_1.bat
>
> Is that *exactly* what was displayed, or is your backslash key playing
> up?
Sorry. Some backslashes are missing. actially it is
C:\DOCUME~1\postgres\LOCAL~1\Temp\pgaD591.tmp\1_1.bat
Any idea how to make automati
>> Couldn't execute script
>> C:\DOCUME~1\postgres\LOCAL~1\Temp\pgaD591.tmp\1_1.bat
>
> Try to run CMD explicitely.
I changed definition window to
cmd /C c:\mydir\mybackup.bat
but error message remains the same.
pgagent tries to execute 1_1.bat file !
Andrus.
---(
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 12 April 2006 21:53
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] how to create backup copies
>
> Couldn't execute script
> C:DOCUME~1\postgres\LOCAL~1TemppgaD591
Andrus wrote:
I created a bat file mybackup.bat
set FAILINIMI=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%eevavarukoopia.backup
"C:\Program Files\pgAdmin III\1.4\pg_dump.exe" -i -Z9 -b -v -f
"C:\mydir\%FAILINIMI%" -F c -h localhost -U postgres mydb
and verified it using RUNAS that it runs OK under posg
16 matches
Mail list logo
