Re: starting the database server - Mailing list pgsql-general

From Nefnifi, Kasem
Subject Re: starting the database server
Date
Msg-id 25D4919915CCF742A88EE3366D6D913D07E67032@mailserver1
Whole thread Raw
In response to starting the database server  ("Nefnifi, Kasem" <Kasem.Nefnifi@atosorigin.com>)
Responses Re: starting the database server
List pgsql-general
Hello,

but it has worked fine since the installation without any error until now and nothing has been changed in the system
policy.
how it can something like this happened.
now the concrete solution, I've to follow the solution proposed in the log file.
which user should I use to start the database, if I take an only normal user, get the message error that I don't
permissions,as administrator PostgreSql don't let me start the database. strange, because in all databases you've to be
administratorto do something like except Postgresql. 

what kind solution do you suggest to me and thx in advance.

-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: Tuesday, November 30, 2004 5:42 PM
To: Nefnifi, Kasem
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] starting the database server


Nefnifi, Kasem wrote:
> Hi Richard, bellow the text from the log file:
>
> ---------- start log file ----------
>
> 30/11/2004    16:45:08    PostgreSQL    Error    None    0    N/A    BAAN-AT-HOME
> execution of PostgreSQL by a user with administrative permissions is
> not permitted. The server must be started under an unprivileged user
> ID to prevent possible system security compromise.  See the
> documentation for more information on how to properly start the
> server.

There you go - the user PostgreSQL tries to run under has administrative
permissions. This isn't allowed for security purposes.

> 30/11/2004    16:42:52    SceCli    Warning    None    1202    N/A    BAAN-AT-HOME
> "Security policies are propagated with warning. 0x534 : No mapping
> between account names and security IDs was done.
>
> For best results in resolving this event, log on with a
> non-administrative account and search http://support.microsoft.com
> for ""troubleshooting 1202 events"". A user account in one or more
> Group policy objects (GPOs) could not be resolved to a SID. This
> error is possibly caused by a mistyped nor deleted user account
> referenced in either the User Rights or Restricted Groups branch of a
> GPO.  To resolve this event, contact an administrator in the domain
> to perform the following actions:

What's more - there seems to have been a problem mapping user/group
numbers to names. The rest of the message gives details of how to
correct this.

--
   Richard Huxton
   Archonet Ltd
****************************************************************************
Disclaimer:
This electronic transmission and any files attached to it are strictly
confidential and intended solely for the addressee. If you are not
the intended addressee, you must not disclose, copy or take any
action in reliance of this transmission. If you have received this
transmission in error, please notify the sender by return and delete
the transmission.  Although the sender endeavors to maintain a
computer virus free network, the sender does not warrant that this
transmission is virus-free and will not be liable for any damages
resulting from any virus transmitted.
Thank You.
****************************************************************************

pgsql-general by date:

Previous
From: Mark
Date:
Subject: installing postgresql .rpms not in /usr/bin
Next
From: Richard Huxton
Date:
Subject: Re: starting the database server