By default in Windows 2000, passwords are set to expire after 42 days (in my experience.) So after 42 days, Windows will stop the user from being able to authenticate, so the service cannot logon. When you reset the password, the 42-day expiry counter begins again. If you run the Local Users & Groups MMC (lusrmgr.msc) and open up the user account for your postgres service - you can set "Password never expires" to get around this for this user only. Andy > -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin- > owner@xxxxxxxxxxxxxx] On Behalf Of sandhya > Sent: 15 May 2006 8:15 am > To: David Bonilla > Cc: Postgres > Subject: Re: [ADMIN] Fw: reg:logon failure > > The solution is write again de password to user postgres in windows, or > the > user that run the service. > I don't know why happen that, but in my experience this must solve your > problem. > > Where i should mention the password. > Is it in Users of Controlpanel i need to change my password.Bcoz mine is > also win2000 only. > Why it is happening in Win2000,Anybody can pls explain me? > > > > > > > ----- Original Message ----- > From: "David Bonilla" <David.Bonilla@xxxxxxxxxxx> > To: <pgsql-admin@xxxxxxxxxxxxxx> > Sent: Thursday, May 11, 2006 5:03 PM > Subject: Re: [ADMIN] Fw: reg:logon failure > > > > sandhya escribió: > > > Hi, > > > Already i have postgres server running on my windows system.Suddenly > > > when i open it didn't open and when i run and see in the services...I > am > > > getting the following. > > > > I have this problem in a W2000 system. The solution is write again de > > password to user postgres in windows, or the user that run the service. > > I don't know why happen that, but in my experience this must solve your > > problem. > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > !DSPAM:14,446838cb34494500111402! >
