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 6BD6AD1D26F for ; Fri, 27 Feb 2004 06:05:57 +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 39214-04 for ; Fri, 27 Feb 2004 02:05:56 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id D5431D1D1D5 for ; Fri, 27 Feb 2004 02:05:54 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1R65hiQ017105; Fri, 27 Feb 2004 01:05:43 -0500 (EST) To: brook@biology.nmsu.edu Cc: pgsql-admin@postgresql.org Subject: Re: pg_hba.conf and user files In-reply-to: <16442.27433.659944.973586@viola.nmsu.edu> References: <16442.27433.659944.973586@viola.nmsu.edu> Comments: In-reply-to message dated "Mon, 23 Feb 2004 14:05:45 -0700" Date: Fri, 27 Feb 2004 01:05:43 -0500 Message-ID: <17104.1077861943@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/373 X-Sequence-Number: 12546 writes: > 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. Hm, looks all right to me. What's the *exact* error message? Also, please look in the postmaster's log (stderr or syslog); there may be more info there than is reported to the client. regards, tom lane