Thanks.On Sáb 07 Dic 2002 01:53, Jean Fleurant (root) wrote:I'd like to use postgres database to run a buletin board called phpBB2.I'm pretty new in linux and I've spent almost 2 days trying to start the postgrea database. In the documentation that come in the installation, it is always specified to run "postmaster -D /database_path/" but I don't know what is the database path.PostgreSQL comes with pg_ctl, which is a script for starting and stoping PostgreSQL. Now if you installed from rpm (RedHat rpm), just start it as any other service: service postgresql start Good Luck!
I've started the service and did not receive any error message.
Now I'd like to have acceess to a datatbase. I think that I need to start the postmaster.
I've run command "postmaster -D /var/lib/pgsql/data/" but I get following error message:
FATAL 1: could not read permissions of directory /var/lib/pgsql/data/
I'm using a user I've created on installation. With this user, I cannot have access to the /var/lib/pgsql directory (no permission).
Here is the info for this directory: drwx------ 4 postgres postgres 4096 déc 7 00:11 pgsql
I've tried to execute "postmaster -D /var/lib/pgsql/data/" with the root userid and I get this error.
"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.
Stuck again !
Does my id need to be in a special group ?
Any suggestion ?
