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

getting service from a local server (v8.2.4)

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: getting service from a local server (v8.2.4)
Date: 2007-07-19 04:13:11
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C02B68BE0@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

I am new to postgres and having a strange problem.  Please help.

I installed postgres v 8.2.4 on a new linux server (not upgrade,
but a virgin install) and created a couple of users.  For the
sake of clarity and concreteness, I will call this server S824.
There is another server on the network where S824 resides that
also runs postgres (v 8.1.1).  I'll call this server S811.
Postgres on S811 has been running for a ;png time (a year+).

The users I created on S824 are user J and user T.  Both users
J and T also have accounts on S811.  Here are a few scenarios
that defies my brains (all issued from S824):

a) as user J, I issue "psql testdb"
   it behaves the way I want it.  It asks me J's password, I
   authenticate and I get to psql prompt.
b) as user J, I issue "psql -h S824 testdb"
   It behaves exactly like case a).  This is also fine.
c) as user T, I issue "psql testdb"
   it does NOT behave the way I want it.  I want it to behave
   like a) and/or b) above.  Instead, after authentication, it
   offers service from S811 (which also has a database called
   testdb).
d) as user T, I issue "psql -h S824 testdb"
   it offers the service from S824, which I consider to be
   the correct behavior.

So, the problem boils down to c).  Can somebody please tell
me what causes c) to go to remote server?  And how I can
correct it to behave like user J?

Thank you.

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
 

Responses

pgsql-admin by date

Next:From: Vishal AroraDate: 2007-07-19 04:36:00
Subject: Re: getting service from a local server (v8.2.4)
Previous:From: PostgreSQL AdminDate: 2007-07-18 16:46:03
Subject: pgmemcache

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