Unode - Revision history

Busk at 04:48, 22 December 2020

2020-12-22T04:48:29Z

2020-12-22T04:05:43Z

2020-12-22T03:55:36Z

2020-12-22T03:52:10Z

2020-12-22T03:49:50Z

2020-12-22T03:48:33Z

2020-12-22T03:39:38Z

Created page with "CREATE ROLE agent1 WITH LOGIN PASSWORD 'agent1' VALID UNTIL '2205-01-01'"

New page

CREATE ROLE agent1 WITH LOGIN PASSWORD 'agent1' VALID UNTIL '2205-01-01'

@@ Line 34: / Line 34: @@
 insert into agents (id, alias) VALUES (DEFAULT, 'jtest');
 GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO www;
 ```

@@ Line 27: / Line 27: @@
 ```
 GRANT SELECT ON agents to agent1;
 ```
 # Ref
 - https://www.postgresql.org/docs/current/sql-createrole.html

@@ Line 22: / Line 22: @@
 ```
 psql -h unode-server -U agent1 -d unode
 ```
 # Ref
 - https://www.postgresql.org/docs/current/sql-createrole.html

← Older revision		Revision as of 03:52, 22 December 2020
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

← Older revision		Revision as of 03:49, 22 December 2020
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'

← Older revision		Revision as of 03:48, 22 December 2020
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
		+	```