PostgreSQL 12 on CentOS 8ĭisable the built-in PostgreSQL module: sudo dnf -qy module disable postgresql
With the YUM repository added, we can install PostgreSQL 12 on CentOS 7/8 with the following command. Step 2: Install PostgreSQL 12 on CentOS 8 / CentOS 7 This package contains yum configuration for Red Hat Enterprise Linux, CentOSĪnd Scientific Linux. Summary : PostgreSQL PGDG RPMs- Yum Repository Configuration for Red Hat / CentOS / Scientific Linux Vendor : PostgreSQL Global Development Group You can get more information on installed package by running the command: $ rpm -qi pgdg-redhat-repo It can be added to CentOS system by running the command below: The PostgreSQL Yum Repository will integrate with your normal systems and patch management, and provide automatic updates for all supported versions of PostgreSQL throughout the support lifetime of PostgreSQL. Step 1: Add PostgreSQL Yum Repository to CentOS 7 / CentOS 8 In the next article, I discuss how to Backup and restore PostgreSQL databases with Ansible using a database dump.Use the steps below to install PostgreSQL 12 on CentOS 8 / CentOS 7. We have seen how to install and configure a PostgreSQL database with a database user, and how to run an initial SQL migration (or any other SQL script). Service : name=postgresql state=restarted name : "Find out if PostgreSQL is initialized" Let's now create the Ansible playbook! First, we need to install the database itself, along with psycopg2-binary Python library that will allow us to use Ansible PostgreSQL modules postgresql_db, postgresql_user, postgresql_privs and postgresql_pg_hba. Just create ansible.cfg and hosts.ini files with the proper connection information, or modify the playbook itself. The playbook expects that we configure the target machines using an inventory file. When needed, use Ansible Vault or environment variables when running the playbook.
Note that storing passwords in plain text is not the best idea.
0 kommentar(er)
