Hey Guys,
I am new to postgresql Database administration.
I am trying to connect to postgresql database through golden gate , but encountered with below error.
GGSCI (illin1282) 3> dblogin sourcedb GG_Postgres userid postgres
Password:
2016-09-23 14:32:07 WARNING OGG-00552 Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR: Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.Failed to open data source GG_Postgres for user postgres.
I used below odbc.ini file:
[ODBC Data Sources]
GG_Postgres=DataDirect 9.5.4 PostgreSQL Wire Protocol
[ODBC]
IANAAppCodePage=106
InstallDir=/u01/postgres/ggs
[GG_Postgres]
Driver=/u01/postgres/ggs/lib/GGpsql25.so
Description=DataDirect 9.5.4 PostgreSQL Wire Protocol
Database=ashwin
HostName=10.232.230.35
PortNumber=5434
LogonID=postgres
Password=postgres
Any help is appreciated.
Regards,
KiranBapuji.
OracleDBA.
Thanks.
I resolved by adding below under pg_hba.conf and bounced the postgresql instance.
local all all trust
host all all 0.0.0.0/0 trust