Difference between revisions of "Unode"
Jump to navigation
Jump to search
| Line 23: | Line 23: | ||
psql -h unode-server -U agent1 -d unode | psql -h unode-server -U agent1 -d unode | ||
``` | ``` | ||
| + | |||
| + | # Ref | ||
| + | - https://www.postgresql.org/docs/current/sql-createrole.html | ||
Revision as of 03:52, 22 December 2020
sudo -i -u postgres psql
CREATE ROLE agent1 WITH LOGIN PASSWORD 'agent1' VALID UNTIL '2205-01-01'
/etc/postgresql/12/main/postgresql.conf
listen_addresses = '*'
/etc/postgresql/12/main/pg_hba.conf host all all 10.1.1.x/32 md5
sudo systemctl restart postgresql
from 10.1.1.x/32
psql -h unode-server -U agent1 -d unode