All Templates / CMS
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
The original project was created using npx create-payload-app
and used the blank template.
Following these instructions will have the application pointing to the hosted PostgreSQL database
yarn install
to install the needed dependenciesrailway 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 databaserailway run yarn payload migrate:create
yarn install
to install the needed dependencies.env
file with the DATABASE_URI
.env
file variablesyarn dev
will start up your application and reload on any changesrailway 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 databaseOpen 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
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
Directus (docker/websocket/extensions) + PostGIS (docker/TCP) + S3/Local
Directus (Docker) + PostGIS (Docker/TCP) + S3
Somi AI
156