Deconfigure logical standby
We want to remove the configuration of logical standby and change the the role of the logical standby back to primary.
The following steps has been performed:
[Primary]
- Update log_archive_dest for removing the logical standby instance
- Remove the log_archive_dest_3 for the logical standby instance
[Logical standby]
- Update log_archive_dest to null
- Update log_archive_dest_3 for standby role to null
What else shall be done to have the database_role to "primary"?