> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailtogadmin-support-owner@postgresql.org] 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 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. bat
> > exist, and if so what's in it?
>
> This directory does not exist.
> Only C:\DOCUME~1\postgres\LOCAL~1\Temp directory exists.
>
> I verified, user postgres has Full Control rights to
> C:\DOCUME~1\postgres directory.

I setup your batch files as closely as I could here and with the
exception of the date code it all worked perfectly (the date code
included /'s here - I assume that's not an issue for you).

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?

Thanks, Dave.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

> 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 N/A STAR Sleeping...
13.04.2006 17:46:15 pgAgent Information None 0 N/A STAR Checking for jobs to
run
13.04.2006 17:46:06 pgAgent Information None 0 N/A STAR Destroying job
thread for job 1
13.04.2006 17:46:06 pgAgent Information None 0 N/A STAR Completed job: 1
13.04.2006 17:46:06 pgAgent Information None 0 N/A STAR Returning connection
to database postgres
13.04.2006 17:46:05 pgAgent Warning None 0 N/A STAR Couldn't execute script:
C:\DOCUME~1\postgres\LOCALS~1\Temp\pgaD7AC.tmp\1_1 .bat
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Executing script
file: C:\DOCUME~1\postgres\LOCALS~1\Temp\pgaD7AC.tmp\1_1 .bat
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Executing batch step
1 (part of job 1)
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Sleeping...
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Starting job: 1
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Allocating new
connection to database postgres
13.04.2006 17:46:03 pgAgent Information None 0 N/A STAR Creating DB
connection: hostaddr=127.0.0.1 user=postgres password=secret
dbname=postgres