PostgreSql Extract - OGG-25359 Could not connect to server with database 'xx', host 'xxx', port 'xx'
(Doc ID 2764911.1)
Last updated on APRIL 17, 2023
Applies to:Oracle GoldenGate - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Newly configured Postgresql extract failed with
2021-01-19 19:45:34 ERROR OGG-25359 Could not connect to server with
database '<Dbname>', host '<IP Address>', port '1234' and user name
'<username>'. Error Message: could not connect to server: Connection refused
Is the server running on host "<IP Address>" and accepting
TCP/IP connections on port 1234?.
2021-01-19 19:45:34 ERROR OGG-00145 Call to VAMInitialize returned with
error status 16002.
The port number should be 12345, but the error showing port number '1234'
postgres=# select inet_server_addr( ), inet_server_port( );
-[ RECORD 1 ]----+-
postgres=# show port;
The odbc.ini file was also having the port number as 12345
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document