Postgres Pro
Downloads
Home   >   mailing lists

Re: Connect to postgres from a dynamic IP - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Connect to postgres from a dynamic IP
Date
Msg-id 20080303103317.GG22441@a-kretschmer.de
Whole thread Raw
In response to Connect to postgres from a dynamic IP  ("dfx" <dfx@dfx.it>)
Responses Re: Connect to postgres from a dynamic IP  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Connect to postgres from a dynamic IP
Next
From: Magnus Hagander
Date:
Subject: Re: Connect to postgres from a dynamic IP