pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vishal Arora <aroravishal22@hotmail.com>
To: tsakai@gallo.ucsf.edu
To: pgsql-admin@postgresql.org
Subject: Re: getting service from a local server (v8.2.4)
Date: Thu, 19 Jul 2007 04:36:00 +0000
Message-ID: <BAY123-F34E249D93C4A608AFD0991A9FB0@phx.gbl> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C02B68BE0@egcrc-ex01.egcrc.org>




>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




view thread (3+ messages)  latest in thread

Message-ID: <BAY123-F34E249D93C4A608AFD0991A9FB0@phx.gbl>
Permalink:  ../BAY123-F34E249D93C4A608AFD0991A9FB0@phx.gbl/
Also on:    postgresql.org/message-id/BAY123-F34E249D93C4A608AFD0991A9FB0@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: aroravishal22@hotmail.com, tsakai@gallo.ucsf.edu
  Subject: Re: getting service from a local server (v8.2.4)
  In-Reply-To: <BAY123-F34E249D93C4A608AFD0991A9FB0@phx.gbl>
  References: <FE44E0D7EAD2ED4BB2165071DB8E328C02B68BE0@egcrc-ex01.egcrc.org> <BAY123-F34E249D93C4A608AFD0991A9FB0@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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