PayloadCMS + Postgres
PayloadCMS v2 with PostgreSQL Database Service
Postgres
railwayapp-templates/postgres-ssl:latest
Just deployed
/var/lib/postgresql/data
payload-railway-postgres
aaronksaunders/payload-railway-postgres
Just deployed
Payload CMS v2 with PostgreSQL Database
The original project was created using npx create-payload-app
and used the blank template.
How to Use Locally with Remote PostgreSQL Database
Following these instructions will have the application pointing to the hosted PostgreSQL database
yarn install
to install the needed dependencies- Install and configure the Railway CLI
railway run yarn dev
will start up your application and reload on any changes. At this point changes in the schema will be automatically updated in the remote PostgreSQL database- to create migration before committing your code
railway run yarn payload migrate:create
How to Use Locally with Local PostgreSQL Database
yarn install
to install the needed dependencies- Create your own local Postgres Database and update the
.env
file with theDATABASE_URI
- Set the other
.env
file variables yarn dev
will start up your application and reload on any changes- Payload will update the database schema locally so you will need to run
railway run yarn payload migrate:create
before committing to GitHub so the schema changes get committed. The deployment script will run the appropriate migrate command to push changes to the database
PostgreSQL Information
How To Create a Local PostgreSQL Database
Open the terminal and run the command
sudo -u postgres psql
Create PostgreSQL Database
CREATE DATABASE myproject;
Create User
CREATE USER myprojectuser WITH PASSWORD 'password';
Update the .env
file variable DATABASE_URI
appropriately to point to the correct server
Template Content
payload-railway-postgres
aaronksaunders/payload-railway-postgresDATABASE_URI
URI to Postgres Database