# node-postgres-migrations

**Repository Path**: mirrors_dwyl/node-postgres-migrations

## Basic Information

- **Project Name**: node-postgres-migrations
- **Description**: Running migrations on node postgres 
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-08
- **Last Updated**: 2026-01-17

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# node-postgres-migrations
Running migrations on node postgres

### Step 1
Copy over the migrations folder, callMigrations.js and migrations.js over to your project

### Step 2
Add the sql migrations you would like to run to the migrations folder (1 migration per file).
**The file names should start with the date in the format yy-mm-dd** (this is to ensure the migrations are run in the correct order - from top to bottom)

### Step 3
Add the environment variable DATABASE_URL

### Step 4
Run `node callMigrations.js`

If you want this to run on Heroku deployment, then add to your postinstall command in your package.json (it's probably a good idea to do this after you've taken a db backup!)