Troubleshooting

Available troubleshooting tools and recommended steps to take when debugging the behavior of your Charmed PostgreSQL deployment:

• Overview
  • Check charm status
  • Check logs
  • Check processes running inside the charm
  • Install extra software

Advanced troubleshooting

Learn about manual and automated switchover/failover procedures when there is an issue with the primary unit:

• Switchover/failover
  • Switchover
  • Failover
  • Raft re-initialisation (VM only)

Examples of how to use low-level, Patroni-based CLI tools for advanced troubleshooting:

• CLI helpers
  • Patroni
    • patronictl
      • Cluster status
      • Useful Patroni actions
      • Low-level Switchover and failover
      • Re-initialisation
    • Patroni REST API
    • Raft library

Details about using the SoS report tool with PostgreQL for data collection:

• SOS report
  • Use built-in SoS (recommended)
    • Collect logs on one unit
    • Collect logs from several units
  • Use the latest SoS plugins from Git