casfluid.blogg.se

Host all all xx.xx.xx.xx/xx scram-sha-256 Modify PostgreSQL /var/lib/pgsql/14/data/pg_hba.conf (host-based authentication) file: # Local networks Or if you want use specific ip, then use following: listen_addresses = '192.1.2.33' If you want just localhost setup, then use following: listen_addresses = 'localhost' Open /var/lib/pgsql/14/data/nf file, and add/uncomment/modify following: listen_addresses = '*' usr/pgsql-14/bin/postgresql-14-setup initdbĢ.2 Set PostgreSQL Server to Listen Addresses and Set Port

Configure PostgreSQL 14 2.1 Initialize Cluster with initdb Command # Fedora 35/34/33 and CentOS/RHEL/Rocky 8.5 # FedoraĪdd exclude to /etc//fedora.repo file section: Īdd exclude to /etc//fedora-updates.repo file section: ĭisable postgresql module: dnf -qy module disable postgresqlġ.3 Install PostgreSQL 14 Repository Fedora 35/34/33 # Fedora 35/34/33 #ĬentOS/RHEL/Rocky Linux 8 # CentOS/RHEL/Rocky Linux 8.5 - x86_64 - 64-bit #ġ.4 Install PostgreSQL 14 using DNF/YUM # Fedora 35/34/33 #ĭnf install -y postgresql14 postgresql14-serverĢ. Exclude PostgreSQL packages from the repository of the distro. This is important step to get PostgreSQL repository working properly. Install PostgreSQL 14 Database Server on Fedora 35/34/33, CentOS/Red Hat (RHEL)/Rocky Linux 8.5 1.1 Change root user su -ġ.2 Exclude Fedora, CentOS, Red Hat (RHEL) and Rocky Linux own PostgreSQL Packages Note: If you are upgrading PostgresSQL (from earlier version), then make sure that you backup (dump and copy) your database and configs.