K
kiran kakaraparthy
Guest
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.
Continue reading...
Continue reading...