Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 7 Minuten 58 Sekunden

Florin Irion: Support for PostgreSQL’s System identifier in Barman

9. Januar 2020 - 10:51
The latest Barman 2.10 release introduces support for the system identifier of a PostgreSQL instance. In this article, I will answer a few questions explaining what a system identifier is and why it is a good thing that Barman uses it. What is the PostgreSQL system identifier? PostgreSQL gives a unique system identifier to every […]

Pavel Golub: PSQL_EDITOR: Fighting with Sublime Text under Windows

9. Januar 2020 - 10:00

This supposed to be just a short TIL entry about PSQL_EDITOR variable. While trying to figure out all possible pitfalls, I’ve decided to write a full blog post. You may skip to the summary though. All tests done on Windows 10 with PostgreSQL 12 installed.

Hubert 'depesz' Lubaczewski: Finally – fixed time calculations for parallel plans in

7. Januar 2020 - 17:36
For very long time plans with parallel execution showed bogus values. Not any more. For example, check this: Now, with new logic, the same plan looks like this: Note fixed times, and modified values in loops column. Hope you like it 🙂

Julien Rouhaud: pg qualstats 2: Global index advisor

6. Januar 2020 - 13:23

Coming up with good index suggestion can be a complex task. It requires knowledge of both application queries and database specificities. Over the year multiple projects tried to solve this problem, one of which being PoWA with the version 3, with the help of pg_qualstats extension. It can give pretty good index suggestion, but it requires to install and configure PoWA, while some users wanted to only have the global index advisor.

Mark Wong: Adventure in programming languages and simple statistics

3. Januar 2020 - 1:38
This is a story about how I found myself trying programming languages. I’ve been running an OLTP type database test (DBT-2, if you’ve heard of it), and noticed the post-processing reporting scripts for analyzing the database test results were running longer than I thought they would. I was running tests on 16 systems at the […]

Hans-Juergen Schoenig: PostgreSQL: You might need to increase max_locks_per_transaction

2. Januar 2020 - 10:00

“out of shared memory”: Some of you might have seen that error message in PostgreSQL already. But what does it really mean, and how can you prevent it? The problem is actually not as obscure as it might seem at first glance. max_locks_per_transaction is the critical configuration parameter you need to use to avoid trouble.

Venkata Nagothi: Cloud Vendor Deep-Dive: PostgreSQL on DigitalOcean

30. Dezember 2019 - 11:45

DigitalOcean is a cloud service provider, more of an IaaS (Infrastructure-as-a-Service) provider which is more suitable for small to medium scale businesses. You can get to know more about DigitalOcean here. What it does is a bit different to other cloud vendors like AWS or Azure and is not heavily global yet, take a look at this video which compares DigitalOcean with AWS. 

Abdul Yadi: Reinforce Data Validation: Prevent Direct Table Modification

26. Dezember 2019 - 13:16

Simple validation for tuple modification (insert/update/delete) is by applying constraints. More complex validation can be forced through trigger which is considered expensive by database experts.

The more efficient approach is by implementing validation in user defined function. Regular users are prevented from writing directly to table by issuing INSERT/UPDATE/DELETE. They must invoke provided function to perform those tasks.

Dimitri Fontaine: pgDay Paris 2019 presentation: How to write SQL queries?

25. Dezember 2019 - 22:15

The videos from pgDay Paris 2019 are online, and they look stunning! If you’ve been to the conference, you will be able to enjoy great memories, and if you’ve not been there, you can now enjoy all the fine content that was recorded there at the Youtube Channel for pgDay.Paris.

Michael Goldberg: Building pg_checksums utility for PostgreSQL 10 and earlier versions on CentOS 7

23. Dezember 2019 - 12:38
Post Views: 2 Since version 9.3 PostgreSQL introduced the ability of checksums. The documentation says "Use checksums on data pages to help detect corruption by the I/O system that would otherwise be silent". So, PostgreSQL's developers strongly recommended to use this mechanism for production systems....

Laurenz Albe: recovery.conf is gone in PostgreSQL v12

18. Dezember 2019 - 9:30

© Laurenz Albe 2019

