Create a postgres database 07.01.25

After many Postgres setups, I repeated this steps to create a new Postgres cluster foo with a new Postgres database foo and with a new Postgres user foo and bar

```bash
pg_lsclusters
pg_createcluster 17 foo 
pg_ctlcluster 17 foo start
pg_lsclusters

su postgres -
psql -p5434

CREATE ROLE foo LOGIN PASSWORD 'MYPASSX';
CREATE ROLE bar WITH REPLICATION PASSWORD 'MYPASSX' LOGIN;
CREATE DATABASE foodb WITH OWNER = foo; 
GRANT ALL PRIVILEGES ON DATABASE foodb TO foo;
```

# example file /etc/postgresql/17/foo/pg_hba.conf
```apache2
local   all             postgres                                peer
local   all             all                                     md5
host    all             all             10.242.6.10/24          md5
host    all             all             135.181.43.244/24       md5
host    all             all             192.168.80.184/24       md5
local   all             all                                     peer
host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             ::1/128                 scram-sha-256
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256
host    replication     replicator      all                     md5

```

## in file /etc/postgresql/17/foo/postgresql.conf add line
```
listen_addresses = '*' 
```

https://www.geeksforgeeks.org/how-to-setup-a-postgresql-database-cluster/?ysclid=m5m5doe5kn960687486

Anonymous

Create a postgres database 07.01.25

Information Epoch 1757843193