pg_ctl: could not start service "pgsql-8.2": error code 1063

Stefano T wrote:

Hi everybody.
Well.. i've a probelm. pg doesn't start at boot. if i copy the string
of command and try execute:

C:\Programs\PostgreSQL\8.2\bin\pg_ctl.exe runservice -N "pgsql-8.2" -D
"C:\Programs\PostgreSQL\8.2\data\"
the output is:
pg_ctl: could not start service "pgsql-8.2": error code 1063

runservice can only be used fromthe service control manager, as the
error indicates.

and if i try to execute this:
C:\WINDOWS\system32\net.exe start pgsql-8.2

the output is:

The PostgreSQL Database Server 8.2 service is starting.
The PostgreSQL Database Server 8.2 service could not be started.
The service did not report an error.

What do you get in the eventlog and/or the postgresql log at this time?

//Magnus

postmaster starting
Execution of PostgreSQL
C:\apache2triad\pgsql\bin> by a user with administrative permissions
is not
permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromises. See the documentation for
more information on how to properly start the server.

Solution
1. Create a new user and make it a member only of the Users group
2. In Services set Log On for the PostgreSQL Service the newly created
user

On my pc it worked