Skip site navigation (1) Skip section navigation (2)

Re: Remote connections to postgres...

From: Joel Burton <jburton(at)scw(dot)org>
To: Bob Whitehouse <bwhitehouse(at)geeknest(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Remote connections to postgres...
Date: 2001-04-23 19:10:20
Message-ID: Pine.LNX.4.21.0104231509430.29603-100000@olympus.scw.org (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

pgsql-novice by date

Next:From: Ian Lance TaylorDate: 2001-04-23 20:25:13
Subject: Re: Using cursors inside PL/pgSQL function
Previous:From: Poul KristensenDate: 2001-04-23 18:53:36
Subject: Re: Java Interface for postgres database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group