Starting PostgreSQL 7.3.4 with Webmin on Mandrake 9.1

From: Raigo77(at)solo(dot)delfi(dot)ee (Raigo)
To: pgsql-admin(at)postgresql(dot)org
Subject: Starting PostgreSQL 7.3.4 with Webmin on Mandrake 9.1
Date: 2003-08-20 10:41:03
Message-ID: 80df3db1.0308200241.27f4ce5a@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I just installed PostgreSQL 7.3.4 (new default install) and setting up
Webmin to be able to administrate it. Postgres is installed to default
location /usr/local/pgsql

My question: what is the correct command for starting PostgreSQL
server with Webmin and for bootup?

from command line (as root) I successfully did it with:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

but when I run it with Webmin I get:
Failed to start database server :

"root" execution of the PostgreSQL server is not permitted.

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.

in install documentation I have options:
1)/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
and
2)nohup /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data \
</dev/null >>server.log 2>&1 </dev/null &

the second one didn't work from command line either for me.

I also tried with:
/etc/rc.d/init.d/postgresql start
I get No such file or directory.

What is the correct way to do it?

also, I would be glad to read what is the command for starting
Postgres in bootup. can I use the same command?

thanks for all ideas.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rhaoni Chiu Pereira 2003-08-20 12:24:28 Explicit Cast
Previous Message Chris Miles 2003-08-20 09:54:11 Re: get current queries