in reply to Any implementations of DBI through SSH?

Postgres also permits ssl encrypted connections. One of my typical connection modules include this function:

sub connect { my $self = shift; my $db = shift; my $db_driver = $db->{'db_driver'}; my $host_name = $db->{'db_host'}; my $db_name = $db->{'db_name'}; my $USER = $db->{'db_user'}; my $PASSWORD = $db->{'db_pw'}; my $dsn = "DBI:$db_driver:host=$host_name;database=$db_name"; if($db->{'db_ssl'}){ $dsn .= ';sslmode=require'; } # print $dsn,"\n"; return (DBI->connect($dsn,$USER,$PASSWORD, {PrintError => 0, RaiseError => 1})); }
while my /etc/postgres/8.1/main/pg_hba.conf, includes:

# local DATABASE USER METHOD [OPTION] # host DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION] hostssl db_name db_user 192.168.105.45/32 md5
-- Hugh

if( $lal && $lol ) { $life++; }