Обсуждение: pg_ctl: could not start service "pgsql-8.2": error code 1063

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

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.

and the execution of this:
C:\Programs\PostgreSQL\8.2\bin>psql.exe
psql: could not connect to server: Connection refused (0x0000274D/
10061)
        Is the server running on host "???" and accepting
        TCP/IP connections on port 5432?

some one can help me? how can i fix this problem?

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