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-10 Open the /var/lib/pgsql/10/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/10/data/nf file in a text editor and uncomment the following line: port = 5432Ĭ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: systemctl start postgresql-10 If you are using CentOS 8 or 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. Instructions for CentOS 8 and RHEL 8 users 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: /usr/pgsql-10/bin/postgresql-10-setup initdbĮnter the following command to enable automatic startup of the PostgreSQL database: systemctl enable rvice Initialize the PostgreSQL Database and Start the PostgreSQL Service If you are a CentOS 8 or 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. If you are using CentOS 8 or 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 10. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |