Re: Help me

On Thu, 11 Sep 2003, Tran Anh Tu wrote:

> Hi all!
> I have installed Mandrake 9.0. and postgresql is installed automatically.
> When I start postgresql by the command:
> postmaster -i
> have a error message:
>
> The server must be started under an unprivileged user id to prevent
> a possible system security compromise.  See the documentation for
> more information on how to properly start the server.
>
> With Mandrake 8.0, I do nothing to config postgresql. So what I can do to
> config it now? Please help me! thank you very much.

Is this an RPM install or a .tar.gz install?

If an RPM install, try, as root:

service pgsql start

Note that pgsql may not be the name, it could be something else.  look for
a file in /etc/rc.d/init.d with a name that seems like postgresql and
substitute it for pgsql above.

If it is a tar.gz install, you'll have to create an account (or use one
that already exists) to 'initdb', set PGDATA and 'pg_ctl start' or
'postmaster -i -D datadir'