Thread: remote connection, web hosting, IP adress

am  05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
> How can I connect to remote server from a remote personal computer
> without its own IP adress ?

You can connect to the remote server via ssh. Then you are a local user.
SSH is a highly secure protocol, i suggest, use ssh with PublicKey-AUTH.
If you connect to the server, than you can use 'psql -h localhost'.


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

On Mon, Sep 05, 2005 at 03:49:23PM +0200, Zlatko Mati? wrote:
> Hello.
>
> I will install a database on a remote server. There is pg_hba.config file that should be adjusted to protect from
unauthorizedaccess. It requires IP adresses. 
> Now, I would like to be able to connect to the server from my personal computer, in order to do some maintenance job
onthe database remotely. I don't have my personal IP adress till now. So, I'm wondering whether it would be possible to
connectthrough some web hosting that offers fixed IP adress to its customers? I would adjust pg_hba to allow access
fromthat IP adress... 
> How can I connect to remote server from a remote personal computer without its own IP adress ?
> Thanks in advance,

pg_hba.conf allows you to allow access from ranges of IP addresses and
to require different levels of authentication. You could allow access
to your user from anywhere on the 'net (or, better, the address range
your ISP allocates your dialup address from) and require a good password.

Using SSL would make that connection more secure, and you may even be
able to require a client certificate.

Or you could just do the standard thing for remote access and use
ssh to connect to the server, then run psql from the commandline.
(You could port forward over ssh too, but if you're using psql
 for maintenance - and you should be - that doesn't provide much
 added value).

Cheers,
  Steve

ok, thanks

----- Original Message -----
From: "A. Kretschmer" <akretschmer@despammed.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, September 05, 2005 6:15 PM
Subject: Re: [GENERAL] remote connection, web hosting, IP adress


> am  05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
>> How can I connect to remote server from a remote personal computer
>> without its own IP adress ?
>
> You can connect to the remote server via ssh. Then you are a local user.
> SSH is a highly secure protocol, i suggest, use ssh with PublicKey-AUTH.
> If you connect to the server, than you can use 'psql -h localhost'.
>
>
> Regards, Andreas
> --
> Andreas Kretschmer    (Kontakt: siehe Header)
> Heynitz:  035242/47212,      D1: 0160/7141639
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
> ===    Schollglas Unternehmensgruppe    ===
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org