Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 26 Minuten 10 Sekunden

Robert Haas: pg_basebackup could not set compression worker count - unsupported parameter

4. November 2022 - 13:31
PostgreSQL 15 hasn't been released for very long, but some people have already been confused by the following error message:
pg_basebackup: error: could not initiate base backup: ERROR: could not set compression worker count to 4: Unsupported parameter Read more »

Charly Batista: PostgreSQL: Are All NULLs the Same?

4. November 2022 - 13:07

I was recently reading the PostgreSQL 15 release notes and stopped at “Allow unique constraints and indexes to treat NULL values as not distinct”. At first glance, it seems to be a minor change, but this feature may change many designs and make many lives a lot easier.

Ryan Lambert: Backups for Postgres - PGSQL Phriday #002

4. November 2022 - 6:01

This blog post is for PGSQL Phriday #002. Read Ryan Booz' introduction from September for more details on PGSQL Phriday. Andreas Scherbaum is this month's host and chose the topic: Postgres backups!

The topic reposted here:

Lætitia AVROT: How to do proper backups

4. November 2022 - 1:00
This week, PGSQL Phriday #2 is focused on backups, thanks to Andreas Scherbaum’s blog post. It is not a secret that I’m all in favor of using pgbackrest. I think that it is today the best backup tool for PostgreSQL. It does not mean others are bad, it means they are less good. If you feel the need to have a way to restore your data, I guess you’d rather use the best tool to achieve that goal.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conf

3. November 2022 - 20:02
On 24th of October 2022, Michael Paquier committed patch: Add support for regexps on database and user entries in pg_hba.conf   As of this commit, any database or user entry beginning with a slash (/) is considered as a regular expression. This is particularly useful for users, as now there is no clean way to … Continue reading "Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conf"

Paul Ramsey: Postgres Insider Terminology

3. November 2022 - 16:00

Last week Craig Kerstiens published a great introduction to Postgres terminology, covering some of the basics you might run into when just getting started.

The funny thing about jargon is how quickly we get used to it, and forget we are even using it. It becomes part of the secret handshake, the way we signal to other members of our tribe that we're part of the group.

Pavel Stehule: orafce 4.0.0

2. November 2022 - 18:15

Today I released orafce 4.0.0

The big change is merging orafce_sql project - so now directly in orafce is possible to use dbms_sql package.

Second change is code cleaning - support for PostgreSQL 9.6 and 10 was removed.

Kai Wagner: First PostgreSQL Conference Ever: What You’ve Missed at PGConf.EU 2022

2. November 2022 - 13:21

I just became part of the PostgreSQL ecosystem and was really curious to get in touch with the community. What are the best ways to interact with a community? Mailing lists for sure, forums, chat channels, or if possible an in-person conference. So I checked the events site of PostgreSQL and found an event nearby — PGConf.EU in Berlin. After reaching out internally, I was told this is one of the biggest or even the biggest PostgreSQL conferences in the world.

Frits Hoogland: YugabyteDB in-database visible object sizes

2. November 2022 - 12:55

The PostgreSQL database has a number of very useful functions to calculate the size of the objects on disk. Examples of such functions are pg_table_size(), pg_indexes_size(), pg_tablespace_size(), etc, but also the ysqlsh/psql utility \d[tibm]+ commands to show the sizes of objects.

In YugabyteDB starting from version, YugabyteDB YSQL added the functionality to show the object sizes too.

Hans-Juergen Schoenig: btree vs. BRIN: 2 options for indexing in PostgreSQL data warehouses

2. November 2022 - 11:00

Indexing is the key to good performance. However, people often ask: Is there an alternative to btree indexing? Can we make indexes in PostgreSQL smaller? Can we create indexes in PostgreSQL faster? And how can we index in a data warehouse?

Elizabeth Garrett Christensen: Data Loading in Postgres for Newbies

1. November 2022 - 16:00

So you’re new to Postgres and you want to test it out and see how it works. Or maybe you’re building a new app and you need to seed your database. How do you get data in your Postgres database? There’s a lot out there on the topic of data migration for Postgres and some of it can be complicated and overwhelming. I’m going to give you some quick and simple ways to get test data IN your database.

Jobin Augustine: Securing Patroni REST API End Points – Part 1

1. November 2022 - 12:54

In recent years, Patroni emerged as the number one HA framework for PostgreSQL, currently with 5K stars in its git repository. We blogged about how some of the extraordinary capabilities of Patroni to solve problems like Logical Replication Slot Failover.

Andreas 'ads' Scherbaum: PGConf.EU 2022 - Conference Wrap-up

1. November 2022 - 10:23

PostgreSQL Conference 2022 is over - and it was a success!

3 days of talks, and one day of training. In total we had 604 registrations, and a long wait list because the conference unexpectedly sold out a month ahead of time. In the end, 599 people picked up their badge.

Frits Hoogland: The new YugabyteDB gflags page

31. Oktober 2022 - 15:15

Starting with YugabyteDB version, the gflags (server parameters) page shows the values grouped into a number of categories.

Andreas 'ads' Scherbaum: Adrien Nayrat

31. Oktober 2022 - 15:00
PostgreSQL Person of the Week Interview with Adrien Nayrat: I live in Valence (in France not Spain), I am 36.

Andreas Scherbaum: PGSQL Phriday #002: PostgreSQL Backup and Restore

31. Oktober 2022 - 14:59

Thanks to Ryan Booz we now have the #PGSQLPhriday blogging series. The second edition is about backups. And of course also about restore.

Backups? Do you need that?

If your data is not important, you certainly don't need to bother about backups. Then again, why do you even store the data in the first place?

Jimmy Angelakos: PGConf.EU 2022 Berlin - PostgreSQL Community Panel: Upgradability

30. Oktober 2022 - 16:55

A few days ago we tried out a new talk format at PGConf.EU 2022 in Berlin in the form of a community panel discussing a topic and we chose the subject of PostgreSQL upgrades.

The feedback we received was great, and I'm looking forward to trying out different subjects in a panel format at future Postgres conferences.

I was fortunate enough to be joined by some great fellow Postgres community members:

Regina Obe: PostgreSQL 15 64-bit for Windows FDWs

29. Oktober 2022 - 4:44

We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 15 Windows 64-bit.

To use these, copy the files into your PostgreSQL 15 Windows 64-bit install folders in same named folders and then run CREATE EXTENSION as usual in the databases of your choice. More details in the packaged README.txt

Continue reading "PostgreSQL 15 64-bit for Windows FDWs"

cary huang: Cross-partition Uniqueness Guarantee with Global Unique Index

29. Oktober 2022 - 0:26
1.0 Introduction

My colleague, David, recently published a post “Global Index, a different approach” that describes the work that we are doing to implement global unique index in an approach that does not change current PostgreSQL’s partitioning framework, while allowing cross-partition uniqueness constraint.

Craig Kerstiens: Postgres Databases and Schemas

27. Oktober 2022 - 17:00

In my career I've worked on teams that ran and managed over a million databases, and I've helped shard and scale database for customers at 100s of terabytes.