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 <sriramgopa...@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 > <cr...@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: sriramgopa...@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 >> > >