Switch DB from Oracle to PostGres
We are trying to switch database from Oracle to PG. the data has been migrated (and adapted for PG) and next is to point the app server to DB (it would be war based VM deployment) - What all places needs to be updated for connection details to achieve the same. We have updated : prConfig.xml, context.xml, application.xml and prpcUtils (for command line). But seems something is not complete - tomcat has been started but Kafka fails to come up.
LTIMindtree
SA
You'll need to update the DB Connection parameters in couple of areas in application.xml file. Probably, you can attach here for review. I'll check and let you know.
Before Deploying the .war deployments, You can truncate the below DB Tables.
Truncate table <DATA-Schema>.pr_sys_delayed_queue;
Truncate table <DATA-Schema>.pr_data_stream_nodes;
Truncate table <DATA-Schema>.pr_data_stream_sessions;
Truncate table <DATA-Schema>.pr_sys_statusnodes;
Truncate table <DATA-Schema>.pr_sys_statusdetails;
Truncate table <DATA-Schema>.pr_data_stream_node_updates;
TRUNCATE table <DATA-Schema>.pr_perf_stats;