Postgres user

Most installations I've seen have you setup a postgres user.
Potentially this is already setup in redhat as a system account, in
which case, I believe just setting a password for it as root should do
the trick, and let you login.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Varsha Agarwal
Sent: Thursday, July 25, 2002 7:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgres user

Hi,
I have just installed postgresql on red hat. To use psql command i have
to
do
su postgres.
But i can only do su postgres when I log on as root. When I logon as
other
user and do su postgres, it asks for password and i dont know what that
is.
Is it always to be run as root only or I can run it as normal user?
-Varsha

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

You can start postmaster as any under priveledged user.

all you do is start the database server here is what i use in a start up
script as you see i su from root to me then specify the command and any
additional arguments

#!/bin/bash

HOME=/usr/local/pgsql
LOG=$HOME/logs/postgres.log
DATA_DIR=$HOME/db
USER=darren

ulimit -SHc unlimited

su $USER -c "nohup $HOME/bin/postmaster -i -D $DATA_DIR $@ >$LOG 2>&1
</dev/null&"

So as you see you do not need to be root or postgres.

HTH

On Thu, 25 Jul 2002, Gavin M. Roy wrote:

Most installations I've seen have you setup a postgres user.
Potentially this is already setup in redhat as a system account, in
which case, I believe just setting a password for it as root should do
the trick, and let you login.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Varsha Agarwal
Sent: Thursday, July 25, 2002 7:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgres user

Hi,
I have just installed postgresql on red hat. To use psql command i have
to
do
su postgres.
But i can only do su postgres when I log on as root. When I logon as
other
user and do su postgres, it asks for password and i dont know what that
is.
Is it always to be run as root only or I can run it as normal user?
-Varsha

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
Darren Ferguson

varsha_agarwal@hotmail.com ("Varsha Agarwal") wrote in
news:F142vO0zND3oV4AS24O0001adcc@hotmail.com:

Hi,
I have just installed postgresql on red hat. To use psql command i
have to do
su postgres.
But i can only do su postgres when I log on as root. When I logon as
other user and do su postgres, it asks for password and i dont know
what that is. Is it always to be run as root only or I can run it as
normal user? -Varsha

After you su to postgres you should create a postgres user with the
createuser command. The user you create should be an existing system user
that you want to authorize to use postgres commands.

Mark

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----