Thread: Remote connections to postgres...

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?

Thanks, Bob

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@scw.org>
Director of Information Systems, Support Center of Washington