Postgresql server fails to start autmatically some days after installation. - Mailing list pgsql-novice
| From | Karan K Bansal |
|---|---|
| Subject | Postgresql server fails to start autmatically some days after installation. |
| Date | |
| Msg-id | F5CAD9F979EE884BAB6B8CCE02B0560D08E80227@024-SN1MPN1-023.024d.mgd.msft.net Whole thread Raw |
| Responses |
Re: Postgresql server fails to start autmatically some days after
installation.
|
| List | 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 pi�ce jointe qu'il contient sont r�serv�s au seul destinataire indiqu� et peuvent renfermer des renseignements confidentiels et privil�gi�s. Si vous n'�tes pas le destinataire pr�vu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pi�ce jointe est interdite. Si vous avez re�u cette communication par erreur, veuillez nous en aviser par courrier et d�truire imm�diatement le courrier et les pi�ces jointes. Merci.
******************************************************************************
-------------------------------------------------------------------------------
pgsql-novice by date: