Re: Switch to Linux Dev Questions - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Switch to Linux Dev Questions
Date
Msg-id 20060506155316.GB3434@wolff.to
Whole thread Raw
In response to Switch to Linux Dev Questions  (<operationsengineer1@yahoo.com>)
List pgsql-novice
On Fri, May 05, 2006 at 22:13:37 -0700,
  operationsengineer1@yahoo.com wrote:
>
> why do i have to su to root before i su to postgres
> (in order to run psql)?  i tried to su from my
> username and it asked for a password and said
> authentication failed - there is no password.

Note that you don't need to switch the unix user to postgres to connect
to the database as the database user postgres. Use the -U option for psql.

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Switch to Linux Dev Questions
Next
From:
Date:
Subject: postgres db deleted and recreated... "No directory, logging in with HOME=/" error...