Re: Connect to postgres from a dynamic IP

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Connect to postgres from a dynamic IP
Date: 2008-03-03 10:33:17
Message-ID: 20080303103317.GG22441@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes:
> Dear Sirs,
>
> it is possible to connect to PostgreSQL server from a client with a dynamic
> IP (or from an unknown IP)?

Of course, yes.

>
> How I have to configure pg_hba.conf (and/or eventually my router, where the
> server is located)?

Set the CIDR to 0.0.0.0/32.

>
> I have no possibility to change the settings of clients (my customers)

Keep in mind, with this way everyone from around the world have access
to your database-server. Consider other solutions like a VPN or a
SSH-Tunnel. At least you should use strong authentication (md5) or SSL.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2008-03-03 10:59:36 Re: Connect to postgres from a dynamic IP
Previous Message Jorge Godoy 2008-03-03 10:32:46 Re: Connect to postgres from a dynamic IP