Troubleshooting
Problem
CDC for Postgresql : 11.4
Postgresql:11
When creating cdc for postgresql instance, got below error:
Cannot create changes:A SQL exception has occurred. The SQL error code is '0'. The SQL state is: 58P01. The error message is:
ERROR: could not access file "test_decoding": No such file or directory
Symptom
Cannot create changes:A SQL exception has occurred. The SQL error code is '0'. The SQL state is: 58P01. The error message is:
ERROR: could not access file "test_decoding": No such file or directory
Cause
You must install postgresql-contrib additional supplied modules on Your source endpoint.
Using below command to install, then re-create instance.
sudo yum install postgresql11-contrib
Environment
You must install postgresql-contrib additional supplied modules on Your source endpoint.
Using below command:
sudo yum install postgresql11-contrib
Then recreate instance.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"11.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
29 July 2019
UID
ibm10961304