Postgresql server fails to start autmatically some days after installation.

From: "Karan K Bansal" <Karan(dot)K(dot)Bansal(at)aexp(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Cc: "karanbansalmca(at)yahoo(dot)co(dot)in" <karanbansalmca(at)yahoo(dot)co(dot)in>
Subject: Postgresql server fails to start autmatically some days after installation.
Date: 2012-09-25 11:17:11
Message-ID: F5CAD9F979EE884BAB6B8CCE02B0560D08E80227@024-SN1MPN1-023.024d.mgd.msft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I am a novice to postgresql. I needed a local database server on my company laptop running on Windows XP. I got postgresql 9.1 installed on it.
For a few days it worked well, but after some 5-6 days, it failed to start on system restart. Gave following error:
Server doesn't listen
The server doesn't accept connections: the connection library reports could not connect to server:
Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

I saw in the windows 'services' tab, that postgres sql service was stopped.
The 'services' window shows that it has been set to start automatically, but that it has been stopped. If I try to start it there, it shows 'Error 5: Access is denied'.

I don't have administrator privileges as it is a company owned laptop. However, I tried to get it restarted from technical help desk personal who has administrative privileges (We Run it as different user with administrative privileges. We can't do 'run as administrator' as the administrator password is open to none as a company policy.) It still showed Error 5.
I also tried to change the port using hba_conf, but no benefit.

Finding no solution, I got it reinstalled on a different port (5433), and it again worked well for a few days.
Today when I tried to connect to the database, it again showed the same issue. Server doesn't listen. Could not start service. Etc..

What I fail to understand is that why it works fine for some days, and then one fine day it fails to start.
Mine is a windows Xp 32 bit system with McAfee and other software installed. I have windows regular updates and various software and security patches constantly updated.

Can you please help me identify the problem and fix it?
Please keep in mind that I do not have administrative priveleges. I can only seek an administrator to make system changes on special request.

Thanks and Regards,
Karan Bansal

American Express made the following annotations on Tue Sep 25 2012 04:17:32

******************************************************************************

"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."

American Express a ajout le commentaire suivant le Tue Sep 25 2012 04:17:32

Ce courrier et toute pice jointe qu'il contient sont rservs au seul destinataire indiqu et peuvent renfermer des renseignements confidentiels et privilgis. Si vous n'tes pas le destinataire prvu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pice jointe est interdite. Si vous avez reu cette communication par erreur, veuillez nous en aviser par courrier et dtruire immdiatement le courrier et les pices jointes. Merci.

******************************************************************************
-------------------------------------------------------------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jayadevan M 2012-09-25 12:01:10 Re: Postgresql server fails to start autmatically some days after installation.
Previous Message Tom Browder 2012-09-24 13:56:24 Re: Using Different Ports for Multiple PosgreSQL Installations: Any Issues?