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: 17 April 2006 16:35
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> > Well, pgAgent creates and deletes the file as it should.
> Can you try
> > it with your AV disabled though please? The log shows some
> interaction
> > between it and pgAgent (though I'm not sure what exactly).
>
> I stopped Symantec antivirus process but the error message is
> still the same.
> Filemon log included.

:-(

Do you mind if I send you a custom built pgagent.exe? I want to remove
the cleanup code in this particular failure case so it leaves the
temporary file/directory behind for examination.

A couple of other things - what OS/service pack level is this, and was
your service user (postgres?) created by the pgInstaller PostgreSQL
distribution? If now, what user rights have your assigned (logon as a
server/batch job etc?).

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

> Do you mind if I send you a custom built pgagent.exe? I want to remove
> the cleanup code in this particular failure case so it leaves the
> temporary file/directory behind for examination.

Yes, I can run it.

It may be reasonable to add button to Step window which runs the step and
displays output
in window like in backup/restore commands.

> A couple of other things - what OS/service pack level is this,

Microsoft Windows 2000
5.00.2195
Service Pack 4

> and was
> your service user (postgres?) created by the pgInstaller PostgreSQL
> distribution?

I created postgres user manually since pgInstaller does not run from RDP
client
(Magnus wrote in pgsql.general that this issue will be addressed in 8.1.4)

> If now, what user rights have your assigned (logon as a
> server/batch job etc?).

Active Directory "Member Of" page shows that user postgres is member of the
following groups:

Account Operators
MYCOMPANY
Domain Computers
Domain Controllers
Domain Users
Pre-Windows 2000 Compatible Access
Server Operators
Users

Andrus.

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

Dave Page wrote:
>
>
> :-(
>
> Do you mind if I send you a custom built pgagent.exe? I want to remove
> the cleanup code in this particular failure case so it leaves the
> temporary file/directory behind for examination.

How about a debug option for that.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

> Yes, I can run it.

I entered to the step definition window

c:\mydir\mysubdir\mybackup.bat

and ran pgagent.

1_1.bat file now remains and contains line

c:\mydir\mysubdir\mybackup.bat

I executed from cmd line

runas /user:mydomain\postgres cmd

cd "C:\Document and settings\ postgres\Local Settings\temp\pda48EB.tmp"

1_1.bat

and pg_dump.exe creates backup file

So running 1_1.bat manually as user postgres works OK.

Andrus.

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

> I entered to the step definition window
>
> c:\mydir\mysubdir\mybackup.bat
>
> and ran pgagent.
>
> 1_1.bat file now remains and contains line
>
> c:\mydir\mysubdir\mybackup.bat
>
> I executed from cmd line
>
> runas /user:mydomain\postgres cmd
>
> cd "C:\Document and settings\ postgres\Local Settings\temp\pda48EB.tmp"
>
> 1_1.bat
>
>
> and pg_dump.exe creates backup file
>
>
> So running 1_1.bat manually as user postgres works OK.

Application log contains

Could'nt execute script C:\DOCUME~1\postgres\.... GetLastError() returned
183, errno = 0

Andrus.

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

> Application log contains
>
> Could'nt execute script C:\DOCUME~1\postgres\.... GetLastError() returned
> 183, errno = 0

From

http://msdn.microsoft.com/library/de...c_._wpopen.asp

Note If used in a Windows program, the _popen function returns an invalid
file pointer that will cause the program to hang indefinitely. _popen works
properly in a Console application. To create a Windows application that
redirects input and output, see Creating a Child Process with Redirected
Input and Output in the Platform SDK

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