Re: BUG #5224: After upgrading from vista to windows 7, postgres services are missing

1. After I reinstalled the latest version of postgresql, I do see a service
called postgresql-8.4.
2. It is started automatically.

Please note, however, that I am still not able to connect to the database.
For example, trying to use psql gives me the following error:

psql: could not connect to server: Cannot assign requested address
(0x00002741/1
0049)
Is the server running on host "localhost" and accepting
TCP/IP connections on port test?

I have never seen this error before my OS upgrade.

3. I looked through the Windows Event Viewer but didn't anything related to
postgres.
4. I believe ever since I upgraded, the pg_log logs have been empty. There
is nothing much interesting in the prior few logs (just info messages about
starting up and shutting down etc.)

Thanks for the prompt response.

Sriram

On Wed, Dec 2, 2009 at 1:07 AM, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>wrote:

> On 2/12/2009 12:57 PM, Sriram Gopalan wrote:
>
>>
>> The following bug has been logged online:
>>
>> Bug reference: 5224
>> Logged by: Sriram Gopalan
>> Email address: sriramgopalan(at)gmail(dot)com
>> PostgreSQL version: 8.4.1
>> Operating system: Windows 7
>> Description: After upgrading from vista to windows 7, postgres
>> services are missing
>> Details:
>>
>> I recently upgraded my machine from windows vista to window 7. I had
>> installed postgresql 8.4.1 on that machine and it was working great.
>> However, after upgrade, I cannot even see the services related to
>> postgres.
>> When I try to connect, I get the message that postgres is not running and
>> listening to its port.
>>
>
> In the services control panel (start -> run ->services.msc , or via Control
> Panel -> Administrative Tools) can you see the postgresql service listed?
>
> What state is it in?
>
> Is there anything in the Windows Error Log about PostgreSQL?
>
> Is there anything of interest at the end of the most recent log file in the
> "pg_log" subdirectory of the PostgreSQL data directory?
>
> --
> Craig Ringer
>