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

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