1. Take the backup of the Xray database from Postgres server.
2. Shut down the Xray service.
3. Login to PostgreSQL database server and enter the credentials:
4. Look for binary_managers table and copy the id of the previous Artifactory instance:
5. Delete that entry in binary_managers table using Artifactory instance id:
6. Check binary_managers_indexed_resources table as well and perform the same delete procedure if any entries are found. Note we can not delete entries from the binary_managers table if we have data in binary_managers_indexed_resources table as it has a foreign key reference.
7. Start the Xray service and check Indexed Resources > Repositories.
Please note that we need to add the existing indexed resources again post the restart. Above steps should help to reset the Xray connection with Artifactory in the JFrog platform.
2. Shut down the Xray service.
3. Login to PostgreSQL database server and enter the credentials:
psql -U xray xraydb
4. Look for binary_managers table and copy the id of the previous Artifactory instance:
SELECT * FROM binary_managers;
5. Delete that entry in binary_managers table using Artifactory instance id:
DELETE FROM binary_managers WHERE id='<previous_artifactory_id>';
6. Check binary_managers_indexed_resources table as well and perform the same delete procedure if any entries are found. Note we can not delete entries from the binary_managers table if we have data in binary_managers_indexed_resources table as it has a foreign key reference.
7. Start the Xray service and check Indexed Resources > Repositories.
Please note that we need to add the existing indexed resources again post the restart. Above steps should help to reset the Xray connection with Artifactory in the JFrog platform.