On Fri, May 05, 2006 at 22:13:37 -0700,
operationsengineer1(at)yahoo(dot)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.