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

Please consider this issue as resolved. Reinstallation seems to have fixed
it.

The service is running, as noted before and I am able to connect and use the
database. My syntax was wrong in the previous email.

Thanks again.

Sriram

On Wed, Dec 2, 2009 at 7:51 AM, Sriram Gopalan <sriramgopalan(at)gmail(dot)com>wrote:

> 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
>>
>
>