Backup and Restoring Databases in Postgres

TL;DR 1. pg_dump -d my_database > my_backup_script.sql 2. rake db:create OR psql: CREATE DATABASE my_database_name 3. psql my_database_name < my_backup_script.sql Running into issues, or want to understand in more detail? Let’s dig in some more. Step 1: Backup Your Data Open up your favorite terminal. Make sure your database server is running (in Docker, in … More Backup and Restoring Databases in Postgres

The Samuel E. Wilson Volunteer of the Year Scholarship

(Last updated June 22nd, 2019) Applications are now closed. We are reviewing all entries in detail and will be replying to all applicants on June 30th. This scholarship is available to students who have made an impact to another person, a small group, or a community through self-sacrifice. This award celebrates the power of helping … More The Samuel E. Wilson Volunteer of the Year Scholarship

Upgrading Postgres in a Rails codebase

If you’re looking to upgrade Postgres locally in a Rails project, it’s straight-forward-yet-not-simple. It’s not a one-click/one-command operation. I used the pg_dump command, along with Homebrew in this example. I have also seen a good post from Christopher Brown and Keita on manually backing up and copying data files using pg_upgrade. These involve a few more steps … More Upgrading Postgres in a Rails codebase