![]() ![]() 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |