From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | <operationsengineer1(at)yahoo(dot)com> <operationsengineer1(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: db connection problem (fedora core 3, pgsql 8.0.3) |
Date: | 2005-09-23 17:27:36 |
Message-ID: | B7F4F2C2-423B-44D1-B6F3-0F06B031BC79@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sep 23, 2005, at 1:08 PM, <operationsengineer1(at)yahoo(dot)com>
<operationsengineer1(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2005-09-23 18:09:57 | Re: db connection problem (fedora core 3, pgsql 8.0.3) |
Previous Message | Sean Davis | 2005-09-23 17:14:09 | Re: db connection problem (fedora core 3, pgsql 8.0.3) |