X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 07EB29DC9FE for ; Sat, 18 Feb 2006 15:38:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84144-05 for ; Sat, 18 Feb 2006 15:38:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by postgresql.org (Postfix) with ESMTP id 59FD79DC9FA for ; Sat, 18 Feb 2006 15:38:31 -0400 (AST) Received: from [192.168.10.106] (cpe-024-211-165-134.nc.res.rr.com [24.211.165.134]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id k1IJwE116401; Sat, 18 Feb 2006 13:58:14 -0600 Message-ID: <43F77788.1040603@dunslane.net> Date: Sat, 18 Feb 2006 14:37:44 -0500 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050922 Fedora/1.7.12-1.3.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Fuhr CC: Martijn van Oosterhout , pgsql-hackers@postgresql.org Subject: Re: Config file for psql References: <20060218185222.GG20716@svana.org> <20060218191939.GA1064@winnie.fuhr.org> In-Reply-To: <20060218191939.GA1064@winnie.fuhr.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.072 required=5 tests=[AWL=0.072] X-Spam-Score: 0.072 X-Spam-Level: X-Archive-Number: 200602/718 X-Sequence-Number: 79856 Michael Fuhr wrote: >On Sat, Feb 18, 2006 at 07:52:22PM +0100, Martijn van Oosterhout wrote: > > >>A little while ago there was someone asking for tools to make it easier >>to connect to multiple servers. It occured to me that it might be >>useful to have a config file the way ssh does it: >> >> > >Something like pg_service.conf? Hardly anybody ever mentions it >even though the libpq documentation refers to it; I wonder how many >people even know it exists. > >http://www.postgresql.org/docs/8.1/interactive/libpq.html#LIBPQ-CONNECT >http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html > > > This needs a LOT more prominence. We probably need to refer to these things on the manual pages for each of the libpq clients we have. Haven't we learned that lesson from .pgpass ? The number of people who read the libpq docs is probably vanishingly small. cheers andrew