Обсуждение: In Windows Server 2008 PostgreSQL8.3 service on Local Computer started and then stopped.
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.
Re: In Windows Server 2008 PostgreSQL8.3 service on Local Computer started and then stopped.
От
Rodriguez Fernando
Дата:
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
Re: In Windows Server 2008 PostgreSQL8.3 service on Local Computer started and then stopped.
От
John R Pierce
Дата:
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