Thread: PgAgent Installation ERROR

Hi,<br /><br />I am trying to install the service (<span class="il">pgAgent</span>) on windows vista and xp<br
/>gettingthe following error<br /><br />D:\Program Files\PostgreSQL\8.3\bin><div class="ii gt" id=":2on"><span
class="il">pgAgent</span>INSTALL <span class="il">pgAgent</span><br /> 18:49:18: Error: Can't open registry key
'HKLM\SYSTEM\CurrentControlSet\Services<br/> \EventLog\Application\<span class="il">pgAgent</span>' (error 5: access is
denied.)<br/>18:49:18: Error: Can't set value of 'HKLM\SYSTEM\CurrentControlSet\Services\Even<br
/>tLog\Application\<spanclass="il">pgAgent</span>\EventMessageFile' (error 5: access is denied.)<br /> 18:49:18: Error:
Can'topen registry key 'HKLM\SYSTEM\CurrentControlSet\Services<br />\EventLog\Application\<span
class="il">pgAgent</span>'(error 5: access is denied.)<br />18:49:18: Error: Can't set value of
'HKLM\SYSTEM\CurrentControlSet\Services\Even<br/> tLog\Application\<span class="il">pgAgent</span>\TypesSupported'
(error5: access is denied.)<br /><br />Please suggest/advise. Is there any simple exe file which could install this?<br
clear="all"/></div><br clear="all" /><br />-- <br />Kranti K K Parisa<br />M: +91 - 9391 - 438 - 738<br />O: +91 - 4023
-844 - 738<br />------------------------------------------------------------------<br />" world will be different,
if......"<br />------------------------------------------------------------------<br />            <br /> 

2009/5/4 Kranti™ K K Parisa <kranti.parisa@gmail.com>:
> Hi,
>
> I am trying to install the service (pgAgent) on windows vista and xp
> getting the following error
>
> D:\Program Files\PostgreSQL\8.3\bin>
> pgAgent INSTALL pgAgent
> 18:49:18: Error: Can't open registry key
> 'HKLM\SYSTEM\CurrentControlSet\Services
> \EventLog\Application\pgAgent' (error 5: access is denied.)
> 18:49:18: Error: Can't set value of
> 'HKLM\SYSTEM\CurrentControlSet\Services\Even
> tLog\Application\pgAgent\EventMessageFile' (error 5: access is denied.)
> 18:49:18: Error: Can't open registry key
> 'HKLM\SYSTEM\CurrentControlSet\Services
> \EventLog\Application\pgAgent' (error 5: access is denied.)
> 18:49:18: Error: Can't set value of
> 'HKLM\SYSTEM\CurrentControlSet\Services\Even
> tLog\Application\pgAgent\TypesSupported' (error 5: access is denied.)
>
> Please suggest/advise. Is there any simple exe file which could install
> this?

Yes, pgagent.exe. You need administrative privileges to install
though. On vista, you may need to open the command prompt with the
'Run as Administrator' option, even if your account has administrative
privileges.


--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Hi Dave<br /><br />Thanks for the reply I shall try on this<br />I have done that on xp and it has worked.<br /><br
/>However the file generated is with 0kb. please suggest what next to be checked?<br /><br /><div
class="gmail_quote">2009/5/4Dave Page <span dir="ltr"><<a
href="mailto:dpage@pgadmin.org">dpage@pgadmin.org</a>></span><br/><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">2009/5/4 Kranti™ K K
Parisa<<a href="mailto:kranti.parisa@gmail.com">kranti.parisa@gmail.com</a>>:<br /><div class="im">> Hi,<br />
><br/> > I am trying to install the service (pgAgent) on windows vista and xp<br /> > getting the following
error<br/> ><br /> > D:\Program Files\PostgreSQL\8.3\bin><br /> > pgAgent INSTALL pgAgent<br /> >
18:49:18:Error: Can't open registry key<br /> > 'HKLM\SYSTEM\CurrentControlSet\Services<br /> >
\EventLog\Application\pgAgent'(error 5: access is denied.)<br /> > 18:49:18: Error: Can't set value of<br /> >
'HKLM\SYSTEM\CurrentControlSet\Services\Even<br/> > tLog\Application\pgAgent\EventMessageFile' (error 5: access is
denied.)<br/> > 18:49:18: Error: Can't open registry key<br /> > 'HKLM\SYSTEM\CurrentControlSet\Services<br />
>\EventLog\Application\pgAgent' (error 5: access is denied.)<br /> > 18:49:18: Error: Can't set value of<br />
>'HKLM\SYSTEM\CurrentControlSet\Services\Even<br /> > tLog\Application\pgAgent\TypesSupported' (error 5: access
isdenied.)<br /> ><br /> > Please suggest/advise. Is there any simple exe file which could install<br /> >
this?<br/><br /></div>Yes, pgagent.exe. You need administrative privileges to install<br /> though. On vista, you may
needto open the command prompt with the<br /> 'Run as Administrator' option, even if your account has administrative<br
/>privileges.<br /><font color="#888888"><br /><br /> --<br /> Dave Page<br /> EnterpriseDB UK:   <a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a><br /></font></blockquote></div><br
/><brclear="all" /><br />-- <br />Kranti K K Parisa<br />M: +91 - 9391 - 438 - 738<br />O: +91 - 4023 - 844 - 738<br
/>------------------------------------------------------------------<br/>" world will be different, if...... "<br />
------------------------------------------------------------------<br/>            <br /> 

