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
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