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@gmail.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@postnewspapers.com.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@gmail.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
>>
>
>