Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-09-23 18:09:57
Subject: Re: db connection problem (fedora core 3, pgsql 8.0.3)
Previous:From: Sean DavisDate: 2005-09-23 17:14:09
Subject: Re: db connection problem (fedora core 3, pgsql 8.0.3)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group