pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
getting service from a local server (v8.2.4)
3+ messages / 3 participants
[nested] [flat]

* getting service from a local server (v8.2.4)
@ 2007-07-19 04:13  Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 2 replies; 3+ messages in thread

From: Tena Sakai @ 2007-07-19 04:13 UTC (permalink / raw)
  To: 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@gallo.ucsf.edu
 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: getting service from a local server (v8.2.4)
@ 2007-07-19 04:36  Vishal Arora <aroravishal22@hotmail.com>
  parent: Tena Sakai <tsakai@gallo.ucsf.edu>
  1 sibling, 0 replies; 3+ messages in thread

From: Vishal Arora @ 2007-07-19 04:36 UTC (permalink / raw)
  To: tsakai@gallo.ucsf.edu; pgsql-admin




>From: "Tena Sakai" <tsakai@gallo.ucsf.edu>
>To: <pgsql-admin@postgresql.org>
>Subject: [ADMIN] getting service from a local server (v8.2.4)
>Date: Wed, 18 Jul 2007 21:13:11 -0700
>
>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).
Is by any chance user T owner of testdb on S811?

>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@gallo.ucsf.edu
>

_________________________________________________________________
http://liveearth.msn.com




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: getting service from a local server (v8.2.4)
@ 2007-07-19 04:47  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Tena Sakai <tsakai@gallo.ucsf.edu>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2007-07-19 04:47 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-admin

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> 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.

I can't help but think that all this obfuscation has hidden the
problem.  However, you might look into whether user "T" has some
unexpected PGxxx environment variables set...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-07-19 04:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-19 04:13 getting service from a local server (v8.2.4) Tena Sakai <tsakai@gallo.ucsf.edu>
2007-07-19 04:36 ` Vishal Arora <aroravishal22@hotmail.com>
2007-07-19 04:47 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox