PostgreSQL, also widely known as Postgres, is a powerful but open-source relational database management system. It is widely used for web applications, data warehousing, and…
View More How to Install Postgresql 14 on Ec2 Amazon linux 2
Tag: aws
Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime
When Amazon Aurora Serverless v1 came out, it was one of the most exciting new features of 2018. The ability to have a relational database without having…
View More Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime
Postgres — Live Table Partitioning
the partitioning of 1TB of data on a live system, with zero downtime Summary A few months ago we faced an engineering challenge of having…
View More Postgres — Live Table Partitioning
Connect to AWS EC2 postgres
If you can’t connect to aws ec2 instance: vi /var/lib/pgsql/12/data/postgresql.conf listen_addresses = ‘*’
View More Connect to AWS EC2 postgres
Enable root Access for Linux Instances
AWS doesn’t grant root access by default to EC2 instances. This is an important security best practise. Users are supposed to open a ssh connection…
View More Enable root Access for Linux Instances