Skip to content

Latest commit

 

History

History
43 lines (37 loc) · 1.02 KB

LOCAL_DEV.md

File metadata and controls

43 lines (37 loc) · 1.02 KB

Local development

Steps to install and configure Postgres on Mac for developing against locally

  1. Install homebrew

  2. Install postgres

    brew install postgresql

  3. Create a database

    createdb test

  4. Create SSL certificates

    cd /opt/homebrew/var/postgresql@14 openssl genrsa -aes128 2048 > server.key openssl rsa -in server.key -out server.key chmod 400 server.key openssl req -new -key server.key -days 365 -out server.crt -x509 cp server.crt root.crt

  5. Update config in /opt/homebrew/var/postgresql@14/postgresql.conf

    listen_addresses = '*' password_encryption = md5 ssl = on ssl_ca_file = 'root.crt' ssl_cert_file = 'server.crt' ssl_crl_file = '' ssl_crl_dir = '' ssl_key_file = 'server.key' ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers ssl_prefer_server_ciphers = on

  6. Start Postgres server

    /opt/homebrew/opt/postgresql@14/bin/postgres -D /opt/homebrew/var/postgresql@14
close