Skip to content

asapMaki/learning-railway-payload

Repository files navigation

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

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published