Re: db connection problem (fedora core 3, pgsql 8.0.3)

On Sep 23, 2005, at 1:08 PM,   
 wrote:

> i vpn into the company network, then i sign into the
> fc3 server a "user" via an accuterm session.
>
> i typed in
>
> "psql -d mydb"
>
> and received an error message that "user" isn't a
> user.
>
> does anyone know what i'm doing wrong?


If you don't supply a specific user, the psql tries to use the  
current shell user name as the PostgreSQL user. So if "user" is not a  
real PostgreSQL user, you need to specify the user explicitly:

psql -d mydb -U pgusername


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL