How do I switch from MySQL to PostgreSQL?

How do I switch from MySQL to PostgreSQL?

AuthorFullName__c
JFrog Support
articleNumber
000001517
ft:sourceType
Salesforce
FirstPublishedDate
2016-10-06T13:35:51Z
lastModifiedDate
2024-03-10T07:48:50Z
VersionNumber
5

Please note, if you are running Artifactory with a FullDB storage type which stores the metadata and binaries as BLOBs in the database, then please use the following steps to migrate your data to the PosgreSQL database:

  1. Run a full system export

  2. Create a new DB scheme on your PosgreSQL, as documented in our wiki

     

  3. Shutdown Artifactory

  4. Configure your instance to connect to the new DB

  5. Start Artifactory

  6. Run a full system import from the export you performed

If you are using the filesystem storage type, which stores metadata in the database and the binaries on the file system, the process should be:

  1. Run a full system export with the ‘exclude content’ checked (do not exclude metadata and builds)

  2. Create a new DB scheme on your PosgreSQL, as documented in our wiki

  3. Shutdown Artifactory

  4. Configure your instance to connect to the new DB

  5. Start Artifactory

  6. Run a full system import from the export you performed

If you do not already have a recent backup, it is always recommended to perform a full system export just in case.

 

Please notice that any new content deployed to Artifactory after the export has begun will not be exported and will not be migrated to the new DB.