In Windows Server 2008 PostgreSQL8.3 service on Local Computer started and then stopped.

El 06/09/2011 22:11, Jack_Wu escribi�:

Windows Task Manager: PostgreSQL8.3's status is stopped.
In Services:PostgreSQL8.3's status is stopped.
When I start this service manually in Services,it notes that The
PostgreSQL8.3 service on Local Computer started and then stopped.Some
services stop automatically if they are not in use by other services or
programs.

In Event viewer it shows PostgreSQL 8.3's Error that:
The description for Event ID 0 from source PostgreSQL cannot be found.
Either the component that raises this event is not installed on your local
computer or the installation is corrupted. You can install or repair the
component on the local computer.

If the event originated on another computer, the display information had to
be saved with the event.

The following information was included with the event:

FATAL: no pg_hba.conf entry for host "::1", user "SYSTEM", database
"postgres", SSL off.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/In-Windows-Server-2008-PostgreSQL8-3-service-on-Local-Computer-started-and-then-stopped-tp4776719p4776719.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

Are you using ipv6?
::1 is localhost in ipv6
there isn't a line in pg_hba.conf (verify this file)
# IPv6 local connections:
host all all ::1/128 ident

On 09/07/11 4:50 AM, Rodriguez Fernando wrote:

there isn't a line in pg_hba.conf (verify this file)
# IPv6 local connections:
host all all ::1/128 ident

'ident' should probably instead be 'md5', as I don't believe Windows
supports ident, alternately, it could be 'trust', but this would say
any process or user on your system could connect as any postgres role
without any verification or authentication at all. caveat emptor.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast