On Sep 23, 2005, at 1:08 PM, <operationsengineer1@yahoo.com>
<operationsengineer1@yahoo.com> 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