| 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) |