campoy

package main

import (
	"bufio"
	"fmt"
	"os"
	"time"
)

const numWorkers = 3

benallard

#!/usr/bin/env python

import os
import xml.parsers.expat
from xml.sax.saxutils import escape
from optparse import OptionParser
from math import log10


# How much data we process at a time

bryanrite

Originally taken from: Braintree Article and expanded on by me.

Safe

• Add a new column
• Drop a column
• Rename a column
• Add an index concurrently (Example), Note: it will still take a long time to run the migration, but it won't write-lock the table.
• Drop a constraint (for example, non-nullable)
• Add a default value to an existing column

jgillman

# Assumes the database container is named 'db'

DOCKER_DB_NAME="$(docker-compose ps -q db)"
DB_HOSTNAME=db
DB_USER=postgres
LOCAL_DUMP_PATH="path/to/local.dump"

docker-compose up -d db
docker exec -i "${DOCKER_DB_NAME}" pg_restore -C --clean --no-acl --no-owner -U "${DB_USER}" -d "${DB_HOSTNAME}" < "${LOCAL_DUMP_PATH}"
docker-compose stop db