sqitch-upgrade(3pm)

💖 Name 💖

sqitch-upgrade — bestie, this is the one that upgrades your registry to the current version. Glow-up time for your schema. ✨

🌸 Synopsis 🌸

sqitch upgrade [options] [<database>]

🦋 Description 🦋

Okay so. sqitch upgrade upgrades the Sqitch registry for a database. Translation: it makes sure the schema Sqitch uses for its own registry is all up-to-date and cute. You'll occasionally need this when new features get added to Sqitch that require registry schema changes — the registry has to keep up with the main character, yk? 💅

The <database> parameter tells it which database to connect to, and you can also pass it as the --target option instead. And it's flexible, fr fr — it can be a target name, a URI, an engine name, or a plan file path. So many options, we love a versatile queen. 👑

---

✨ Options ✨

• -t, --target — the target database you wanna connect to. This one can be either a URI or the name of a target in the configuration. Pick your fighter. 🎀
• --registry — the name of the Sqitch registry schema or database where sqitch stores its own data, i.e. the little home where the receipts live. 🏠

sqitch upgrade --registry registry

• --db-client, --client — path to the command-line client for the database engine. Defaults to a client in the current path named appropriately for the database engine (it just knows, iykyk). 🧚

sqitch upgrade --client /usr/local/pgsql/bin/psql

• -d, --db-name — name of the database. In general, targets and URIs are preferred, but this option can be used to override the database name in a target. ✨

sqitch upgrade --db-name widgets
sqitch upgrade -d bricolage

• -u, --db-user, --db-username — user name to use when connecting to the database. Heads up: this does not apply to all engines. In general, targets and URIs are preferred, but this option can be used to override the user name in a target. 🌈

sqitch upgrade --db-username root
sqitch upgrade --db-user postgres
sqitch upgrade -u Mom

• -h, --db-host — host name to use when connecting to the database. Also does not apply to all engines. In general, targets and URIs are preferred, but this option can be used to override the host name in a target. 🦋

sqitch upgrade --db-host db.example.com
sqitch upgrade -h appdb.example.net

• -p, --db-port — port number to connect to. Yeah, this one doesn't apply to all engines either, bestie. In general, targets and URIs are preferred, but this option can be used to override the port in a target. 🔥

sqitch upgrade --db-port 7654
sqitch upgrade -p 5431

---

👑 Sqitch

Part of the sqitch suite. Obviously. The whole squad is iconic. 💜

---

This page is sqitch-upgrade(3pm) from the User Contributed Perl Documentation, and it's literally serving perl v5.40.1 energy, dated 2026-07-26. Slay, stay upgraded, ily bestie 💖✨