PayloadCMS + Postgres

PayloadCMS + Postgres

PayloadCMS v2 with PostgreSQL Database Service

Deploy PayloadCMS + Postgres

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

Deploy on Railway

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 the DATABASE_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

Deploy Now

Details

Aaron K Saunders's Projects

Created on Oct 9, 2023

103 total projects

25 active projects

50% success on recent deploys

TypeScript, Shell

CMS



More templates in this category

View Template
Strapi

Strapi

A popular self-hosted CMS


Milo's Projects

6.5K

Deploy
View Template
Directus (docker/websocket/extensions) + PostGIS (docker/TCP) + S3/Local

Directus (docker/websocket/extensions) + PostGIS (docker/TCP) + S3/Local

Directus (Docker) + PostGIS (Docker/TCP) + S3


Somi AI

View Template
Nitropage

Nitropage

A self-hosted visual website builder and CMS.


Lufrai's Projects