postgresql

Jump to bottom Edit New page

Ryan Culpepper edited this page Jun 4, 2019 · 3 revisions

PostgreSQL

Setting up a testing environment

Create user:

sudo su - postgres
createuser -s -P ryan

Edit /etc/postgresql/.../postgresql.conf:

add listen_addresses = '*'

Edit /etc/postgresql/.../pg_hba.conf:

add host all all 255.255.255.255/0 md5

Set up SCRAM authentication:

Reference: http://hacksoclock.blogspot.com/2018/10/how-to-set-up-scram-sha-256.html