[ic] Interchange remote Postgres TCP
Stefan Hornburg (Racke)
racke at linuxia.de
Thu Jul 19 09:58:32 EDT 2007
Stephen Peters wrote:
> I can't seem to get interchange to connect to a remote Postgres server.
> I have the following entry
> in /var/lib/interchange/catalogs/standard/catalog.cfg
>
> ifndef SQLDSN
> Variable SQLDSN dbi:Pg:dbname=standard;host='my.postgres.server':5432
> Variable SQLDB standard
> Variable SQLUSER standard
> Variable SQLPASS lamepassword
> endif
>
> When I try to start Interchange I get the following errors:
>
> Configuring catalog standard...Using PostgreSQL,
> DSN=dbi:Pg:dbname=standard...table 'tree' failed: connect failed
> (create) -- could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
>
>
> table 'state' failed: connect failed (create) -- could not connect to
> server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
>
> etc, etc....
>
> Is my configuration correct for a Postgres setup?
> How do I configure Interchange to connect to a remote database?
DBD::Pg manual page shows this SQLDSN syntax:
$dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=$host;port=$port;", ...
Regards
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users
mailing list