Infrastructure at your Service

Tag

PostgreSQL Archives - Page 2 of 33 - Blog dbi services

Franck Pachot

Some myths about PostgreSQL vs. Oracle

By | Oracle, Postgres | One Comment

By Franck Pachot . I originally wrote this as a comment on the following post that you may find on internet: https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-reasons-to-migrate/ but my comment was not published (many links in it… I suppose it has been flagged as spam?) so I put it there. You should never take any decision on what you read on the internet without verifying. It is totally valid to consider a move to Open Source databases, but doing it…

Read More
Joël Cattin

pgBackRest – a simple privileges-related issue

By | Database Administration & Monitoring, Database management, Postgres | No Comments

I recently had to replace Barman by pgBackRest as Backup & Recovery solution for one of my customer. The purpose of this blog is not to show how I made the setup (some dbi blogs already exists for that), but only to share a small issue I encountered during the creation of the Stanza : [email protected]:/ [cms2] pgbackrest –stanza=cms2_primary stanza-create ERROR: [058]: version ’11’ and path ‘(null)’ queried from cluster do not match version ’11’…

Read More
Franck Pachot

AWS Aurora vs. RDS PostgreSQL on frequent commits

By | AWS, Postgres | No Comments

This post is the second part of https://blog.dbi-services.com/aws-aurora-xactsync-batch-commit/ where I’ve run row-by-row inserts on AWS Aurora with different size of intermediate commit. Without surprise the commit-each-row anti-pattern has a negative effect on performance. And I mentioned that this is even worse in Aurora where the session process sends directly the WAL to the network storage and waits, at commit, that it is acknowledged by at least 4 out of the 6 replicas. An Aurora specific…

Read More
Franck Pachot

AWS Aurora IO:XactSync is not a PostgreSQL wait event

By | AWS, Postgres | No Comments

By Franck Pachot . In AWS RDS you can run two flavors of the PostgreSQL managed service: the real PostgreSQL engine, compiled from the community sources, and running on EBS storage mounted by the database EC2 instance, and the Aurora which is proprietary and AWS Cloud only, where the upper layer has been taken from the community PostgreSQL. The storage layer in Aurora is completely different. In PostgreSQL, as in most RDBMS except for exclusive…

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 4 – Changing parameters

By | AWS, Database Administration & Monitoring | No Comments

If you followed that last posts about DB Parameter Groups, Subnet Groups and Setting up the RDS instance you should have a running RDS instance. You should also be aware that changing parameters can not be done like you usually do it but you need to do that by changing the DB parameter groups. In this post we’ll look at how you can do that and, especially, what you should avoid.

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 3 – Creating the RDS PostgreSQL instance

By | AWS, Database Administration & Monitoring | No Comments

In the last tow posts we had a look at DB Parameter Groups and Subnet Groups as these need to be ready when you want to deploy a RDS PostgreSQL instance on AWS. In this post we’ll use these two building blocks to bring up a high available PostgreSQL instance using a master instance in one, and a replica in another availability zone. This is usually what you want when you want a production deployment…

Read More
Daniel Westermann

PostgreSQL 13: Backup validation and backup manifests

By | Database Administration & Monitoring | No Comments

Currently a lot of stuff is being committed for PostgreSQL and what we will look at in this post is a feature, I am sure, a lot of PostgreSQL users have been waiting for for a long time: Finally there is a native way to validate your base backups: pg_validatebackup. This is a new binary that can be used to validate base backups against a backup manifest, that is written automatically when you do backup…

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 2 – Subnet groups

By | AWS, Database Administration & Monitoring | No Comments

In the last post we had a look at DB Parameter Groups when it comes to AWS RDS for PostgreSQL. This is one of the first things you should think about. But even before you think about PostgreSQL parameters you need to configure the networks your database instances shall be running in. In real life this is done by one of your network administrators and you will not have much to configure in this area….

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 1 – DB Parameter Groups

By | AWS, Database Administration & Monitoring | No Comments

When your go for AWS RDS you can very quickly bring up a database instance and start using it. I’ve written about my thoughts using this approach here and really encourage you to learn about a specific service in more detail before you start using it. If you want to have a managed service for PostgreSQL in AWS, you can go for AWS RDS for PostgreSQL and this service will be the topic for this…

Read More