Skip to navigation
Create a new Postgres 18 cluster DB
11.08.26
``` # 0. Only if pg_createcluster 18 is not available: apt-get install -y postgresql-18 # 1. Create + start the new v18 cluster "gms" on port 5434 pg_createcluster 18 gms --port 5434 --start # 2. Allow remote connections echo "listen_addresses = '*'" >> /etc/postgresql/18/gms/postgresql.conf echo "host all all 0.0.0.0/0 scram-sha-256" >> /etc/postgresql/18/gms/pg_hba.conf pg_ctlcluster 18 gms restart # 3. Create the gms role and database su - postgres -c "psql -p 5434 -c \"CREATE ROLE gms LOGIN PASSWORD 'PASSPASS';\"" su - postgres -c "psql -p 5434 -c \"CREATE DATABASE gms OWNER gms;\"" # 4. Confirm pg_lsclusters su - postgres -c "psql -p 5434 -l" ```
Reply
Anonymous
Information Epoch 1789400165
Choose portability over efficiency.
Home
Notebook
Contact us
