SEO

#1 (**permalink**) 04-17-2008, 07:24 PM

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto

gadmin-support-owner@postgresql.org] 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\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 !

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?

Regards, Dave.

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

#2 (**permalink**) 04-17-2008, 07:24 PM

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

Andrus.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: how to create backup copies