Thread: db connection problem (fedora core 3, pgsql 8.0.3)
hi all, i'm trying to acces our new in-house pgsql server. pgsql 8.0.3 is running on fc3. 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? tia... __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
On 9/23/05 1:08 PM, "operationsengineer1@yahoo.com" <operationsengineer1@yahoo.com> wrote: > hi all, > > i'm trying to acces our new in-house pgsql server. > pgsql 8.0.3 is running on fc3. > > 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? Did someone do a createuser on your new server for the "user" in question? Sean
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
> On 9/23/05 1:08 PM, "operationsengineer1@yahoo.com" > <operationsengineer1@yahoo.com> wrote: > > > hi all, > > > > i'm trying to acces our new in-house pgsql server. > > pgsql 8.0.3 is running on fc3. > > > > 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? > > Did someone do a createuser on your new server for > the "user" in question? > > Sean Sean, no. is this likely the problem? do linux user names also have to be created in the db for folks who will use psql, pgadmin, etc.? tia... __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com