2009/5/4 Kranti™ K K Parisa <kranti.parisa@gmail.com>:
> Hi Dave
>
> Thanks for the reply I shall try on this
> I have done that on xp and it has worked.
>
> How ever the file generated is with 0kb. please suggest what next to be
> checked?

What file generated? Registering the service doesn't generate any files.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Registering file is done and then defined the bat file and created a job. the backup file is getting generated but its of 0kb

plz check the following for the bat file content

--------------
@echo off
REM - backup directory can be a file server share that the PgAgent windows service account has access to
set BACKUPDIR="E:/POSTGRESJOBS/DAILYBACKUPS/"
set PGHOST="localhost"
set PGPORT="5433"
set PGUSER="postgres"
set PGBIN="C:/Program Files/PostgreSQL/8.3/bin/"
for /f "tokens=1-4 delims=/ " %%i in ("%date%") do (
 set dow=%%i
 set month=%%j
 set day=%%k
 set year=%%l
)

for /f "tokens=1-3 delims=: " %%i in ("%time%") do (
 set hh=%%i
 set nn=%%j
)

REM - It would be nice to use gzip in the pg_dumpall call (or if pg_dumpall supported compression as does the pg_dump)
REM here as we do on the linux/unix script
REM - but gzip is not prepackaged with windows so requires a separate install/download.
REM Our favorite all purpose compression/uncompression util for Windows is 7Zip which does have a command-line
%PGBIN%pg_dump -i -h %PGHOST% -p %PGPORT% -U %PGUSER% -F c -b -v -f "%BACKUPDIR%DATABASENAME-%year%%month%%day%%hh%.backup" DATABASENAME

--------------------------





--
Kranti K K Parisa
M: +91 - 9391 - 438 - 738
O: +91 - 4023 - 844 - 738
------------------------------------------------------------------
" world will be different, if...... "
------------------------------------------------------------------
           

hmm ok. but that command gives a proper compressed file if i run on command line.
am worried now :(

please guide me, if i have to check anything else




--
Kranti K K Parisa
M: +91 - 9391 - 438 - 738
O: +91 - 4023 - 844 - 738
------------------------------------------------------------------
" world will be different, if...... "
------------------------------------------------------------------
           

2009/5/4 Kranti™ K K Parisa <kranti.parisa@gmail.com>:
> Registering file is done and then defined the bat file and created a job.
> the backup file is getting generated but its of 0kb
>
> plz check the following for the bat file content

Looks fine to my eyes - you'll need to check the output from the
pg_dump command for errors.



--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Hi,

I am not yet able to get the backup file.

When I run the command thru command prompt able to get the backup file(without asking the password as I have passed an entry in pgpass.conf file) of 1mb in size. but when I use RUN NOW from aggent job getting the file generated in the given directory but its of 0kb in size.

did i miss any other steps?




--
Kranti K K Parisa
M: +91 - 9391 - 438 - 738
O: +91 - 4023 - 844 - 738
------------------------------------------------------------------
" world will be different, if...... "
------------------------------------------------------------------
           

On 05/05/2009 10:47, Kranti™ K K Parisa wrote:

> When I run the command thru command prompt able to get the backup
> file(without asking the password as I have passed an entry in pgpass.conf
> file) of 1mb in size. but when I use RUN NOW from aggent job getting the
> file generated in the given directory but its of 0kb in size.

I don't know anything about pgAgent, but it sounds as if the job is
failing for some reason and writing an empty file. Are there any logs
you can check? - maybe the Windows event log or the PostgreSQL log?
Also, what about permissions on the output directory - has the backup
process got permission to write there?

Just wild guesses....

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Hi,<br /><br />I have got it worked from another way. written a shell scrip and created an exe for that<br />Now
defineda windows task scheduler and given this exe file, its doing the backup perfectly. Also provided a link in
applicationfor super user, once clicked we are calling a java runtime proces and calling the exe which is generating
thebakup.<br /><br /><div class="gmail_quote">2009/5/5 Raymond O'Donnell <span dir="ltr"><<a
href="mailto:rod@iol.ie">rod@iol.ie</a>></span><br/><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204,204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">On 05/05/2009 10:47, Kranti™ K K
Parisawrote:<br /><br /> > When I run the command thru command prompt able to get the backup<br /> > file(without
askingthe password as I have passed an entry in pgpass.conf<br /> > file) of 1mb in size. but when I use RUN NOW
fromaggent job getting the<br /> > file generated in the given directory but its of 0kb in size.<br /><br /></div>I
don'tknow anything about pgAgent, but it sounds as if the job is<br /> failing for some reason and writing an empty
file.Are there any logs<br /> you can check? - maybe the Windows event log or the PostgreSQL log?<br /> Also, what
aboutpermissions on the output directory - has the backup<br /> process got permission to write there?<br /><br /> Just
wildguesses....<br /><br /> Ray.<br /><br /><br />
------------------------------------------------------------------<br/><font color="#888888">Raymond O'Donnell,
Directorof Music, Galway Cathedral, Ireland<br /><a href="mailto:rod@iol.ie">rod@iol.ie</a><br /> Galway Cathedral
Recitals:<a href="http://www.galwaycathedral.org/recitals"
target="_blank">http://www.galwaycathedral.org/recitals</a><br/>
------------------------------------------------------------------<br/></font></blockquote></div><br /><br clear="all"
/><br/>-- <br />Kranti K K Parisa<br />M: +91 - 9391 - 438 - 738<br />O: +91 - 4023 - 844 - 738<br
/>------------------------------------------------------------------<br/>" world will be different, if...... "<br />
------------------------------------------------------------------<br/>            <br />