[ic] Interchange remote Postgres TCP

[Jon Jensen]

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/