From: stig erikson <stigerikson_nospam_@yahoo.se>
To: pgsql-admin@postgresql.org
Subject: Re: Help with access control settings in pg_hba.conf -- AAAARGH!
Date: Sun, 30 Jan 2005 23:55:03 +0100
Message-ID: <ctjoka$2ehp$1@news.hub.org> (raw)
In-Reply-To: <Pine.OSX.4.50.0501270949130.17513-100000@phobos.cs.umass.edu>
References: <Pine.OSX.4.50.0501270949130.17513-100000@phobos.cs.umass.edu>
Victor Danilchenko wrote:
> Hi,
>
> I am trying to set up a database server with multiple DB
> clusters, so that in each cluster a number of users have their own
> database each, with passwordless access (we can trust the network
> security in our installation). The following is what seems like it
> *should* work:
>
> host all all 127.0.0.1 255.255.255.255 password
> host sameuser all xxx.xxx.xxx.0 255.255.255.128 ident sameuser
> host all @fac xxx.xxx.xxx.0 255.255.255.128 trust
>
> The second line ("host sameuser") is the problem. It doesn't
> work -- when tryign to connect, I keep getting error messages:
>
> $ whoami
> testuser
> $ psql -h db-edlab -p 7666 testuser testuser
> psql: FATAL: IDENT authentication failed for user "testuser"
>
> If I replace 'ident sameuser' with 'trust' there, it works fine
> -- but then any user can access anyone else's database, providing they
> request the same password.
you need to read the manual to understand what same user does/does not.
>
> The idea is that each user should be able to access only their
> database, only as themselves, without password -- but I can't figure out
> what I am doing wrong. Any help? if what I am trying to do is
> impossible, is there any other way to achieve such a goal -- i.e.
> passwordless access that allows each user to access only their own
> database over the network?
>
have not had the need for this, but i guess that the sql-commands GRANT and/or
REVOKE can be of help, look in the manual.
>
> BTW, as long as I am writing, a somewhat related question, which
> is not nearly as important as the previous one.
>
> I launch multiple postmatser processes, each servicing a
> dedicated DB cluster on a dedicated port. The problem is that I only
> ever see *one* local UNIX socket (/tmp/.s.PGSQL.<portnumber>) file.
> There is a .lock file created corresponding to each server/port combo,
> but it looks like each subsequent instance of the postmaster kills the
> previous instance's UNIX socket. Is this how it should be -- and if so,
> are there any pg_ctl options I can pass in to make it simply not create
> the UNIX sockets altogether, so that only network operations are
> supported? AT the moment, I am doing admin access though the loopback
> device, so it's not a big issue.
>
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: stigerikson_nospam_@yahoo.se
Subject: Re: Help with access control settings in pg_hba.conf -- AAAARGH!
In-Reply-To: <ctjoka$2ehp$1@news.hub.org>
References: <Pine.OSX.4.50.0501270949130.17513-100000@phobos.cs.umass.edu> <ctjoka$2ehp$1@news.hub.org>
* 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