Steps to be followed:

NOTE: Take a DB snapshot/backup before performing the following steps

1. Remove the master.key from the $XRAY_HOME/etc/security/master.key:

mv master.key master.key.bkp

*Note: this does not actually remove the file, but rather renames it so it can no longer be detected by Xray

2. Enter the PostgreSql db:
Navigate to your postgresql installation location and execute the following command:

psql xraydb xray

3. To list all tables: \dt

4. Remove the master.key from the database:

SELECT * FROM key_id; 
 DELETE FROM key_id;

5. Remove high availability documents(if applicable):

DELETE FROM high_availability WHERE version = 'xray_version'; 

6. Remove the binary manager indexed resources data from below table first(We should be adding them from UI once the instance is up):

SELECT * FROM binary_managers_indexed_resources;
DELETE FROM binary_managers_indexed_resources;

7. Remove the binary manager:

SELECT * FROM binary_managers;
DELETE FROM binary_managers where bin_mgr_id = 'your_instance_id'

8. Remove the old admin account (this table may or may not be empty):
#This is in case the users' password got encrypted, it'll regenerate with "password" as the default

Delete from users where name = 'admin'

9. If any of the password fields are encrypted in system.yaml , set them to their decrypted state/ plain text. They will get re-encrypted on restart.

10. Restart Xray and everything should start working again.