Re: Postgres user

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 =-----