Difference between revisions of "Unode"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | sudo -i -u postgres psql | ||
``` | ``` | ||
CREATE ROLE agent1 WITH LOGIN PASSWORD 'agent1' VALID UNTIL '2205-01-01' | CREATE ROLE agent1 WITH LOGIN PASSWORD 'agent1' VALID UNTIL '2205-01-01' | ||
Revision as of 03:49, 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