Kamal 2 with PostgreSQL

Episode #478 by Teacher's Avatar David Kimura

Summary

In this episode, we expand on the previous episode by changing our database from Sqlite to PostgreSQL. We'll dive into some problems and some tricks to best handle the change. While we don't perform a data migration, we'll explore different ways to handle this.
rails deploy kamal postgresql 20:34

Chapters

  • Introduction (0:00)
  • Deploying to Digital Ocean (1:27)
  • Generating a scaffold (3:44)
  • Talking about migration (5:00)
  • Testing the deployment (6:36)
  • Changing to PostgreSQL (7:04)
  • Adding the accessory (7:52)
  • Setting the POSTGRES_PASSWORD secret (10:25)
  • Updating the database.yml (13:08)
  • Fixing typo (14:29)
  • Issue with Dockerfile (15:02)
  • Deploying the accessory (15:37)
  • Fixing the Dockerfile (16:33)
  • Testing with PostgreSQL (17:24)
  • Kamal aliases (17:40)
  • Talking about data migration (18:00)
Student & Teacher
$ 9 /mo

Valid School Email Required

Same Access as Pro

Subscribe Now
Pro Monthly
$ 19 /mo

Access to Pro Episodes

Invite to Slack Channel

Priority Suggestions

Ad Free

Subscribe Now
Pro Annual
Autumn Sale
$ 144 190 /yr

Access to Pro Episodes

Invite to Slack Channel

Priority Suggestions

Ad Free

Subscribe Now
Teams
$ 57 /mo

3 Users Minimum

$19.00 / user / month

Same Access as Pro

Subscribe to Teams