Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 47 Minuten

Luca Ferrari: PostgreSQL 12 package on FreeBSD

4. November 2019 - 1:00

PostgreSQL 12 is available as binary package on FreeBSD, but not in the quarterly update.

Jobin Augustine: PostgreSQL Application Connection Failover Using HAProxy with xinetd

31. Oktober 2019 - 16:00

Recently we published a blog about a very simple application failover using libpq features which could be the simplest of all automatic application connection routing.  In this blog post, we are discussing how a proxy server using HAProxy can be used for connection routing which is a well-known technique with very wide deployment.

Kaarel Moppel: Upgrading Postgres major versions using Logical Replication

30. Oktober 2019 - 9:00

Some weeks ago, in the light of PostgreSQL v12 release, I wrote a general overview on various major version upgrade methods and benefits of upgrading in general – so if upgrading is a new thing for you I’d recommend to read that posting first. But this time I’m concentrating on the newest (available since v10) and the most complex upgrade method – called “Logical Replication” or LR shortly.

Luca Ferrari: Installing PostgreSQL on FreeBSD via Ansible

30. Oktober 2019 - 1:00

My very simple attempt at keeping PostgreSQL up-to-date on FreeBSD machines.

Installing PostgreSQL on FreeBSD via Ansible

I’m slowly moving to Ansible to manage my machines, and one problem I’m trying to solve at best is how to keep PostgreSQL up-to-date.
In the case of FreeBSD machines, pkgng is the module to use, but in the past I was used to this very simple playbook snippet:

Avinash Kumar: Monitoring PostgreSQL Databases Using PMM

29. Oktober 2019 - 19:16

PostgreSQL is a widely-used Open Source database and has been ranked # 1 for the past 2 years in DB-Engine rankings. As such, there is always a need for reliable and robust monitoring solutions. While there are some commercial monitoring tools, there is an equally good number of open source tools available for monitoring PostgreSQL.

Craig Kerstiens: Interesting Upcoming pgDays

29. Oktober 2019 - 15:50

I’ve been to a lot of conferences over the years. PgConf EU, PostgresOpen, too many pgDays to count, and even more none Postgres conferences (OSCON, Strangeloop, Railsconf, PyCon, LessConf, and many more). I’ve always found Postgres conferences one of the best places to get training and learn about what’s new with Postgres (in addition to Dimitri’s recent book, more on that below).

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – pgbench: add –partitions and –partition-method options.

28. Oktober 2019 - 10:56
On 3rd of October 2019, Amit Kapila committed patch: pgbench: add --partitions and --partition-method options.   These new options allow users to partition the pgbench_accounts table by specifying the number of partitions and partitioning method. The values allowed for partitioning method are range and hash.

Beena Emerson: Benchmark Partition Table - 1

27. Oktober 2019 - 20:02
With the addition of declarative partitioning in PostgreSQL 10, it only made sense to extend the existing pgbench benchmarking module to create partitioned tables. A recent commit of patch by Fabien Coelho in PostgreSQL 13 has made this possible. The pgbench_accounts table can now be partitioned with --partitions and --partition-method options which specify the number of partitions and the partitioning method accordingly when we initialize the database.

Pavel Stehule: watch mode for pspg

27. Oktober 2019 - 8:25
I released version 2.5.0 of pspg.

Jonathan Katz: Monitoring PostgreSQL Clusters in Kubernetes

26. Oktober 2019 - 15:56

The open source PostgreSQL Operator provides many features that are required to run a production database-as-a-service on Kubernetes, including provisioning PostgreSQL clusters, performing backup and restore operations, and manag

cary huang: Vancouver Postgres Group Meetup Event – Kubernetes Best Practices for Distributed SQL databases

26. Oktober 2019 - 2:32

Date: October 24, 2019

Guest Speaker: Andrew Nelson, Developer Advocate from YugaByte

About Vancouver Postgres User Meetup Group

Vancouver Postgres is a Postgres user meetup group based in Vancouver, Canada. It specializes in building Postgres users to the related ecosystem including but not limited to technologies such as RDS Postgres, Aurora for Postgres, Google Postgres, PostgreSQL.Org Postgres, Greenplum, Timescale and ZomboDB.

Luca Ferrari: pgenv: adjust your PATH!

25. Oktober 2019 - 2:00

A few days ago we added the option to suggest you changes to your PATH to prevent version clashes.

pgenv: adjust your PATH!

In the following you can find another quick video that demonstrate how easy it is to get, almost automtically, a PostgreSQL 12 instance up and running on your local machine using pgenv.

Regina Obe: PostgreSQL 12 64-bit for Windows FDWs

24. Oktober 2019 - 1:55

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

To use these, copy the files into your PostgreSQL 12 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

Avinash Kumar: Seamless Application Failover using libpq Features in PostgreSQL

23. Oktober 2019 - 18:58

When you build replication in PostgreSQL using Streaming replication, you cannot perform writes to a standby node; only reads. This way, you could offload reads or reporting queries to standby servers and send writes to master. Additionally, starting from PostgreSQL 10,

Michael Banck: pg_checksums 1.0 released

23. Oktober 2019 - 15:00
pg_checksums 1.0 released Version 1.0 of pg_checksums has been released. pg_checksums verifies, activates or deactivates data checksums in PostgreSQL instances. It is based on the pg_checksums utility in PostgreSQL 12, with the following additions: 1. Online verification of checksums The pg_checksums utility in PostgreSQL... 23-10 Michael Banck

Vik Fearing: pgDay Paris 2020 - Registration Open

23. Oktober 2019 - 10:00

Registration for pgDay Paris 2020 is now open.

We have some new ticket types this year, including a very cheap BLIND ticket that is only sold until the schedule is published. If you know you are coming to the conference no matter what, hurry up and grab one of these!

We also have cheap tickets this year for students and the unemployed. Valid proof is required.

https://2020.pgday.paris/registration/

Laurenz Albe: Never lose a PostgreSQL transaction with pg_receivewal

22. Oktober 2019 - 13:30


© Laurenz Albe 2019

 

“Durability”, the D of ACID, demands that a committed database transaction remains committed, no matter what. For normal outages like a power failure, this is guaranteed by the transaction log (WAL). However, if we want to guarantee durability even in the face of more catastrophic outages that destroy the WAL, we need more advanced methods.

This article discusses how to use pg_receivewal to maintain durability even under dire circumstances.

Vik Fearing: pgDay Paris 2020 - Call for Papers Open

22. Oktober 2019 - 10:00

The call for papers for pgDay Paris 2020 is now open. Submit your proposals for interesting talks about all things PostgreSQL, and join us in March!

https://2020.pgday.paris/callforpapers/

Lætitia AVROT: SSO on Postgres with Active Directory : troubleshooting

22. Oktober 2019 - 2:00
Single Sign On (SSO) is a great security feature because if users don’t have to create many accounts and manage several passwords, they will agree on using a complex password more easily (or at least, we hope they do). The thing is, most of the time, companies use Active Directory to manage their accounts but Postgres usually works on Linux… And even if these two worlds can work together, it’s difficult to find people that master both environments.

Pavel Stehule: dll for plpgsql_check 1.7 are available for PostgreSQL 10, 11, and 12

20. Oktober 2019 - 23:10
I prepared dll libraries. You can load it from url plpgsql_check-1.7.6-x64-win.zip.

Seiten