X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4B93DD1B191 for ; Tue, 18 May 2004 17:26:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 70911-09 for ; Tue, 18 May 2004 17:26:35 -0300 (ADT) Received: from viola.nmsu.edu (viola.nmsu.edu [128.123.95.210]) by svr1.postgresql.org (Postfix) with ESMTP id ABA60D1B18F for ; Tue, 18 May 2004 17:26:32 -0300 (ADT) Received: (from brook@localhost) by viola.nmsu.edu (8.11.6p2/8.11.6) id i4IKQXa02445; Tue, 18 May 2004 14:26:33 -0600 (MDT) From: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16554.29048.700551.259036@viola.nmsu.edu> Date: Tue, 18 May 2004 14:26:32 -0600 To: pgsql-admin@postgresql.org Cc: brook@nmsu.edu Subject: pg_hba.conf and groups X-Mailer: VM 7.17 under Emacs 21.3.1 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200405/184 X-Sequence-Number: 13500 I am trying to allow individuals within a PostgreSQL (v7.4) group to connect to the backend. The relevant line in pg_hba.conf is (I believe): host + /32 md5 Note that I have replaced the contents of the real fields with <...>, but that these match across what follows. I understand the + to allow access to members of the group. The contents of the system catalogs include the following: # select * from pg_catalog.pg_shadow; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig -------------+----------+-------------+----------+-----------+--------+----------+----------- | 105 | f | f | f | md5... | | # select * from pg_catalog.pg_group; groname | grosysid | grolist ---------+----------+----------------------- | 100 | {100,101,102,104,105} Nevertheless, the following command fails: psql --host --dbname= --username= psql: FATAL: no pg_hba.conf entry for host "", user "", database "", SSL off Have I set this up incorrectly? Is there any way to query the backend in order to identify who it thinks has access to what? Thanks for your help. Cheers, Brook