Request a Demo
Home   >   mailing lists

Postgres Database Connection through Abinitio - Mailing list pgsql-interfaces

From Pelluru, Subramanyam
Subject Postgres Database Connection through Abinitio
Date
Msg-id BY1PR0701MB18309202285F70D4CAC7384BC9B20@BY1PR0701MB1830.namprd07.prod.outlook.com
Whole thread Raw
List pgsql-interfaces
Tree view

Hi Team,


We have to setup Postgres Database connection through ETL Abinitio GDE/Co-Op system.

We have tried with the following configuration parameters in the .dbc file .


dbms: PostgreSQL
db_version: 9.2
db_home: /opt/PostgreSQL/9.2
db_name: @postgres
db_nodes: tparhermsd001
user: postgres
password: postgres


But we are ending up with the below error.


ABINITIO(DB00113):  Error remotely executing 'm_db' on node 'tparhermsd001.nielsen.com'.
tparhermsd001.nielsen.com: Remote job failed to start up
================================================================


Please let us know the files or any other configuraion items we require to connect to the Postgres database.


Thanks,

Subramanyam Pelluru

pgsql-interfaces by date:

Previous
From: Dave Cramer
Date:
Subject: Re: PostgreSQL drivers
Next
From: CN
Date:
Subject: libpq - characterset encoding error from selecting BYTEA