Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2017
    Posts
    1

    Unanswered: Postgresql error while setting up GG replication between Oracle and postgresql dbs

    Hi All,

    We are trying to set up Goldengate replication between Oracle and Postgresql databases running on different hosts and we are getting the below error while trying to connect to the postgresql database via Goldengate from the postgres box.

    dblogin sourcedb GG_Postgres userid postgres_gg
    Password:

    WARNING OGG-00552 Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08001 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Connection refused. Verify Host Name and Port Number.
    ERROR: Database operation failed: Couldn't connect to GG_Postgres. ODBC error: SQLSTATE 08001 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Connection refused. Verify Host Name and Port Number.Failed to open data source GG_Postgres for user postgres_gg.

    Below is the odbc parameter file which we are using.

    -bash-4.1$ cat /u01/oracle/ggs_new_112102/odbc.ini
    [ODBC Data Sources]
    GG_Postgres=DataDirect 6.1 PostgreSQL Wire Protocol
    [ODBC]
    IANAAppCodePage=106
    InstallDir=/u01/oracle/ggs_new_112102
    [GG_Postgres]
    Driver=/u01/oracle/ggs_new_112102/lib/GGpsql25.so
    Description=DataDirect 6.1 PostgreSQL Wire Protocol
    Database=postgres
    HostName=vc2coma2253341n.fmr.com
    PortNumber=5432
    LogonID=postgres_gg
    Password=postgres_gg

    Also we are unable to hit the internal connection via psql.

    -bash-4.1$ psql -h vc2coma2253341n.fmr.com -U postgres
    psql: could not connect to server: Connection refused
    Is the server running on host "vc2coma2253341n.fmr.com" (10.240.137.18) and accepting
    TCP/IP connections on port 5432?

    We have modified list_address='*' in postgresql.conf

    Attached are the copies of postgresql.conf and pg_hba.conf

    Can you please advise as to what else needs to be done ?
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2016
    Posts
    55
    Provided Answers: 2
    Not sure abt the goldengate error, but is the postgres server running ??

    ./pg_ctl -D /datapath/data status

    or

    ps -ef | grep postgres

    Can you verify postgresql is running

    regds
    paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •