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
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. |