Skip site navigation (1) Skip section navigation (2)

Re: enhance documentation for SSH-tunneled access to database

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <hauser(at)acm(dot)org>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: enhance documentation for SSH-tunneled access to database
Date: 2003-09-13 20:27:55
Message-ID: 03AF4E498C591348A42FC93DEA9661B844B602@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
Hi Ralf,

I have made a couple of minor changes to
http://www.pgadmin.org/pgadmin2/pgadmin2.php?ContentID=11 that should
address these issues. Thanks for your email!

Regards, Dave.

> -----Original Message-----
> From: Ralf Hauser [mailto:ralfhauser(at)gmx(dot)ch] 
> Sent: 13 September 2003 16:00
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] enhance documentation for 
> SSH-tunneled access to database
> 
> 
> Dave,
> 
> Thanks for the quick help.
> In the meantime, I solved the problem:
> 'enable "tcpip_socket" in postgresql.conf'.
> It would be great if Fred could integrate these two newbie 
> obstacles into the documentation.
> 
> Rgds r.
> > -----Original Message-----
> > From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > Sent: Samstag, 13. September 2003 14:38
> > To: hauser(at)acm(dot)org; pgadmin-support(at)postgresql(dot)org
> > Subject: RE: [pgadmin-support] enhance documentation for 
> SSH-tunneled 
> > access to database
> >
> >
> > Hi Ralf,
> >
> > Unfortunately I never used SSL with pgAdmin II myself, so 
> cannot add 
> > to the detail in the howto, however you might like to try 
> pgAdmin III 
> > (currently at beta 2 release) which includes built in SSL 
> support and 
> > provides all the core functionality of pgAdmin II. You can find 
> > pgAdmin III at www.pgadmin.org/pgadmin3/.
> >
> > Regards, Dave.
> >
> > > -----Original Message-----
> > > From: Ralf Hauser [mailto:ralfhauser(at)gmx(dot)ch]
> > > Sent: 13 September 2003 11:19
> > > To: pgadmin-support(at)postgresql(dot)org
> > > Subject: [pgadmin-support] enhance documentation for SSH-tunneled 
> > > access to database
> > >
> > >
> > > Hi,
> > >
> > > "How do I... Use pgAdmin II via a secure (encrypted) connection?" 
> > > (http://pgadmin.postgresql.org/pgadmin2/pgadmin2.php?ContentID
> > =11) is an excellent start.
> >
> > I am using the same set-up for mysql for months without a problem.
> >
> > To get this also working with postgres, I tried many 
> approaches with 
> > no success, but then, I noticed that
> >
> > 1) even on the server on which postmaster/the database is 
> running, I 
> > get
> >
> > <<[root(at)calimero data]# psql -h localhost -p 5432 -U myUserId myDB
> > psql: could not connect to server: Connection refused
> >         Is the server running on host localhost and accepting
> >         TCP/IP connections on port 5432?>>
> > so, perhaps, something needs to be changed on the server side first?
> >
> > 2) secondly, Fred says to enhance pg_hba.conf, but he 
> doesn't hint how 
> > to get that additional IP address: Especially since more and more 
> > db-servers are behind firewalls and NATed, this is not so trivial.
> >
> > My finding so far is that "/sbin/ifconfig" provides this additional 
> > IP-address that is not visible to the outside.
> >
> > Anyway, any hints how to solve 1) would be highly appreciated!
> >
> > 	Ralf
> >
> >
> > ---------------------------(end of 
> > broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an 
> index scan if
> > your
> >       joining column's datatypes do not match
> >
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
               http://www.postgresql.org/docs/faqs/FAQ.html

pgadmin-support by date

Next:From: pginfoDate: 2003-09-14 08:28:35
Subject: Re: problem installing pgAdmin 3 on red hat 7.3
Previous:From: Dave PageDate: 2003-09-13 19:10:08
Subject: Re: Error Message: Type mismatch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group