Re: 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