Replace 15 with the version of PostgreSQL you are using. The following table contains important PostgreSQL configurations on the Redhat server. Psql: error: connection to server at '34.221.35.108', port 5432 failed: FATAL: password authentication failed for user 'postgres' Important PostgreSQL Server Configurations on Redhat If you don’t have a password set for the Postgres user, you will get the following error. When prompted for the password, use the password you set using the ALTER command.

Now, validate the remote connection by connecting to the PostgreSQL server using the following command. Restart the PostgreSQL server to apply changes. With this configuration, we are enabling PostgreSQL server connections to accept connections from all IP addresses. Replace it with the following and save the file. 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.

Yum install postgresql 10