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 >Messaggio originale >Da: vibhor.ku...@enterprisedb.com >Data: 29/06/2010 2.40 >A: "Igor Neyman" >Cc: , >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 > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: R: Re: [GENERAL] postgres user password: Log on failure
On Tue, 2010-06-29 at 09:37 +0200, dario@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general