POSTGRES

1.	Install minimal Ubuntu Server with SSHD

2.	Instal PostgreSQL

	# apt install postgresql

3.	Edit /etc/postgresql/*/main/postgresql.conf

	Change to: listen_addresses = '*'

4.	Change 'postgres' password

	# sudo -u postgres psql template1

	template1=# ALTER USER postgres with encrypted password 'your_password';

5.	Edit /etc/postgresql/*/main/pg_hba.conf, change to

	hostssl template1       postgres        [your network gateway]/24        scram-sha-256


6.	Use /Library/PostgreSQL/17/bin/psql

	$ /Library/PostgreSQL/17/bin/psql --host 10.42.0.254 --username postgres --password --dbname template1

References

[1]	https://ubuntu.com/server/docs/install-and-configure-postgresql

[2]	

	https://www.enterprisedb.com/downloads/postgres-postgresql-downloads