Repository navigation
Upgrading To Postgres
JobSync now stores its data in Postgres, and a Postgres container is bundled and starts by itself. Only release 1.2.0 can copy your SQLite data across, so an instance still on SQLite runs 1.2.0 once before moving on to a newer release. A newer release started on a SQLite instance stops with a message that explains this, and modifies nothing, until it has.
Before updating:
-
Move any edits you made to
docker-compose.ymlinto.env. If you setENCRYPTION_KEY,AUTH_SECRET,TZorNEXTAUTH_URLinsidedocker-compose.yml, copy each one into.envasNAME=value, and only then discard the edit withgit checkout -- docker-compose.yml. Do not discard it first: without yourENCRYPTION_KEYin.env, saved API keys can no longer be read. -
Copy
jobsyncdb/data/dev.dbsomewhere safe. It is your complete fallback copy.
Then run 1.2.0 once through the overlay file that ships with JobSync:
docker compose -f docker-compose.yml -f docker-compose.sqlite-import.yml up -dWithout a git checkout, create docker-compose.sqlite-import.yml next to docker-compose.yml with this content:
services:
app:
image: ghcr.io/gsync/jobsync:1.2.0
environment:
- SKIP_IMPORT=${SKIP_IMPORT:-}
- IMPORT_DRY_RUN=${IMPORT_DRY_RUN:-}Wait until the import has finished and the app loads, then update as usual with ./deploy.sh, or docker compose pull && docker compose up -d. Never finish with a plain docker compose up -d: it does not pull, and may restart an old local copy of the SQLite release.
If your instance already runs on Postgres but a dev.db is still in jobsyncdb/data/ (for example after starting with SKIP_IMPORT=1), or you do not need the old data, create an empty file named dev.db.imported-at next to it instead and restart.
If your .env still has an old DATABASE_URL=file:... line, the app ignores it, uses the bundled database and says so in its log; you can delete the line whenever you like.
No, the upgrade is one-way and there is no supported way back to the SQLite release. A failed upgrade is fixed by correcting the cause and restarting. Your old dev.db is never written to, renamed or deleted, so the import can be retried from it as often as needed.
This section describes release 1.2.0, the only release that imports. It copies your data into Postgres once, on its first start, before the app begins serving. Accounts, jobs, resumes, tags, API keys and MCP tokens all come across with the same ids, so you stay logged in. The log shows one line per table, such as Job: 93 → 93 ✓. Afterwards a small file, jobsyncdb/data/dev.db.imported-at, records that the import happened; leave it in place.
If your dev.db was last used by a release older than 1.1.22, the import stops before copying anything and prints one command to run. That command starts the last SQLite release once so it can bring dev.db up to date; press Ctrl+C when it reports it is ready, then start JobSync again.
This applies to release 1.2.0, which keeps honouring SKIP_IMPORT and IMPORT_DRY_RUN when started through the overlay file. Read the last lines of docker compose logs app, fix the cause it names, and restart. A failed import leaves Postgres empty and dev.db untouched, so restarting retries it from the start. To get into the app while you investigate, add SKIP_IMPORT=1 to .env and restart; the app starts with no data. Remove that line again as soon as the cause is fixed. It is a one-time troubleshooting switch, not a setting.
To rehearse the import without writing anything, add IMPORT_DRY_RUN=1, restart, read the per-table summary in the log, then remove the line and restart.
Because Postgres is empty but your old dev.db was already imported earlier, which means the database volume was lost, or DATABASE_URL now points at a different, empty database. JobSync stops instead of quietly restoring months-old data. Restore a backup with ./restore-db.sh <file>, or, to deliberately start again from the old SQLite data, delete jobsyncdb/data/dev.db.imported-at and restart on 1.2.0. This message comes from 1.2.0; on a newer release, deleting that file brings back the stop message instead of the import.
Run ./backup-db.sh, which writes a dated dump into jobsyncdb/data/backups/. On Windows run it from WSL or Git Bash; there is no PowerShell version yet. The database no longer lives in the jobsyncdb folder, so a folder-level backup on its own no longer covers it; the dump puts a copy back inside that folder. On Linux you may need sudo, and the script says so when it does. Restore with ./restore-db.sh <file>, which only loads into an empty database.
Copying Postgres's data directory while it is running is not a valid backup. The in-app Data Backup is still the way to move one account's data, but it leaves out accounts, API keys and MCP tokens, so it does not replace a dump. Take a dump before you ever delete dev.db.
In a Docker volume named jobsync_pgdata, under Docker's own storage, not in jobsyncdb/data/. If you placed jobsyncdb on a particular disk on purpose, the database is no longer on it; to keep it there, declare the pgdata volume as a bind mount. Uploaded resume files stay in jobsyncdb/data/ as before. The volume holds Postgres 18 data, so a future move to Postgres 19 is a dump and restore, not an image tag change.
Set DATABASE_URL in .env to your server's address; never edit docker-compose.yml. That alone switches the app and the backup scripts to your server. Also add BUNDLED_DB=0 to .env; without it an unused bundled database container still starts. Point DATABASE_URL at a dedicated, empty database. JobSync creates the database if it is missing and the role is allowed to; check the "created it" line on first start, because a typo in the name creates a new empty database rather than an error. Set CREATE_DATABASE_IF_MISSING=0 to make a missing database an error instead. When a start-up message tells you to empty the Postgres database, drop and recreate that database on your server; the docker volume rm command it shows applies to the bundled database only.
Checklist for your server:
- Postgres 17 or newer.
- A role that can log in and either owns the database or has
GRANT ALL ON SCHEMA public. - Managed providers usually need
?sslmode=require, and the direct endpoint rather than a pooled one. - JobSync treats
sslmode=requireas full certificate verification. With a private or self-signed certificate, use?uselibpqcompat=true&sslmode=require, or install the provider's CA. - From inside the container use
host.docker.internal, notlocalhost, for a Postgres on the same machine. - Percent-encode a password containing
@,:,/or#. - If your server is newer than Postgres 18, set
PG_DUMP_IMAGEin.envto its version, for examplepostgres:19, so backups work. - Upcoming: a future release uses the
pgvectorextension for resume embeddings. If you run your own Postgres, plan to have it available; the bundled database already includes it.