Re: Secure connections with changing ip addresses?

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: "gene Campbell" <genecampbell8(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Secure connections with changing ip addresses?
Date: 2006-07-30 20:22:43
Message-ID: 758d5e7f0607301322p6ae8df1cq88642955c2dfdf84@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/29/06, gene Campbell <genecampbell8(at)yahoo(dot)com> wrote:
> I have a pg_hba.conf file that is setup like this
>
> host db1 user1 222.152.155.194/32 md5
>
> From time to time, my ISP changes my ip address on me.
> At that point, my connection to this DB is denied.
>
> I have to log in (ssh) to my server, edit this file with the new ip
> address, save and restart to get connectivity back.
>
> Is there a way to have a secure connection that can withstand
> changing ip addresses?

I think the best solution for you would be some form of VPN,
perhaps IPsec, or vtund (if you're using *nix).

Generally, when you change your IP, you will lose the connection.
And you also have to tell that machine that you changed the IP,
either manually (ssh to server, as you wrote) or automagically
(using the script which will ssh, change the file, signal the DB).

If you set a VPN, you will always have the same IP address, say
192.168.111.111, no matter what your ISP has selected for you now,
and connections to that address can persist your IP changes
(depends how VPN is set up, but it's doable).

Regards,
Dawid

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2006-07-30 20:58:34 Re: Corrupted DB? could not open file pg_clog/####
Previous Message David Hoksza 2006-07-30 19:00:18 Re: pg_statio_all_indexes