X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 254BA14B286B for ; Wed, 11 Aug 2004 20:20:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05937-08 for ; Wed, 11 Aug 2004 23:20:50 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 359C014B2867 for ; Wed, 11 Aug 2004 20:20:47 -0300 (ADT) Received: (qmail 19728 invoked by uid 500); 11 Aug 2004 23:28:59 -0000 Date: Wed, 11 Aug 2004 18:28:59 -0500 From: Bruno Wolff III To: Mike Bell Cc: pgsql-admin@postgresql.org Subject: Re: Minimal required to run psql on remote machine Message-ID: <20040811232859.GA19680@wolff.to> Mail-Followup-To: Mike Bell , pgsql-admin@postgresql.org References: <002701c47e23$fdbc7cc0$6401a8c0@hashdefine.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <002701c47e23$fdbc7cc0$6401a8c0@hashdefine.local> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/80 X-Sequence-Number: 14475 On Mon, Aug 09, 2004 at 16:17:26 +0100, Mike Bell wrote: > Hi, > > I'd like to run psql on a remote machine. For security, there won't be > login access granted for ssh sessions but we'd like to test various SPs > and so forth. What is the minimum I have to install on to the remote > machine so that I can connect with psql -h remote ? The base postgres install should allow this. You just need to make sure your packet filter and pg_hba.conf allow connections from the particular hosts you want to allow access from.