Search code examples
postgresqlinformixforeign-data-wrapper

PostgreSQL not creating TCP connection using informix_fwd


I'm trying to access InformixDB from PostgreSQL using informix_fwd. I've already created foreign server, user mapping and foreign table. I'm monitoring netstat while trying to query foreign table, but no connections are listed in output and query ends with following error: ERROR: could not open connection to informix server: SQLCODE=-908

PostgreSQL and InformixDB are one separated servers, telnet and dbaccess works.


Solution

  • Hi all and thanks for response. The problem was with SELinux configuration. I temporarily disabled SELinux and everything works fine.