Difference between revisions of "Unode"
Jump to navigation
Jump to search
(Created page with "CREATE ROLE agent1 WITH LOGIN PASSWORD 'agent1' VALID UNTIL '2205-01-01'") |
|||
| Line 1: | Line 1: | ||
| + | ``` | ||
CREATE ROLE agent1 WITH LOGIN PASSWORD 'agent1' VALID UNTIL '2205-01-01' | 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 | ||
| + | ``` | ||
Revision as of 03:48, 22 December 2020
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