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

From Richard Huxton
Subject Re: starting the database server
Date
Msg-id 41ACAA57.5090103@archonet.com
Whole thread Raw
In response to Re: starting the database server  ("Nefnifi, Kasem" <Kasem.Nefnifi@atosorigin.com>)
List pgsql-general
Nefnifi, Kasem wrote:
> 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.

Something must have changed. If it's not your installation of PostgreSQL
then it's something in the authentication system.

> 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
> administrator to do something like except Postgresql.

Keep the PostgreSQL user the same, but trace its group membership and
check file permissions.

The reason PosgreSQL refuses to run as an administrator is that to do so
  opens a security hole. Other databases open that hole and you can read
about the hacks on the security lists.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Nefnifi, Kasem"
Date:
Subject: Re: starting the database server
Next
From: Karsten Hilbert
Date:
Subject: Re: starting the database server