All the paths are OK (system ones). Let's try autostartup:
1. [pg_ctl unregister, ]pg_ctl register -U pgsql -P password. Service
startup type: Automatic.
2. reboot
3. service is not running. Event Viewer (Source: Service Control Manager):
Description: The PostgreSQL service hung on starting.
Description: The PostgreSQL service terminated unexpectedly. It has done
this 1 time(s). The following corrective action will be taken in 0
milliseconds: No action.
A bit later i did: runas /user:pgsql cmd, pg_ctl start and it worked.
Stopped it with Ctrl+Break (i know i should have pg_ctl stop, but...). A bit
later i tried to launch it again with runas /user:pgsql "pg_ctl start" and
got that "failure to initialize" error pop-up. Event Viewer (Source:
Application Popup):
Description: Application popup: postmaster.exe - Application Error : The
application failed to initialize properly (0xc0000142). Click on OK to
terminate the application.
After that i've attempted to launch it this way: runas /user:pgsql
postmaster and it worked OK (as usual).
eom
