| Lists: | pgsql-general |
|---|
| From: | Stefano T <stefano(dot)tranquillini(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_ctl: could not start service "pgsql-8.2": error code 1063 |
| Date: | 2007-05-05 16:45:10 |
| Message-ID: | 1178383510.463603.250330@h2g2000hsg.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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?
| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Stefano T <stefano(dot)tranquillini(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_ctl: could not start service "pgsql-8.2": error code 1063 |
| Date: | 2007-05-07 17:14:50 |
| Message-ID: | 463F5E8A.4090306@hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | georgy(dot)slavov(at)gmail(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_ctl: could not start service "pgsql-8.2": error code 1063 |
| Date: | 2007-05-21 06:08:12 |
| Message-ID: | 1179727692.401114.146090@z28g2000prd.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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