The following table contains important PostgreSQL configurations on the Amazon Linux ec2 server. Now, in the ec2 security group of the Amazon Linux ec2 server, allow incoming traffic on port 5432, which is the default port used by PostgreSQL Important PostgreSQL Server Configurations on Amazon Linux To apply all the changes, restart the PostgreSQL service using the following command. Next, open /var/lib/pgsql/data/pg_hba.conf file sudo vi /var/lib/pgsql/data/pg_hba.confĪdd the following to the end of the file to allow client connections to all databases. This will allow connections from any IP address. Uncomment and change it to “ listen_addresses = ‘*’“. Locate the line that starts with “ listen_addresses“.
ALTER USER postgres PASSWORD 'myPassword' Enable Remote Connection For PostgreSQL on Amazon Linuxīy default the remote PostgreSQL connection is disabled. You need to add the following configuration to enable remote connectivity. Replace myPassword with the required password. Set the password for the Postgres user so that we can use it to log in remotely. Now, let’s set a password for the default Postgres user and secure it.įirst login to the database using the following command. sudo systemctl status postgresql Set Password For Postgres User Step 6: Check the status of PostgreSQL using the following command. Step 5: Add the PostgreSQL service to the system startup. sudo amazon-linux-extras enable postgresql14 At the time of writing, PostgreSQL 14 is the latest package available in the extras library.
YUM UPDATE POSTGRESQL TO SPECIFIC VERSION INSTALL
Install the PostgreSQL amazon extras repository. Step 2: PostgreSQL is part of the amazon extras library. Step 1: Let’s upgrade the system Yum packages. Install PostgreSQL on Amazon Linuxįollow the steps given below to install the latest version of PostgreSQL on RedHat Linux It covers installation, configuration, and enabling remote connection. If you want to install PostgreSQL on Amazon Linux (AWS ec2), this guide is for you.
0 kommentar(er)
