[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
--
Jon Jensen
End Point Corporation
http://www.endpoint.com/
More information about the interchange-users
mailing list