[ic] Interchange remote Postgres TCP

Jon Jensen jon at endpoint.com
Thu Jul 19 13:13:18 EDT 2007

On Thu, 19 Jul 2007, Stephen Peters wrote:

> When I tried to connect with a standard Perl DBI call (after I corrected
> my syntax) I can connect to the database. e.g.
> perl -MDBI -le 'DBI->connect( \
> 	qq{dbi:Pg:dbname=standard;host=my.postgres.server;port=5432;} \
> 	) and print qq{OK!}'
>> Why do you have single quotes in the DSN? Have you tried without them?
> This was an attempt to figure out why the error was truncating the DSN
> e.g.
> Configuring catalog standard...Using PostgreSQL,
> DSN=dbi:Pg:dbname=standard...

It appears to me that your DSN setting is being overwritten somewhere 
else. I suggest grepping for it, like this:

cd /path/to/catalog
grep -ri 'dbi:pg:' .

and see where else the DSN may be getting set.


Jon Jensen
End Point Corporation

More information about the interchange-users mailing list