Re: Remote connections to postgres...

On Mon, 23 Apr 2001, Bob Whitehouse wrote:

> I need to connect to the postgres server from a remote machine with a Perl
> script. If I were on a local machine I would use something like this for the
> first part of the connection string: 'DBI:Pg:dbname=name'
>
> Can someone give me and example of what the connection string would look
> like from a remote machine?

`man DBD::Pg`

shows

$dbh =
DBI->connect("dbi:Pg:dbname=$dbname;host=$host;port=$port;options=$options
;tty=$tty", "$username", "$password");

as an example.

Does this work?

--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington