X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C4C0B9DC84E for ; Sun, 1 Jan 2006 11:58:49 -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 22984-04 for ; Sun, 1 Jan 2006 11:58:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.tgds.net (tgds.net [212.100.249.157]) by postgresql.org (Postfix) with ESMTP id 8EA069DC81F for ; Sun, 1 Jan 2006 11:58:47 -0400 (AST) Received: from hush.localdomain (localhost [127.0.0.1]) by mail.tgds.net (Postfix) with ESMTP id A86771435E6; Sun, 1 Jan 2006 15:57:54 +0000 (GMT) Subject: Re: Connect to PostgreSQL server from an ADSL connection From: tony To: Szabolcs =?ISO-8859-1?Q?Andr=E1si?= Cc: pgsql-admin@postgresql.org In-Reply-To: <530357980601010740j7b80e975s@mail.gmail.com> References: <530357980601010740j7b80e975s@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-15 Date: Sun, 01 Jan 2006 16:58:50 +0100 Message-Id: <1136131131.2833.41.camel@hush.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.037 required=5 tests=[AWL=0.037] X-Spam-Score: 0.037 X-Spam-Level: X-Archive-Number: 200601/4 X-Sequence-Number: 20092 Le dimanche 01 janvier 2006 à 16:40 +0100, Szabolcs Andrási a écrit : > Hi all, > > I am writing because I would like to know that how can I connect > remotely to a PostgreSQL database from an ADSL connection, which has > different IP address every time when it connects to the Internet. This > ADSL connection is registered to www.dyndns.org, so its dynamic IP > address is replaceable with the registered domain name. > My problem is the changing IP address: I would not like to modify the > pg_hba.conf file every time when the remote computer's IP address > changes. ssh -v -L 5432:localhost:5432 dbuser@your.dyndns.domaine Then connect to your database on localhost. Cheers Tony -- Tony Grant www.tgds.net - vente d'ordinateurs mini-itx en ligne www.tgds.net/epiaix1.html - A fedora Core 4 based live CD for VIA Epia-M