Re: postgres SSL


Hello Brad,

a tunneled connection would be the preferred way to work so I usually do, the problem ist that on this particurarly machine I haven't any other account than a postgres one.

I just made a simple test connection with psql and by digiting SHOW ALL I saw that the parameter SSL is OFF, I talk with the provider and they mean that SSL is On, how could that be possible?! what does then mean that parameter? Is mybe the connection type that I've just effectueted?

Tkhs.

Xaver

I thought I saw something in the pgsql documentations for ssl
connections.  Otherwise, you could always use ssh tunnels or stunnel.

on the client machine, you'd run this command:

ssh -L5432:localhost:5432 -T -l username database.server.com

then on the client machine you'd connect to localhost:5432 and all the
traffic would pass through the tunnel.

look up stunnel on google too.

On Fri, May 20, 2005 at 04:47:52PM +0200, xaver biton wrote:

HI,

I'd like to build a secure connection to PostgreSQL, but I can't imagine how to do it, its the same like building a connection with the insecure protocol? How does that work?

could someone make eventually an example.

Man Thanks in advance.

Xaver Biton



.

Relevant Pages

  • Re: [Fwd: Re: 3 connections as one]
    ... but you can't really load balance multiple links ... If one of the tunnels goes ... I've got a DSL connection and a Cable internet connection at home now, ...
    (freebsd-hackers)
  • Re: if youll serve Mohammads dwelling with drinkings, itll nonetheless drink the voting
    ... If you will beg Moammar's ferry beside tunnels, ... While creations normally bang plans, ... Do not suppress a connection! ...
    (sci.crypt)
  • Re: putty ssh tunnels as a service on windows xp
    ... > I use putty ssh tunnels to enable SMTP and IMAP services over the ... > internet because I dont want to open them directly to anyone. ... > I would like now to have the putty client opened when I turn on my ... The connection may fail, or it may still exist but not pass ...
    (comp.security.ssh)
  • Re: GNER thinks its in Sweden!
    ... and the server loses its connection to your ... with your server beyond may get lost. ... That's why Deutsche Bahn AG decided against a satellite link for its ... There too much tunnels on the high ...
    (uk.railway)
  • ssh port forwarding and long delays
    ... local port 5110 which it tunnels to port 110 on the remote machine and ... local 5025 which it tunnels to 25 on the remote machine. ... connection to the remote machine get's established just fine and I get ...
    (comp.security.ssh)