Re: Postgres user - Mailing list pgsql-general

From Mark Taylor
Subject Re: Postgres user
Date
Msg-id Xns9256DD9A1C1FFmaintainersetifaqorg@128.242.171.114
Whole thread Raw
In response to Postgres user  ("Varsha Agarwal" <varsha_agarwal@hotmail.com>)
List pgsql-general
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 =-----

pgsql-general by date:

Previous
From: Dmitry Tokarsky
Date:
Subject: Multilanguage support
Next
From: "Christian H. Stork"
Date:
Subject: Re: List tables in the database