Sammlung von Newsfeeds

PostgreSQL Person of the Week Interview with Dave Cramer: I’m a Canadian currently hiding from winter in a warm southern state. As for hobbies: I started taking my car to the race track to see how well I understood physics. Turns out the theory and application are more interesting when you are the object in motion. I’ve been involved in PostgreSQL since around 2000. Through reading and answering many emails on the JDBC list I found myself contributing code to it and eventually maintaining it. I consider myself to be very fortunate to be able to make a living from PostgreSQL.

This post is part of several blog posts (at least two!) about Troubleshooting Postgres. Last time, we found out if Postgres was running and how to start it. Please find here all the troubleshooting posts < ref “/tags/troubleshooting/” >. Here is my checklist of troubleshooting Postgres: [] Try to start postgres (if this works, stop here) [] Locate the log file [] Look at the messages in Postgres logfile To start Postgres, please refer to < relref “content/post/troubleshooting-01.

As for now, there are no strict official restrictions in Ukraine. However, the trend seems to be evident, and the COVID-19 epidemic will be in an active phase until June-July, 2020.

Taking this into account, we are postponing the conference. We’d like to kindly remind you, we’re not canceling the PGDay Ukraine 2020, it’s moved to Fall 2020. All purchased tickets are valid. You are still our participants and guests.

pg_timetable: Advanced PostgreSQL cron-like scheduler released!

Hello there, this is your developer speaking…

This troubled times made me work harder than before to finish my ongoing missions and after that, I found myself somehow left with little to do and that’s kind of disturbing. So, why not take this time to write down that article born into my brain this morning while eating breakfast ? I’m on Postgres slack and Telegram group, more rarely on [IRC[(https://www.postgresql.org/community/irc/). I often see the same question, again and again : “Postgres doesn’t work, can you help me?

1. Overview

PostgreSQL supports many secure ways to authenticate users, and one typical way is to use GSSAPI with Kerberos. However, when I was trying to investigate one issue which is related with GSSAPI in PostgreSQL, I couldn’t find a tutorial that I can follow to setup the environment easily. After some effort spent on Kerberos environment setup, I decided to write a blog to share what I have learned.

Since PostgreSQL GSSAPI user authentication does involve many background knowledge, I separate this blog into 3 parts:

The state of Baden-Württemberg declared that in order to control the rapidly changing COVID-19 situation, all events over 100 participants are banned for at least until mid of June 2020. This affects the German PostgreSQL Conference 2020, which was planned for May 15th in Stuttgart.

check_pgbackrest is designed to monitor pgBackRest backups, relying on the status information given by the info command.

The changes in this new release are:

• missing archives output: the complete list is now only shown in --debug mode;
• new --list-archives argument to print the list of all the archived WAL segments found.

Missing archives

Let’s use the 1.7 release and see the basic output:

In my previous posting on tile serving, I demonstrated how pg_tileserv can publish spatial tables as dynamic vector tiles.

When designing a database application, the layout of data in disk is often neglected. However, the way data is stored by PostgreSQL can have a major performance impact. Therefore it makes sense to take a look at what can be done to improve speed and throughput. In this post you will learn one of the most important tricks.

PostgreSQL: To sort or not to sort

To demonstrate the importance of the on-disk layout I have created a simple test set:

This article parallels Oracle's copying of the SQL syntax from IBM in the late 1970's with Google's copying of the Java API. It also explains the possible impact of the current case soon to be decided by the US Supreme Court.

Ever since I released explain.depesz.com over 11 years ago there have been cases were people would upload a plan and it didn't parse. There were many reasons, but the most common was – plan was line-wrapped by injecting new-line characters where there shouldn't be one.

PostgreSQL Person of the Week Interview with Bruce Momjian: I live in Philadelphia and have worked on Postgres for 24 years. My heritage is Armenian.

This example will just be focusing on returning data from user defined functions, specifically returning a value as opposed to using OUT parameters.  The full code is on Github. To quickly review, PL/Julia calls jl_eval_string() to execute Julia code and captures the returning jl_value_t data structure, which contains the result of the Julia code executed.  […]

I was asked recently if PostgreSQL could authenticate login users against AWS Cognito.  Since PostgreSQL allows PAM authentication, I was pretty sure it could.

But an (admittedly not exhaustive) search on the web did not produce any PAMs for Cognito.

The title is not clickbait or hyperbole. I intend to prove that by virtue of both design and implementation that PostgreSQL is objectively and measurably a better database1 than anything currently available, with or without money considerations. How in the world can I claim and justify such a lofty statement? Read on, gentle nerd. I promise that your time will not be wasted.

Back in August 2019, I wrote multiple blogs with the title of “Horizontal scalability with Sharding in PostgreSQL – Where it is going Part 1 .. 3”. Little has happened since then, the purpose of this blog is discuss the important missing pieces of the puzzle, what are the minimum set of features needed to get to MVP (minimum viable product) and most importantly which efforts are currently going on to get to the MVP of Sharding in PostgreSQL core.

PostgreSQL 12 comes with a great new feature, Generated Columns. The functionality isn’t exactly anything new, but the standardization, ease of use, accessibility, and performance has been improved in this new version.

It is with heavy hearts that we have to announce that both Nordic PGDay 2020 (Helsinki, March 24th) and pgDay Paris 2020 (Paris, March 26th) have been canceled.

In light of the rapidly changing situation of the COVID-19 spread around Europe, and its effect on attendees, speakers, and sponsors ability and interest in safely attending, we feel at this point that this is the socially responsible thing to do.

There are no plans to postpone these events; we are instead focusing on returning next year, bigger and better than ever!

The organization team is closely following the recommendations of local, national, and international authorities. As of April 25, 2020 — in Ukraine — only assemblies of 200 people or more are restricted as well as events in contamination areas of which Lviv is not yet a part. However, the situation could change rapidly and we will update this page as needed. We also plan to keep attendees, speakers, and sponsors abreast of any significant changes.