Ghost not starting on Docker container due to missing 'pg' module, using official Ghost image

Hi,

I’m attempting to run Ghost 5.22.4 via Docker Compose using the official image from Docker Hub. Additionally, I’m attempting to use an external Postgres database. However the container refuses to stay running. When I check the logs for the container, this is the output.

Error ID:
    98e6ed30-5ef6-11ed-9f80-47b43f2c3f00
----------------------------------------
Error: Knex: run
$ npm install pg --save
$ npm install pg --save
Cannot find module 'pg'

Require stack:
- /var/lib/ghost/versions/5.22.4/node_modules/knex/lib/dialects/postgres/index.js
- /var/lib/ghost/versions/5.22.4/node_modules/knex/lib/dialects/index.js
- /var/lib/ghost/versions/5.22.4/node_modules/knex/lib/knex-builder/internal/config-resolver.js
- /var/lib/ghost/versions/5.22.4/node_modules/knex/lib/knex-builder/Knex.js
- /var/lib/ghost/versions/5.22.4/node_modules/knex/lib/index.js
- /var/lib/ghost/versions/5.22.4/node_modules/knex/knex.js
- /var/lib/ghost/versions/5.22.4/node_modules/knex-migrator/lib/database.js
- /var/lib/ghost/versions/5.22.4/node_modules/knex-migrator/lib/index.js
- /var/lib/ghost/versions/5.22.4/core/server/data/db/state-manager.js
- /var/lib/ghost/versions/5.22.4/core/boot.js
- /var/lib/ghost/versions/5.22.4/ghost.js
- /var/lib/ghost/versions/5.22.4/index.js
    at Client_PG.initializeDriver (/var/lib/ghost/versions/5.22.4/node_modules/knex/lib/client.js:194:13)
    at new Client (/var/lib/ghost/versions/5.22.4/node_modules/knex/lib/client.js:75:12)
    at new Client_PG (/var/lib/ghost/versions/5.22.4/node_modules/knex/lib/dialects/postgres/index.js:21:5)
    at knex (/var/lib/ghost/versions/5.22.4/node_modules/knex/lib/knex-builder/Knex.js:16:28)
    at Object.connect (/var/lib/ghost/versions/5.22.4/node_modules/knex-migrator/lib/database.js:36:12)
    at KnexMigrator.isDatabaseOK (/var/lib/ghost/versions/5.22.4/node_modules/knex-migrator/lib/index.js:566:32)
    at DatabaseStateManager.getState (/var/lib/ghost/versions/5.22.4/core/server/data/db/state-manager.js:40:37)
    at DatabaseStateManager.makeReady (/var/lib/ghost/versions/5.22.4/core/server/data/db/state-manager.js:73:36)
    at initDatabase (/var/lib/ghost/versions/5.22.4/core/boot.js:69:26)
    at bootGhost (/var/lib/ghost/versions/5.22.4/core/boot.js:443:15)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
[2022-11-07 23:47:53] WARN Ghost is shutting down
[2022-11-07 23:47:53] WARN Ghost has shut down
[2022-11-07 23:47:53] WARN Your site is now offline
[2022-11-07 23:47:53] WARN Ghost was running for a few seconds

Ghost hasn’t supported Postgres for several years