Spin up local postgres

postgres.ps1

# Assumes postgres binaries in .postgres subfolder
# http://get.enterprisedb.com/postgresql/postgresql-9.4.1-3-windows-x64-binaries.zip

$targetPath = $PSScriptRoot + "\.postgres\"
$env:Path = $targetPath + "pgsql\bin;" + $env:Path
$env:PGDATA = $targetPath + "data"
$env:PGDATABASE = "postgres"
$env:PGUSER = "postgres"
$env:PGPORT = "1338"
$env:PGLOCALEDIR = $targetPath + "pgsql\share\locale"

New-Item -Path $targetPath -Name "data" -ItemType "directory"

#Init postgres & new database
.\.postgres\pgsql\bin\initdb -U postgres -A trust

Start-Process .\.postgres\pgsql\bin\pg_ctl -ArgumentList "-D",($targetPath +  "data"),"-w","-l",".postgres\logfile","start" -PassThru -NoNewWindow
Write-Host "Waiting for PostgreSQL..."
sleep -Seconds 5

# Make sure db_create.sql contains all necessary statements (CREATE DATABASE etc)
.\.postgres\pgsql\bin\psql.exe -f "db_create.sql"