Re: [pgsql-www] Setting up for Press Contacts inSE Asia

[Magnus Hagander <magnus(at)hagander(dot)net>]

On Mon, Jan 28, 2008 at 04:40:15PM -0800, Josh Berkus wrote:
> Magnus,
> 
> > And I assume ssl is as good as ssh :P
> 
> How do I connect on the command line with SSL?  Or port-forward?

Oh man, please tell me I misunderstood your question. Or do you really not
know how SSL works in PostgreSQL - core member and all? ;-)

Anyway. Just use psql the normal way, and it'll go into SSL mode
automatically when it's configured like that on the server.


> For the press list etc I need a way to fairly rapidly hand-edit a lot of 
> the list.  I've ben using pgAdmin for that, so I'll need to keep having 
> something similar.  I'll also need ssh access so that I can upload new 
> batch files, such as from conferences.

pgAdmin will also work perfectly well over SSL. And I don't see why you'd
need ssh access to the database server for any of that - you can just use
psql locally.


> > If you can just limit what IP is used, that should be no problem.
> 
> IP used for which?

The client machine(s) that shuold be allowed to connect to the database.

//Magnus