The biggest change in PostgreSQL v12 from the viewpoint of backward compatibility is that recovery.conf has been absorbed into postgresql.conf.

This article describes the changes and how you can adapt to them.

Getting rid of recovery.conf

Up to now, the presence of the file recovery.conf was the trigger for PostgreSQL to go into recovery mode upon server start. In addition, the file contained all parameters to configure recovery, for example

Pavel Stehule: pspg themes - what you use it?

15. Dezember 2019 - 6:58
This year I finish more projects - pspg - there are watch mode, integrated readers from csv and tsv, and vertical cursor and sort on client side.

plpgsql_check can detect some basic sql injection problems and has integrated profiler now. Lot of bug was fixed. These tools works well and I am almost satisfied with their functionality.

Today some lighter topic. I did screenshot of any theme supported by pspg. What theme do you use, or what theme do you prefer?

Vadim Yatsenko: How we manage connection permissions from pgBouncer to PostgreSQL’s

13. Dezember 2019 - 9:33
Post Views: 9 Our company actively uses pgBouncer. We almost always recommend its use to our customers. This is a really cool connection pooling solution for PostgreSQL. In addition, pgBouncer allows as to flexibly manage connections for different PostgreSQL instances, helps to perform database maintenance...

Craig Healey: How to run Postgres on Docker part 3

11. Dezember 2019 - 15:34
In a previous post I deployed a PostgreSQL database in a container from a standard image. Now I’m going to look at deploying a PostgreSQL cluster. Well, kind of. PostgreSQL uses the term cluster to refer to “a collection of databases managed by a single PostgreSQL server instance”. I’m using it in the more general sense, to refer to High Availability.

Anna Bellandi: Barman 2.10 – Recovery of partial WAL files

11. Dezember 2019 - 15:21
Being a PostgreSQL database administrator and managing backups on a daily basis, one of the new features of Barman 2.10 that I liked the most is the transparent management of .partial WAL files during recovery. And, most likely, you feel the same if you have been using Barman with WAL streaming and have been asked […]

Hans-Juergen Schoenig: Setting PostgreSQL configuration parameters

11. Dezember 2019 - 9:00

A lot has been written about configuring postgresql.conf, and so on. However, sometimes it requires to take a second look in order to understand, how PostgreSQL really handles configuration parameters. You will notice that PostgreSQL configuration offers more than meets the eye at first glance. So let us dive into PostgreSQL GUCs and configuration on a more theoretical level!

Robert Treat: phpPgAdmin 7.12.1 released

10. Dezember 2019 - 21:31

I'm pleased to introduce the latest release of phpPgAdmin, version 7.12.1.

This release incorporates the following changes:

  • Fix a number of issues related to changes in Postgres 12.
  • Fix an issue with truncation of long multibyte strings
  • Removal of broken tree branches from table/view browse option
  • Properly escape identifiers when browsing tables/views/schemas
  • Add support for granting USAGE on sequences

Note this new version now requires support for the mbstring module in PHP.

Julien Rouhaud: PoWA 4: New powa-collector daemon

10. Dezember 2019 - 19:54

This article is part of the PoWA 4 beta series, and describes the new powa-collector daemon.

Hubert 'depesz' Lubaczewski: How to effectively dump PostgreSQL databases

10. Dezember 2019 - 19:40
Recently, on irc, there have been some talks with people using various pg_dump/pg_dumpall calls to get dumps of database. I voiced my ideas, but figured it could be good subject for a blog post. First things first – we have two tools available: pg_dumpall pg_dump pg_dumpall dumps all databases in given PostgreSQL installation (cluster), and … Continue reading "How to effectively dump PostgreSQL databases"

James Chanco: How to Perform a Major Version Upgrade Using pg_upgrade in PostgreSQL

9. Dezember 2019 - 16:27

Odds are you've been tasked with upgrading software from one major release to another at some point. Trust me, I understand how cumbersome and difficult these upgrades can be! Luckily, Crunchy Data has some tested methods to get you upgraded with the least amount of headache possible! For this use case, we’ll be using pg_upgrade. Let’s get started!