Re: accidentally deleted user --> postgres

From: Shane Ambler <pgsql(at)007Marketing(dot)com>
To: g f <gforty(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: accidentally deleted user --> postgres
Date: 2007-02-08 06:55:24
Message-ID: 45CAC95C.20907@007Marketing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

g f wrote:
> Shane,
> thanks for the advice.
> I created the user: net user postgres /add
> I still get the error. When I try to start the postgres service in
> windows-->services I get a "The service did not start due to logon failure"

As long as the postgres user account is not in the admin group check
that the postgresql service is set to Log on as user postgres.

Not sure of the command line but in the gui the service settings has a
'Log On' tab that allows you to set a specific user to run the service.
This is where you need to check that your postgres user is used to start
the service or maybe the password there doesn't match the new account.

--

Shane Ambler
pgSQL(at)007Marketing(dot)com

Get Sheeky @ http://Sheeky.Biz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2007-02-08 07:29:37 Re: temp tables in functions?
Previous Message Tom Lane 2007-02-08 05:57:14 Re: Database corruption.