Hi John, Thx for your help.
Thanks & Regards, Shahnawaz Shaikh Accenture Services Pvt Ltd. IDC RPSI Mob: +91 9819 133 926 Off: +22 420 21019 Email: shahnawaz.sha...@accenture.com AIM: shahnawaz1shaikh | MSN: shahnawaz.sun -----Original Message----- From: John R Pierce [mailto:pie...@hogranch.com] Sent: Thursday, July 14, 2011 1:09 PM To: Shaikh, Shahnawaz Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6118: Server doesn't listen On 07/13/11 10:38 PM, Shahnawaz Shaikh wrote: > The following bug has been logged online: > > Bug reference: 6118 > Logged by: Shahnawaz Shaikh > Email address: shahnawaz.sha...@accenture.com > PostgreSQL version: 8.4 > Operating system: Windows server 2003 > Description: Server doesn't listen > Details: > > When i try to start the PostgreSQL 8.4 server, below issue is encountered, > > System error 1069 has occurred. > The service did not start due to a logon failure. > The start command returned an error<2> > Press<return> to continue.... > > While, when i try to connect the PostgreSQL 8.4 from pgAdmin III i get the > below error on entering password > > Server doesn't listen this is not a bug, it appears to be a configuration error, the logon credentials given in the Windows Service do not match the appropriate account, so the service isn't starting, since the servce isn't running, the client can't connect. This sort of issue would best be handled on the pgsql-general email list.... you need to properly configure the postgresql service in the Windows Service manager, I believe I would go into Administration Tools -> User Manager, find the postgres account, set a new reasonably complex password, then go into the Windows Service manager, find the postgresql service, and in its properties, on the Log On tab, set the user and password to match what you set in User Manager. This should have been done automatically by the windows installer. After you do this, you should be able to START the service. note this password you set in User Manager has nothing to do with the password (if any) for the postgres role you use to log onto the database server for administration. -- john r pierce N 37, W 122 santa cruz ca mid-left coast This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
