Re: BUG #6118: Server doesn't listen

On 07/13/11 10:38 PM, Shahnawaz Shaikh wrote:
> The following bug has been logged online:
>
> Bug reference: 6118
> Logged by: Shahnawaz Shaikh
> Email address: Shahnawaz(dot)shaikh(at)accenture(dot)com
> PostgreSQL version: 8.4
> Operating system: Windows server 2003
> Description: Server doesn't listen
> Details:
>
> When i try to start the PostgreSQL 8.4 server, below issue is encountered,
>
> System error 1069 has occurred.
> The service did not start due to a logon failure.
> The start command returned an error<2>
> Press<return> to continue....
>
> While, when i try to connect the PostgreSQL 8.4 from pgAdmin III i get the
> below error on entering password
>
> Server doesn't listen

this is not a bug, it appears to be a configuration error, the logon
credentials given in the Windows Service do not match the appropriate
account, so the service isn't starting, since the servce isn't running,
the client can't connect. This sort of issue would best be handled on
the pgsql-general email list....

you need to properly configure the postgresql service in the Windows
Service manager, I believe I would go into Administration Tools -> User
Manager, find the postgres account, set a new reasonably complex
password, then go into the Windows Service manager, find the postgresql
service, and in its properties, on the Log On tab, set the user and
password to match what you set in User Manager. This should have
been done automatically by the windows installer. After you do this,
you should be able to START the service.

note this password you set in User Manager has nothing to do with the
password (if any) for the postgres role you use to log onto the database
server for administration.

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