Re: - what protocol for an Internet postgres

From: Network Administrator <netadmin(at)vcsn(dot)com>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: - what protocol for an Internet postgres
Date: 2003-05-16 18:01:53
Message-ID: 1053108113.3ec52791a4b66@webmail.vcsn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I use SSH all the time to tunnel shell and X-windows traffic. I think I
remember getting a local psql connection to a remote database going following
the instruction s in section 3.8 of the Adminstrators guide but its been a
little bit.

If no one else response I'll take a wack at it and send in a step-by-step example.

As a note though, generally, I just SSH into the box that has the database and
then run psql from there or open up pgaccess.

Quoting "Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk>:

> On Thu, 15 May 2003, Fernando Flores Prior wrote:
>
> > Nice !
> >
> > It works just great. This will be a fine asset for the thechdocs.
> >
> > -Fernando
> >
> >
> > At 08:49 p.m. 14/05/2003 -0400, Matthew Nuzum wrote:
> > >This thread got my curiosity going, so I endeavored to try to get it
> working
> > >and am happy to say that it was very easy to tunnel a postgresql
> connection
> > >over ssh.
> > >
> > >Here's what I did...
> >
>
> Yes, smashing. Anyone got some similar destructions for SSH tunneling with
> SSH
> Communications Corp's (www.ssh.com) stuff. I've tried pointing and clicking
> in
> the appropiate dialog several times now and the best I can get is a notice
> from
> the firewall on the system that my test connection has connected to the
> localhost but get a connection refused and don't see any network traffic out
> to
> the server. I can ssh into the server and get a shell (just to clarify that
> point).
>
>
> --
> Nigel J. Andrews
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Palmer 2003-05-16 18:06:24 Re: MSSQL -> PostgreSQL
Previous Message Doug McNaught 2003-05-16 17:53:15 Re: How to run more the one database at once ?