XRAY: Upgrading PostgreSQL database

This article outlines the prerequisites and procedures for upgrading the Xray PostgreSQL database.

1. Begin by reviewing the Xray system requirements documentation to confirm that the version of PostgreSQL you plan to upgrade to is compatible with your current version of Xray.
   
2. Before initiating the PostgreSQL upgrade, we strongly recommend creating a backup of the database using a pg_dump file, as well as taking a snapshot of the database machine.
   
3. Since Xray relies entirely on the PostgreSQL database, it is essential to stop the Xray application before proceeding with the PostgreSQL upgrade.
   
4. You may only restart Xray once the PostgreSQL upgrade is finished and the database is accessible.

In conclusion, upgrading the PostgreSQL database for Xray requires careful preparation. By verifying compatibility, backing up data, stopping the Xray application, and ensuring a complete upgrade before restarting Xray, you can facilitate a smooth transition and minimize the risk of disruption or data loss.