Slackbot
06/20/2023, 1:17 PMCorporate Gadfly
06/20/2023, 1:21 PMpg_hba.conf to invalid syntax.
1. install PostgreSQL 14 package after modifying yum repo
2. Initialize DB: /usr/pgsql-14/bin/initdb -D '/var/lib/pgsql/14/data'
3. Copy server.crt and server.key from ~/11/data
4. Copy *.conf from ~/11/data
5. modify data_directory, ssl_cert_file and ssl_key_file paths in postgresql.conf
6. modify clientcert=1 to clientcert=verify-full in pg_hba.conf
7. Upgrade database: /usr/pgsql-14/bin/pg_upgrade -d 11/data -D 14/data -b /usr/pgsql-11/bin -B /usr/pgsql-14/binbastelfreak
06/20/2023, 1:24 PMkenyon
06/20/2023, 7:02 PMCorporate Gadfly
07/06/2023, 3:42 PM