Install PostgreSQL 13 on CentOS 8 / RHEL 8 / Oracle Linux 8īoth RHEL 8 and its derivatives include PostgreSQL 10 in their repositories. At the end of the post, you will have a PostgreSQL installation ready to start working. In addition, we’ll show you the most basic configurations. So, in this post, I will show you how to install PostgreSQL 13 on CentOS 8 / RHEL 8 / Oracle Linux 8. Despite easy installation, not always many users do. Its robustness, high availability, and ease of installation make it perhaps the most advanced in the world.

Now you should be able to connect to your db from outside.PostgreSQL is one of the most popular database management systems in the world. Likewise /var/lib/pgsql/data/pg_hba.conf (around line 88) add this line: host all all 0.0.0.0/0 md5 Psql -c 'ALTER USER postgres WITH PASSWORD 'your-super-secret-password' 'īecause I opened port 5432 on ec2 only to a set of ip addresses I make postgres to listen to any incoming address:Ĭhange /var/lib/pgsql/data/nf and put around line 59: listen_addresses = '*'

Set postgres database password: su - postgres Secure the linux postgres user: sudo passwd postgres Start it and tell linux to start it at boot time: sudo systemctl start postgresqlĬheck that postgres really started with sudo systemctl status postgresql for earthdistance): sudo yum install postgresql-contribĬreate the initial postgres database: sudo postgresql-setup initdb Some extensions you might want to have on top: To install it client+server: sudo yum install postgresql postgresql-server You can try with higher versions, if you mistakenly enabled a version you can also disable it with disable.

opened port 5432 (I strongly recommend to open it only to a set of ip addresses)īefore you can install postgres you need to “enable” it: sudo amazon-linux-extras enable postgresql13Īt the time of this blogpost version 13 was the highest one.have an amazon linux 2 instance (ec2 or lightsail).

Yum postgresql client