Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 13 Minuten

Michael Banck: Debian-Integration of Patroni and vip-manager

30. Januar 2020 - 9:31
Debian-Integration of Patroni and vip-manager Patroni is a clustering solution for PostgreSQL that is getting more and more popular in the cloud and Kubernetes sector due to its operator pattern and integration with Etcd or Consul. Some time ago we wrote a blog post about the integration of Patroni into Debian. Recently, the vip-manager... 30-01 Michael Banck

Luca Ferrari: Checking catalogues for corruption with pg_catcheck

30. Januar 2020 - 1:00
Unable to clean HTML

Richard Yen: The Most Neglected Postgres Feature

29. Januar 2020 - 22:00

I recently did some work with a customer who had some strange behavior happening in his database. When I asked for his logs, I found that each line had a message, and just one timestamp prefixed to it. In other words, he had log_line_prefix = '%t '. This made it hard for me to figure out who did what, especially as his database was serving many clients and applications. It got me thinking, and I scoured through our other clients’ postgresql.conf files that had been shared with me over the years, and in ~130 conf files, I found the following:

Peter Eisentraut: Developing PostgreSQL for Windows, Part 1

29. Januar 2020 - 12:07
As a PostgreSQL developer, I occasionally need to make my code work on Windows. As I don’t normally use Windows and don’t have a permanent Windows installation around, this has always been a bit cumbersome. I have developed a few techniques to make this easier, and I figure they are worth sharing. And actually this […]

Hubert 'depesz' Lubaczewski: Which tables should be auto vacuumed or auto analyzed?

29. Januar 2020 - 3:01
Recently I was in a situation where autovacuum couldn't keep up with changes. To solve the problem I finally decided to manually vacuum analyze all tables (manual vacuum/analyze is faster than one ran by autovacuum daemon). But it irritated me that I didn't have ready way to check which tables are waiting for autovacuum to … Continue reading "Which tables should be auto vacuumed or auto analyzed?"

Hubert 'depesz' Lubaczewski: Don’t do these things in PostgreSQL

28. Januar 2020 - 21:17
In 2018 Lluad created wiki page with couple of rules about what not to do. Since then there have been 30 changes, done by nine more people. Based on some conversation on irc I figured I can write a tool to automatically check these rules. Or at least – most of them. Currently wiki lists … Continue reading "Don’t do these things in PostgreSQL"

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – Add functions gcd() and lcm() for integer and numeric types.

28. Januar 2020 - 13:46
On 25th of January 2020, Dean Rasheed committed patch: Add functions gcd() and lcm() for integer and numeric types.   These compute the greatest common divisor and least common multiple of a pair of numbers using the Euclidean algorithm.   Vik Fearing, reviewed by Fabien Coelho.

Jonathan Katz: Scheduled PostgreSQL Backups and Retention Policies with Kubernetes

28. Januar 2020 - 12:35

It is important (understatement) that you take regularly scheduled backups of your PostgreSQL system as well as manage how many backups you have, which is known as "backup retention." These best practices ensure that you always have a recent backup of your database system to recover from in the event of a disaster (or use to

Hans-Juergen Schoenig: pg_timetable: Advanced PostgreSQL scheduling

28. Januar 2020 - 9:30

pg_timetable is a brand-new job scheduler for PostgreSQL implemented completely from scratch (in Go). Traditional job scheduling is quite limited and does not cover all we needed in real life. Therefore, we thought about job execution in more detail and came up with a new concept that has not been seen in the PostgreSQL world before. pg_timetable does not simply execute some simple SQL statements periodically.

Hamid Akhtar: Understanding Prepared Transactions and Handling the Orphans

28. Januar 2020 - 7:49

Prepared transactions are a key feature of PostgreSQL. Understanding what this feature offer and handling any potential pitfalls is critical to maintaining a system that is reliable. So let’s take a dive into what prepared transactions are all about. 

Jonathan Battiato: Barman Cloud – Part 1: WAL Archive

27. Januar 2020 - 14:53
Preamble How many current Barman users have thought about saving backups in a remote destination in the cloud? How many have thought about taking that backup directly from the PostgreSQL server itself? Well, since Barman 2.10 this is now possible! How? Let’s discover that together in the following articles. Requirements The following two articles are […]

Daniel Vérité: Multiple strings replacement with plperl

27. Januar 2020 - 12:05

Substituting a single string by another within a larger string is straightforward in SQL, with the replace function:

select replace('the string is bar', 'bar', 'foo'); replace ------------------- the string is foo

But there isn’t a PostgreSQL core function to substitute multiple strings each by its own independent replacement, like for instance the strtr function in PHP, or the substitutions operators with regular expressions in Python or Perl (which we’re going to use in this post).

Hubert 'depesz' Lubaczewski: Nothing compares ….

27. Januar 2020 - 8:18
Warsaw PostgreSQL Users Group (facebook , meetup) uploaded a song to youtube: Nothing Compares To VACUUM 🙂

Dan Langille: Caching clearing issue

26. Januar 2020 - 20:36
FreshPorts had a cache clearing issue recently. It lingered. For a long time. It took me a while to figure it out. It turned out to be a Python 3 compatibility issue. In this post: PostgreSQL 12.1 FreeBSD 12.1 I will outline how database changes invoke external scripts asynchronously which then clear the cache. I [...]

Jorge Solorzano: CONF: PostgreSQL configuration for humans

24. Januar 2020 - 13:36
What is PostgresqlCO.NF?

PostgresqlCO.NF (CONF for short) is your postgresql.conf documentation and ultimate recommendations’ source. Our mission is to help you tune and optimize all of your PostgreSQL configuration. With around 290 configuration parameters in postgresql.conf (and counting), it is definitely a difficult task! We aim to make PostgreSQL configuration accessible for HUMANS.

Sadequl Hussain: How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1

24. Januar 2020 - 8:00
repmgr is an open-source toolset from 2ndQuadrant, a leading specialist in PostgreSQL-related technologies and services. The product is used to automate, enhance, and manage PostgreSQL streaming replication. Streaming replication in PostgreSQL has been around since version 9.0. Natively setting up and managing streaming replication involves a number of manual steps which includes: Configuring replication parameters […]

Robert Haas: Contributors Team, Redux

23. Januar 2020 - 17:04
Last summer, in a burst of sunny optimism and out of a desire for transparency, I posted a blog post about the then-new PostgreSQL Contributors Team, which was charged with updating the contributors page as required.

Yorvi Arias: Migrating from Oracle to PostgreSQL: Tips and Tricks

23. Januar 2020 - 15:59

Migrating to PostgreSQL from Oracle is a topic that often comes up in discussions around PostgreSQL.  At Crunchy Data, we are of course not surprised that there is broad interest in moving to the world's most advanced database.

cary huang: Understanding Security Features in PostgreSQL – Part 3

22. Januar 2020 - 21:48
1. Introduction

This is part 3 of the blog “Understanding Security Features in PostgreSQL”, in which I will be discussing how to apply TLS in both PostgreSQL server and client using the principles we have learned in part 2 of the blog. In the end, I will also briefly talk about Transparent Data Encryption (TDE) and security vulnerability.

Here is the overview of the security topics that will be covered in all parts of the blog:

Part 1:

cary huang: Understanding Security Features in PostgreSQL – Part 2

22. Januar 2020 - 21:26
1. Introduction

This is part 2 of the blog “Understanding Security Features in PostgreSQL”, in which I will be discussing TLS in greater details. I will begin by going over some of the most important security concepts around TLS before jumping into enabling TLS on PostgreSQL server. I believe it is crucial to have sufficient background information on TLS before tweaking the TLS settings in both client and server sides.