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 C18019DC84E for ; Sun, 1 Jan 2006 11:40:47 -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 16406-07 for ; Sun, 1 Jan 2006 11:40:50 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by postgresql.org (Postfix) with ESMTP id EB02B9DC81F for ; Sun, 1 Jan 2006 11:40:43 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so2357823nzn for ; Sun, 01 Jan 2006 07:40:49 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=l5YDVRwdjLZ8ezri6XWWP9dIEn6yC4uZk5Ln2c9YpIKzRlsTiByb5T+KK/QkWh4OWz4hQ6rwcEbqJMtcKDKHDPvbVroC+ZTmEnAcI/c1y2uf8K90TbYNqA90Isb6tS9tk1Wqap8zz+yeBcposntbou2SoGFiHHRSjOvd0vxVfco= Received: by 10.65.119.13 with SMTP id w13mr30870qbm; Sun, 01 Jan 2006 07:40:48 -0800 (PST) Received: by 10.64.53.4 with HTTP; Sun, 1 Jan 2006 07:40:48 -0800 (PST) Message-ID: <530357980601010740j7b80e975s@mail.gmail.com> Date: Sun, 1 Jan 2006 16:40:48 +0100 From: =?ISO-8859-1?Q?Szabolcs_Andr=E1si?= To: pgsql-admin@postgresql.org Subject: Connect to PostgreSQL server from an ADSL connection MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/3 X-Sequence-Number: 20091 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. I know that there is the "listen_addresses" parameter in the postgresql.conf file, which can have not only IP addresses as value but domain names also, and it is required for remote connections. But in the pg_hba.conf file - as far as I know - I can not use domain names only IP addresses, so it seems to me that I can not push the advantage of registered domain name at dyndns.org. Is there any way to configure the PostgreSQL server to accept remote connection from one (but always the same) computer which has dynamic IP address? Thank you in advance, Szabolcs p.s.: Sorry for my bad English... If something is not clear, I will try to explain it more detailed.