Re: can't start as root

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Lee Johnson" <lee(at)imyourhandiman(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: can't start as root
Date: 2001-05-23 08:49:27
Message-ID: 003e01c0e365$475db720$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Lee Johnson" <lee(at)imyourhandiman(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-05-23 08:52:15 Re: incomplete transaction keeps table locked?
Previous Message rwell 2001-05-23 08:49:00