- #Install and configure postgresql install#
- #Install and configure postgresql update#
- #Install and configure postgresql download#
You specify this IP address or host name when you run the CCC configuration script. If you are using an external database (standalone or HA), use the IP address or host name of the network interface CCC will use to connect to the database.
#Install and configure postgresql update#
Update the listen_addresses = setting in the Connections and Authentication section. Open the /var/lib/pgsql/14/data/nf file in a text editor. To configure the PostgreSQL listen address: The listen_addresses setting controls which interfaces attempts to access the database, and should be configured such that connections are accepted only on the interfaces CCC uses to access the PostgreSQL database, to mitigate the risk of repeated malicious connection requests on insecure network interfaces. The listen_addresses setting specifies the TCP/IP address(es) of the IP interfaces that the PostgreSQL server listens on for connections from client applications. Open the /etc/nf file in a text editor, and add the following line:Įnter the following command to restart the syslog or rsyslog service: systemctl restart rvice.Įnter the following command to restart the PostgreSQL service: systemctl restart postgresql-14 Open the /var/lib/pgsql/14/data/nf file in a text editor, and uncomment and configure theįollowing lines in the Error Reporting and Logging section, as indicated: You can optionally configure PostgreSQL to send its logs to the syslog service.
Open the /var/lib/pgsql/14/data/nf file in a text editor and uncomment the following line:Ĭonfigure PostgreSQL to Use Syslog (optional) Then save the file and run the command systemctl daemon-reload.Įnter the following command to start the Postgresql service: If you are using RHEL 8, edit the service unit file of PostgreSQL from /usr/lib/systemd/system/rvice and make the following entry in the Unit section: After=network-online.target. usr/pgsql-14/bin/postgresql-14-setup initdbĮnter the following command to enable automatic startup of the PostgreSQL database: You must initialize and start the database server before you can configure it for use with CCC.Įnter the following command to initialize the PostgreSQL database: Initialize the PostgreSQL Database and Start the PostgreSQL Service
#Install and configure postgresql download#
If you are a RHEL 8 user, download PostgreSQL using the following link: If you are a CentOS 7 or RHEL 7 user, download PostgreSQL using the following link:
#Install and configure postgresql install#
If you are using RHEL 8, run the dnf -qy module disable postgresql &>/dev/null command.Įnter the following command to install the RPM: Locate the correct PostgreSQL Yum Repository RPM for your operating system and copy its link location (URL). Log in as root to the server you will use to host the CCC PostgreSQL database.
Skip steps 1 to 5 mentioned below, in case you have decided to install PostgreSQL Database during server installation.Īs an example, all the following commands use PostgreSQL 14. Skip steps 1 to 5 mentioned below, in case you wish to install PostgreSQL manually.Īs a CCC administrator, you can also install PostgreSQL during server installation. The PostgreSQL RPM is available for download from. For example, the following entry adds the host postgresql_ Open the /etc/hosts file in a text editor.Īdd an entry for the database server host. To add the database server to the CCC server hosts file In case you encounter an error, ensure that you are meeting all the requirements for To install PostgreSQL database manually on the same server or on an external server:Īdd the hostname/IP of the database server to the CCC server's /etc/hosts file.Ĭonfigure PostgreSQL to use syslog, if desired.ĬCC supports one-way SSL authentication for PostgreSQL databaseĬonfigure PostgreSQL to allow CCC to connect to the database.
0 kommentar(er)
