Re: Starting PostgreSQL as an NT Service

running pg_ctl from postgres account gives :

D:\pgsql\bin>LOG: could not recognize system timezone, defaulting to
"Etc/GMT-1"
HINT: You can specify the correct timezone in postgresql.conf.
LOG: database system was shut down at 2004-06-30 21:42:59 Central European
Daylight Time
LOG: checkpoint record is at 0/A76CC0
LOG: redo record is at 0/A76CC0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 492; next OID: 17227
LOG: database system is ready

,so it is working...

loged in again, unregistered service, set the PGDATA, registered service as:
pg_ctl register -N postgres -U postgres -P elephant5432
but the error is still here :-(
I'll try to figure out what is wrong by putting some debug messages inside
"find_other_exec" function.

Regards !

----- Original Message -----
From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Darko Prenosil" <Darko(dot)Prenosil(at)finteh(dot)hr>
Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
Sent: Wednesday, June 30, 2004 11:08 PM
Subject: Re: [pgsql-hackers-win32] Starting PostgreSQL as an NT Service

Darko Prenosil wrote:
> I registerd the service using the bat file:
>
> d:
> cd pgsql\bin
> "pg_ctl.exe" unregister -N postgres
> "d:\pgsql\bin\pg_ctl.exe" register -N postgres -U postgres -P
> elephant5432 -D d:\pgsql\data"
> net start postgres
>
> I got :
> The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be
> found.
> The local computer may not have the necessary registry information or
> message DLL files to display messages from a remote computer. The
> following
> information is part of the event: Unable to find exe.
>
> message written to event viewer.
>
> d:\pgsql\bin is in the path.
>
> Path to executable in the service manager is:
>
> d:/pgsql/bin/pg_ctl.exe runservice -N "postgres" -D
"d:/pgsql/data"
>
> initdb finished OK, postgres is opened as unpriviledged user etc...

1. Is the your path on the system side or the user side (make sure it's
on the system side for services).
2. Try setting up PGDATA (in system env. variables) to avoid use of -D
option.
3. Try logging in as user postgres and invoking postmaster directly from
shell.
4. Double check NTFS permissions to 'local' folder (make sure postgres
has read/execute) and to data folder (make sure postgres has full
control)

Merlin

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)