Under CONNECTIONS AND AUTHENTICATION section you will find the following commented parameter. To enable PostgreSQL remote connection on Redhat, you need to open the following file. ALTER USER postgres PASSWORD 'myPassword' Replace myPassword with the required password. Set the password for the Postgres user so that we can use it to log in remotely. Is the server running on that host and accepting TCP/IP connections?įirst login to the database using the following command. psql: error: connection to server at "34.221.35.108", port 5432 failed: Connection refused If you try to connect from a remote machine you will get an error like the following. However, you can connect to the database locally. Sudo systemctl start postgresql-15 Enable PostgreSQL Remote Connectionīy default the remote PostgreSQL connection is disabled. sudo /usr/pgsql-15/bin/postgresql-15-setup initdb Step 3: Initialize the Database and Enable Automatic StartĮxecute the following commands to initialize the PostgreSQL database and add services to the server startup. You can check the latest version available for Rehat on this page.
The latest version at the time of writing this guide is PostgreSQL 15. Step 2: Install the latest version of the PostgreSQL Server Install PostgreSQL on Redhat Linuxįollow the steps given below to install the latest version of PostgreSQL on RedHat LinuxĮxecute the following command to add the PostgreSQL yum repo. It covers installation, configuration, and enabling remote connection.
If you want to install PostgreSQL on Redhat Linux, this guide is for you.
0 kommentar(er)
