Infrastructure at your Service

Category

Postgres

Franck Pachot

PostgreSQL on Linux: what is cached?

By | Postgres | No Comments

By Franck Pachot . In a recent tweet I wanted to highlight the importance of knowing what you measure with pgbench, because looking at “Transactions per second” without knowing if you are in shared buffer cache hits, or filesystem cache hit, or storage cache hit, or physical read… is just meaningless: When you run the #postgres builtin pgbench, you should know: – the size of the dataset on disk, about 15MB x scale – the…

Read More
Karsten Lenz

Microsoft Flexible Server for PostgreSQL

By | Postgres | No Comments

This Blog is about some findings on Microsoft’s new Flexible Server offering for PostgreSQL which is in Customer Preview at the moment. Findings about the infrastructure The Microsoft Flexible Server for PostgreSQL is using Ubuntu as OS infrastructure, I think it is worth to be noticed that Microsoft’s new offering is switching from Windows to Linux. postgres=> select version(); version —————————————————————————————————————– PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609, 64-bit Ubuntu upgrade…

Read More
Mouhamadou Diaw

PostgreSQL High Availability: Patroni, Ectd , HAProxy , Keepalived

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

Patroni is one the most famous tool that can be used to setup a high avalaibilty for PostgreSQL. In this blog I am describing a test I did. Below the environment we will use The etcd cluster will contains 3 servers etcd-server1: 192.168.56.100 etcd-server2: 192.168.56.101 etcd-server3: 192.168.56.106 HAProxy and Keepalived will be configured in this 2 servers. haproxy-server1: 192.168.56.102 haproxy-server2: 192.168.56.103 A VIP will be configured haproxyvip 192.168.56.108 We have 2 databases servers pgserver1: 192.168.56.104…

Read More
Franck Pachot

Google Cloud SQL Insights: ASH, plans and statement tagging

By | Cloud, Postgres | No Comments

By Franck Pachot . Looking at database performance has always been necessary to optimize the response time or throughput, but when it comes to public cloud where you are charged by resource usage, performance tuning is critical for cost optimization. When looking at host metrics, you see only the symptoms and blindly guess at some solutions: add more vCPU if CPU usage is high, more memory if I/O wait is high. And this can be…

Read More
Franck Pachot

Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

By | Cloud, Postgres | No Comments

By Franck Pachot . In a previous post I started this series of “Recovery in the ☁” with the Oracle Autonomous database. My goal is to explain the recovery procedures, especially the Point-In-Time recovery procedures because there is often confusion, which I tried to clarify in What is a database backup (back to the basics). And the terms used in managed cloud services or documentation is not very clear, not always the same, and sometimes…

Read More
Nabil Saoual

Control-M/EM Update jobs using Pgadmin tool

By | Database Administration & Monitoring, Postgres | No Comments

introduction Hi team, Today we will work on Control-M database,we already know how to update it using CLI and also using Control-M GUI,but today we will use a reall nice tool named PgAdmin. Its a GUI where you can connect your controlm postgres database and perform administartions tasks.It’s a freeware and quite complete,so don’t hesitate to test it 🙂 We will see how to update jobs using this tool,but probably on next blogs we will…

Read More
Franck Pachot

PostgreSQL in AWS: clearing the doubts

By | AWS, Postgres | No Comments

By Franck Pachot . I’ve heard and read people saying that the PostgreSQL managed service is not the true open-source PostgreSQL from the community. This is wrong and I’m writing this post to clarify it. PostgreSQL on EC2 Obviously, you can install PostgreSQL on an EC2 instance, as a database running on IaaS (Infrastructure as a Service). You have the full choice of version, you can even compile it from sources, and add whatever extensions…

Read More
Franck Pachot

What is a database backup (back to the basics)

By | Database Administration & Monitoring, Postgres | 11 Comments

By Franck Pachot . TL;DR: do not consider a dump (like PostgreSQL pg_dump or Oracle expdp) as a database backup do not consider that your backup is successful if you didn’t test recovery databases provide physical database backups, easy and safe to restore and recover to any point-in-time between first backup and point of failure managed databases provide an easy recovery interface, but don’t trust it before you try it and… I’ve written this after…

Read More
Burgert Daniel

Increase your PostgreSQL databases security by checking a few settings Part 2

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

Continuing from my first blog we will check some more access and authentication configurations. Focusing on removing unnecessary database privileges. After that we will configure the backend parameters correctly to have more robust PostgreSQL server/client sessions. And at last SSL encryption for these sessions will be configured.

Read More
Furkan Suv

Starting with PostgreSQL

By | Database management, Postgres | No Comments

In this Post you will learn how I met PostgreSQL and started to learn. If you are planning PostgreSQL as your database but don’t know where to start, this blog may help you. My background I have used MySQL database like an external hard drive, just to save and store the data from an application. Several times I installed on CentOS/Ubuntu from the repository. Mostly I used preinstalled MySQL databases from webhosting providers. On the…

Read More