Postgres Database Connection through Abinitio

From: "Pelluru, Subramanyam" <Subramani(dot)Pelluru(dot)ap(at)nielsen(dot)com>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Cc: "Subramanian, Sriraman (TCS Consultant)" <Sriraman(dot)Subramanian(dot)consultant(at)nielsen(dot)com>, "Panakkal Varghese, Joseph" <Joseph(dot)PanakkalVarghese(dot)ap(at)nielsen(dot)com>, "Dhandapani, Barath" <Barath(dot)Dhandapani(dot)ap(at)nielsen(dot)com>, "Subramaniam, Ganesan" <Ganesan(dot)Subramaniam(dot)ap(at)nielsen(dot)com>
Subject: Postgres Database Connection through Abinitio
Date: 2016-03-08 16:12:22
Message-ID: BY1PR0701MB18309202285F70D4CAC7384BC9B20@BY1PR0701MB1830.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message CN 2016-03-15 13:51:11 libpq - characterset encoding error from selecting BYTEA
Previous Message Dave Cramer 2015-12-19 11:08:42 Re: PostgreSQL drivers