Open the /var/lib/pgsql/10/data/nf file in a text editor, and uncomment and configure the ssl = setting in the Connections and Authentication section as follows: Listen_addresses ='ccc_db' Enable PostgreSQL to Use SSLĬCC uses SSL to connect to the database. For example, if the hostname of the PostgreSQL server is ccc_db, set the listen address as follows: See Configuring CCC for more information. You specify this IP address or host name when you run the CCC configuration script.
#Postgresql install update
To configure the PostgreSQL listen addressġ.Open the /var/lib/pgsql/10/data/nf file in a text editor, and update the listen_addresses = setting in the Connections and Authentication section as follows: Refer to the PostgreSQL documentation for more information. 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. Systemctl restart postgresql-10 Configure the PostgreSQL Listen Address Using syslog is recommended.ġ.Open the /var/lib/pgsql/10/data/nf file in a text editor, and uncomment and configure the following lines in the Error Reporting and Logging section as indicated:Ģ.Open the /etc/nf file in a text editor, and add the following line:ģ.Enter the following command to restart the syslog or rsyslog service:Ĥ.Enter the following command to restart the PostgreSQL service: You can optionally configure PostgreSQL to send its logs to the syslog service. Port = 5432 Configure PostgreSQL to Use Syslog (optional) Then save the file and run the following command:ģ.Enter the following command to start the Postgresql service:Ĥ.Open the /var/lib/pgsql/10/data/nf file in a text editor and uncomment the following line: 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 section: Instructions for CentOS 8 and RHEL 8 users: usr/pgsql-10/bin/postgresql-10-setup initdbĢ.Enter 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.ġ.Enter the following command to initialize the PostgreSQL database:
#Postgresql install install
Yum install postgresql10-server Initialize the PostgreSQL Database and Start the PostgreSQL Service
#Postgresql install download
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.Ĥ.Enter the following command to install the RPM: ģ.Locate the correct PostgreSQL Yum Repository RPM for your operating system and copy its link location (URL). NOTEAs an example, all the following commands use PostgreSQL 10.ġ.Log in as root to the server you will use to host the CCC PostgreSQL database.Ģ.Open a web browser and access the url. Please skip steps (1-5) mentioned below if you have decided to install PostgreSQL Database during server installation. NOTEAs 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_server at IP address 123.45.67.8: 123.45.67.8 postgresql_serverģ.Save and close the file. To add the external database server to the CCC server hosts fileġ.Open the /etc/hosts file in a text editor.Ģ.Add an entry for the database server host.
To install PostgreSQL database on external server:ġ.Add the hostname/IP of the database server to the CCC server's /etc/hosts file.Ģ.Download and install the PostgreSQL RPM.Ĥ.Configure PostgreSQL to use syslog, if desired.ĥ.Configure the PostgreSQL listen address.ħ.Configure PostgreSQL to allow CCC to connect to the database.Ĩ.Create the CCC database and user. Installing PostgreSQL on an External Server
0 kommentar(er)
