Обсуждение: R: Re: postgres user password: Log on failure
Hi guys, Thanks for taking time to reply. - Despite what the error message says, the user postgres doesn't have administrator privileges (and I don't see why these would change by retyping the password). - In Control Panel -> Administrative Tools -> Computer Manager -> Users -> postgres I see that postgres is member of the 'Users' group and its password never expires. Maybe I'm missing something obvious here... Dario >----Messaggio originale---- >Da: vibhor.kumar@enterprisedb.com >Data: 29/06/2010 2.40 >A: "Igor Neyman"<ineyman@perceptron.com> >Cc: <dario.ber@libero.it>, <pgsql-general@postgresql.org> >Ogg: Re: [GENERAL] postgres user password: Log on failure > >On 28/06/10 8:58 PM, Igor Neyman wrote: >> Log on failure: Only an unprivileged user can start >> > the server"; Error 1063; Error 1069). >> > >> > >Error Message shows that services are getting started with Admin Privileges. > >Please use unprivileged user(i.e Non admin user) for starting the services. > >-- >Thanks& Regards, >Vibhor Kumar. >EnterpriseDB Corporation >The Enterprise Postgres Company > >Office: 732-331-1300 Ext-2022 > >Website: www.enterprisedb.com >EnterpriseDB Blog: http://blogs.enterprisedb.com >Follow us on Twitter: http://www.twitter.com/enterprisedb > >
> -----Original Message----- > From: dario.ber@libero.it [mailto:dario.ber@libero.it] > Sent: Tuesday, June 29, 2010 3:38 AM > To: vibhor.kumar@enterprisedb.com; Igor Neyman > Cc: pgsql-general@postgresql.org > Subject: R: Re: [GENERAL] postgres user password: Log on failure > > Hi guys, > > Thanks for taking time to reply. > > - Despite what the error message says, the user postgres > doesn't have administrator privileges (and I don't see why > these would change by retyping the password). > - In Control Panel -> Administrative Tools -> Computer > Manager -> Users -> postgres I see that postgres is member of > the 'Users' group and its password never expires. > > Maybe I'm missing something obvious here... > > Dario > > That's why I told you to check if your WinOS password policy requires regular change of account passwords. Igor Neyman
On Tue, 2010-06-29 at 09:37 +0200, dario.ber@libero.it wrote: > Hi guys, > > Thanks for taking time to reply. > > - Despite what the error message says, the user postgres doesn't have > administrator privileges (and I don't see why these would change by retyping > the password). > - In Control Panel -> Administrative Tools -> Computer Manager -> Users -> > postgres I see that postgres is member of the 'Users' group and its password > never expires. > > Maybe I'm missing something obvious here... Have you checked if the 'postgres' user is allowed to "login as a service" in local/group policy? The error about admin privileges may be masking the fact the postgres user is trying to start a service, without the policy rights. Cheers, Dagan McGregor