Thread: can't start as root

trying ( new at this ) to start postmaster so i can utilize pgaccess to
create database etc. but even if I start desktop as user other than
"root" it still gives me the "root" error that I can't start as user
root......

RH 7.1 current/gnome 1.4 current

thanks
lee

From: "Lee Johnson" <lee@imyourhandiman.com>

> trying ( new at this ) to start postmaster so i can utilize pgaccess to
> create database etc. but even if I start desktop as user other than
> "root" it still gives me the "root" error that I can't start as user
> root......
>
> RH 7.1 current/gnome 1.4 current

Admin tasks (starting database server, adding new users etc) should be done
as user "postgres". If RH is automatically starting the server (see in
/etc/rc.d/init.d or /etc/init.d) it will do something like "su - postgres -c
..." in the startup script.

If you don't know the password for postgres, su - to root first then su -
postgres from there.

- Richard Huxton

On redhat, if you used the rpms you can start postgres by

cd /etc/rc.d/init.d
./postgresql start

You should set it to start automatically using the gnome configurator

Dave
----- Original Message -----
From: "Lee Johnson" <lee@imyourhandiman.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, May 22, 2001 11:57 AM
Subject: [GENERAL] can't start as root


> trying ( new at this ) to start postmaster so i can utilize pgaccess to
> create database etc. but even if I start desktop as user other than
> "root" it still gives me the "root" error that I can't start as user
> root......
>
> RH 7.1 current/gnome 1.4 current
>
> thanks
> lee
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>