Run minimal development postgres locally (MacOS)

README.md

Local postgres

It is so easy to run locally, and you don't need a docker for that!

Installing & running

brew install postgresql
git clone https://gist.github.com/huksley/f74e422424c03d8e37e5dc04a20f64eb pg
cd pg
npm run pg

package.json

{
  "name": "pg",
  "version": "0.0.1",
  "description": "",
  "scripts": {
    "prepg": "if [ ! -d data/pg ]; then mkdir -p data/pg; initdb -D data/pg; fi",
    "pg": "trap 'kill 0' SIGINT; postgres -D data/pg --config-file=pg.conf"
  }
}

pg.conf

# Postgres minimal config
port = 5432
listen_addresses = 'localhost'
max_connections = 100
shared_buffers = 32MB
huge_pages = off
temp_buffers = 8MB
max_prepared_transactions = 0
work_mem = 512kB
maintenance_work_mem = 2MB
shared_memory_type = mmap
dynamic_shared_memory_type = posix
log_destination = 'stderr'
logging_collector = off
temp_file_limit = 1000
max_files_per_process = 256
wal_level = replica
fsync = on
synchronous_commit = on