WARNING OGG-00552 Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08S01 native database error 0. - Forum - PUG India - Progress Community

WARNING OGG-00552 Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08S01 native database error 0.

 Forum

WARNING OGG-00552 Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08S01 native database error 0.

  • 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