2024-02-09 22:33:03Hargata Softworks: added steps to import and export from postgres
postgres.md ..
@@ 30,3 30,29 @@
A tool is provided to ease the migration process between LiteDB and Postgres. This tool can be found at the `/migration` endpoint and is only accessible when a Postgres connection is provided.
+
+
### Importing to Postgres
+
+
To transfer all your existing data from LiteDB to Postgres:
+
1. Create a backup using the "Make Backup" feature in the Settings tab.
+
2. Extract the zip file.
+
3. You should see a folder named "data" in the extracted folder
+
4. Inside the data folder will be a .db file named `cartracker.db`
+
5. Navigate to the Database Migration tool
+
6. Click "Import to Postgres"
+
7. Select the `cartracker.db` file
+
8. Your data will be imported into your Postgres DB, and you may double check that the DB has been imported successfully using a Postgres DB Administration Tool.
+
+
### Exporting from Postgres
+
+
In the event that you need to transfer all your data back onto a LiteDB database file from Postgres, you may do so using the Database Migration tool:
+
1. Navigate to the Database Migration Tool
+
2. Click "Export from Postgres"
+
3. Extract the downloaded zip file and you should find `cartracker.db` in it.
+
4. Create a backup using the "Make Backup" feature in the Settings tab.
+
5. Extract the zip file.
+
6. You should see a folder named "data" in the extracted folder, if not, create it.
+
7. Place `cartracker.db` inside the "data" folder
+
8. Re-zip the extracted folder
+
9. Restore the backup using the "Restore Backup" feature in the Settings tab.
+
10. Make sure you remove the PostgreSQL connection from the environment variables so that all future changes will be saved in LiteDB.
