sudo yum update -y<\/code><\/pre>\nStep 2:<\/strong> PostgreSQL is part of the amazon extras library. Install the PostgreSQL amazon extras repository. At the time of writing, PostgreSQL 14 is the latest package available in the extras library.<\/p>\nsudo amazon-linux-extras enable postgresql14<\/code><\/pre>\nStep 3: <\/strong>Install the PostgreSQL server.<\/p>\nsudo yum install postgresql-server -y<\/code><\/pre>\nStep 4:<\/strong> Initialize the DB.<\/p>\nsudo postgresql-setup initdb<\/code><\/pre>\nStep 5: <\/strong>Add the PostgreSQL service to the system startup.<\/p>\nsudo systemctl start postgresql\nsudo systemctl enable postgresql<\/code><\/pre>\nStep 6:<\/strong> Check the status of PostgreSQL using the following command.<\/p>\nsudo systemctl status postgresql<\/code><\/pre>\nSet Password For Postgres User<\/h2>\n
Now, let’s set a password for the default Postgres user and secure it.<\/p>\n
First login to the database using the following command.<\/p>\n
sudo -u postgres psql<\/code><\/pre>\nSet the password for the Postgres user so that we can use it to log in remotely. Replace myPassword<\/code> with the required password.<\/p>\nALTER USER postgres PASSWORD 'myPassword';<\/code><\/pre>\nEnable Remote Connection For PostgreSQL on Amazon Linux<\/h2>\n
By default the remote PostgreSQL connection is disabled. You need to add the following configuration to enable remote connectivity.<\/p>\n
Open the postgresql.conf<\/code> file in the vi editor<\/a>.<\/p>\nsudo vi \/var\/lib\/pgsql\/data\/postgresql.conf<\/code><\/pre>\nLocate the line that starts with “listen_addresses<\/strong>“. Uncomment and change it to “listen_addresses = ‘*’<\/strong>“. This will allow connections from any IP address.<\/p>\n![\"\"](\"https:\/\/storage.ghost.io\/c\/5f\/2f\/5f2f4d20-2abf-4534-8d40-7aa233aedd43\/content\/images\/2025\/03\/image-12-31.png\")
<\/figure>\nNext, open \/var\/lib\/pgsql\/data\/pg_hba.conf<\/code> file<\/p>\nsudo vi \/var\/lib\/pgsql\/data\/pg_hba.conf<\/code><\/pre>\nAdd the following to the end of the file to allow client connections to all databases.<\/p>\n
host all all 0.0.0.0\/0 md5<\/code><\/pre>\nTo apply all the changes, restart the PostgreSQL service using the following command.<\/p>\n
sudo systemctl restart postgresql<\/code><\/pre>\nNow, in the ec2 security group of the Amazon Linux ec2 server, allow incoming traffic on port 5432<\/strong>, which is the default port used by PostgreSQL<\/p>\nImportant PostgreSQL Server Configurations on Amazon Linux<\/h2>\n
The following table contains important PostgreSQL configurations on the Amazon Linux ec2 server.<\/p>\n
<\/p>\n