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 6DED6D1B989 for ; Mon, 23 Feb 2004 21:05:53 +0000 (GMT) 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 49073-04 for ; Mon, 23 Feb 2004 17:05:48 -0400 (AST) Received: from viola.nmsu.edu (viola.nmsu.edu [128.123.95.210]) by svr1.postgresql.org (Postfix) with ESMTP id 943A6D1B904 for ; Mon, 23 Feb 2004 17:05:45 -0400 (AST) Received: (from brook@localhost) by viola.nmsu.edu (8.11.6p2/8.11.6) id i1NL5jt03490; Mon, 23 Feb 2004 14:05:45 -0700 (MST) From: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16442.27433.659944.973586@viola.nmsu.edu> Date: Mon, 23 Feb 2004 14:05:45 -0700 To: pgsql-admin@postgresql.org Subject: pg_hba.conf and user files X-Mailer: VM 7.17 under Emacs 21.3.1 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/368 X-Sequence-Number: 12541 I am trying to set up pg_hba.conf for PostgreSQL 7.3. I want to limit access to a database from a host to the set of users in a file. The documentation suggests that this is done as follows: host dbname @user_file 10.0.1.12 255.255.255.255 md5 However, the postmaster complains of a syntax error for lines such as this. There is in fact a file of the appropriate name (user_file in same directory as pg_hba.conf), readable by the backend. It contains a list of user names, one per line. Is this the correct setup? If not, how is this supposed to be accomplished? Thanks for your help. Cheers, Brook