Life with Open Source

PostgreSQL 9.6.13 commit log

Stamp 9.6.13. commit : d22ca701a39dfd03cdfa1ca238370d34f4bc4ac4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:50:49 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:50:49 -0400 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : a70f2e4cdfb5a8a05ab178037ba39cf3ac190246 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 12:45:59 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.8 commit log

Stamp 10.8. commit : 441190289892c4ae870d0781175aa8edd0ec528e author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:48:45 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:48:45 -0400 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : 585e8ffd195d868f23318caaed6fd586f8d56a0e author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 12:45:59 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.3 commit log

Stamp 11.3. commit : 0616aed243b23e68b5c06ceb3df3e4ec35e731b7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:46:18 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:46:18 -0400 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : 02814c381bbae9d23b19042fe356c000ae31d975 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 12:45:59 -0400 committer: Tom Lane <tgl@sss.

RedHat Summit 2019

See you all at RedHat Summit 2019 in Boston, MA. Please visit Crunchy Data booth to talk about our Enterprise Support and Products offering: Crunchy Certified PostgreSQL Crunchy HA PostgreSQL Crunchy PostgreSQL for OpenShift Enterprise PostgreSQL Support Enterprise PostgreSQL Consulting

pgBackRest 2.13 commit log

v2.13: Bug Fixes commit : 41f3874822faf3f859f46867c0fe965f7156b123 author : David Steele <david@pgmasters.net> date : Thu, 18 Apr 2019 21:26:02 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 18 Apr 2019 21:26:02 -0400 Click here for diff Bug Fixes: * Fix zero-length reads causing problems for IO filters that did not expect them. (Reported by brunre01, jwpit, Tomasz Kontusz, guruguruguru.) * Fix reliability of error reporting from local/remote processes. * Fix Posix/CIFS error messages reporting the wrong filename on write/sync/close.

pgBackRest 2.12 commit log

v2.12: C Implementation of Archive Push commit : 4e57b689165cffd8c686f0f36d0c5dccb553b3e1 author : David Steele <david@pgmasters.net> date : Thu, 11 Apr 2019 09:14:22 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 11 Apr 2019 09:14:22 -0400 Click here for diff IMPORTANT NOTE: The new TLS/SSL implementation forbids dots in S3 bucket names per RFC-2818. This security fix is required for compliant hostname verification. Bug Fixes: * Fix issues when a path option is / terminated.

PostgreSQL - Zero to Hero (part 2)

PostgreSQL - Running Multiple Instances Running PostgreSQL 11 and PostgreSQL 10, or any combination of major versions, on a single system is easy when using RPM packages such as the ones provided at PostgreSQL YUM reposiotry. PGDG rpms make it easy to run multiple version of PostgreSQL on a single system. Install one more PGDG versions, setup, enable services using steps shared in previous blog. This guide will help you get started with installing and configuring multiple PostgreSQL 11 clusters on a CentOS / RHEL 7 based system, which will also work for Fedora 27, 28, 29.

pgBackRest 2.11 commit log

v2.11: C Implementation of Archive Get commit : 68d20edea6cbfc7b8b6db69633e08ac473821547 author : David Steele <david@pgmasters.net> date : Sun, 10 Mar 2019 18:56:00 +0200 committer: David Steele <david@pgmasters.net> date : Sun, 10 Mar 2019 18:56:00 +0200 Click here for diff Bug Fixes: * Fix possible truncated WAL segments when an error occurs mid-write. (Reported by blogh.) * Fix info command missing WAL min/max when stanza specified. (Fixed by Stefan Fercot.) * Fix non-compliant JSON for options passed from C to Perl.

PostgreSQL - Zero to Hero (part 1)

PostgreSQL - Installing and Creating cluster One of the most important things to using PostgreSQL successfully in your development and production environments is simply getting started! One of the most popular ways to install PostgreSQL is by using RPM packages. The PostgreSQL RPM packages work across many Linux distributions, including, RedHat Enterprise Linux (RHEL), CentOS, Fedora, Scientific Linux, and more, and the PostgreSQL community provides installers for these distributions.

PostgreSQL 9.4.21 commit log

Stamp 9.4.21. commit : 4bf9119adf599dccccb7b1ad073606d0f28617d6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:24:38 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:24:38 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Translation updates commit : 968ffb09f24f02e3001a4a9e27c561eb8adb5e4b author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 Feb 2019 14:10:14 +0100 committer: Peter Eisentraut <peter@eisentraut.

PostgreSQL 9.5.16 commit log

Stamp 9.5.16. commit : 394ef2397dd47ffa0fb2c1f51e19a2c8e51bec4d author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:22:57 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:22:57 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Translation updates commit : d64d05827e5fed5e7bba5b1f659a6f3720298db2 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 Feb 2019 14:15:25 +0100 committer: Peter Eisentraut <peter@eisentraut.

PostgreSQL 9.6.12 commit log

Stamp 9.6.12. commit : 9848bd725e3b021bbe53e606ac9c261079ee82ba author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:21:19 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:21:19 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Translation updates commit : 248fd6cb3a9d01348be0fef12f370c453dba8a77 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 Feb 2019 14:21:55 +0100 committer: Peter Eisentraut <peter@eisentraut.

PostgreSQL 10.7 commit log

Stamp 10.7. commit : a093e1444955d6ee1d7cfda68932c19d5613d87a author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:19:36 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:19:36 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Translation updates commit : ff3ac5903d1f45f3267c45683b0883758e24ead8 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 Feb 2019 14:25:01 +0100 committer: Peter Eisentraut <peter@eisentraut.

PostgreSQL 11.2 commit log

Stamp 11.2. commit : 6cd404b344f7e27f4d64555bb133f18a758fe851 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:17:27 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 16:17:27 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : 6c9356080c2060bcd4a6cef520aa3d8121940ee7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Feb 2019 12:05:49 -0500 committer: Tom Lane <tgl@sss.

pgBackRest 2.10 commit log

v2.10: Bug Fixes commit : 35903b94d9f2de14fb116c4b15649466eff78ef2 author : David Steele <david@pgmasters.net> date : Sat, 9 Feb 2019 19:52:31 +0200 committer: David Steele <david@pgmasters.net> date : Sat, 9 Feb 2019 19:52:31 +0200 Click here for diff Bug Fixes: * Add unimplemented S3 driver method required for archive-get. (Reported by mibiio.) * Fix check for improperly configured pg-path. (Reported by James Chanco Jr.) M README.md M doc/resource/exe.cache M doc/xml/release.xml

pgBackRest 2.9 commit log

v2.09: Minor Improvements and Bug Fixes commit : a89a3761191444ef28b22434f94bc42fd84b83ee author : David Steele <david@pgmasters.net> date : Wed, 30 Jan 2019 22:37:35 +0200 committer: David Steele <david@pgmasters.net> date : Wed, 30 Jan 2019 22:37:35 +0200 Click here for diff Bug Fixes: * Fix issue with multiple async status files causing a hard error. (Reported by Vidhya Gurumoorthi, Joe Ayers, Douglas J Hunley.) Improvements: * The info command is implemented entirely in C.

pgBackRest 2.8 commit log

v2.08: Minor Improvements and Bug Fixes commit : db24ff8df4b2c2de133461df3ab4f28167516dbf author : David Steele <david@pgmasters.net> date : Wed, 2 Jan 2019 22:04:47 +0200 committer: David Steele <david@pgmasters.net> date : Wed, 2 Jan 2019 22:04:47 +0200 Click here for diff Bug Fixes: * Remove request for S3 object info directly after putting it. (Reported by Matt Kunkel.) * Correct archive-get-queue-max to be size type. (Reported by Ronan Dunklau.) * Add error message when current user uid/gid does not map to a name.

pgBackRest 2.7 commit log

v2.07: Automatic Backup Checksum Delta commit : 04d9e4d5a88512707c350e3885e359d53c3ca36b author : David Steele <david@pgmasters.net> date : Fri, 16 Nov 2018 09:50:50 -0500 committer: David Steele <david@pgmasters.net> date : Fri, 16 Nov 2018 09:50:50 -0500 Click here for diff Bug Fixes: * Fix issue with archive-push-queue-max not being honored on connection error. (Reported by Lardière Sébastien.) * Fix static WAL segment size used to determine if archive-push-queue-max has been exceeded. * Fix error after log file open failure when processing should continue.

PostgreSQL 11.1 commit log

Last-minute updates for release notes. commit : d06fe6ce2c79420fd19ac89ace81b66579f08493 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 6 Nov 2018 18:56:26 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 6 Nov 2018 18:56:26 -0500 Click here for diff Add entries for v11 changes that went in post-stamping, but before the final wrap. M doc/src/sgml/release-11.sgml Disable recheck_on_update optimization to avoid crashes. commit : 05f84605dbeb9cf8279a157234b24bbb706c5256 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 6 Nov 2018 18:33:15 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.3.25 commit log

Stamp 9.3.25. commit : c10bb239d29017ba66eca88a24b84a1d4db36a6c author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:53:28 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:53:28 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Translation updates commit : 1394a48db9db1dcc4a02739b228cebf54c4827f2 author : Peter Eisentraut <peter_e@gmx.net> date : Mon, 5 Nov 2018 15:13:49 +0100 committer: Peter Eisentraut <peter_e@gmx.

PostgreSQL 9.4.20 commit log

Stamp 9.4.20. commit : 4f0bf3359faee12317808634024627a824d658f5 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:51:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:51:23 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Fix copy-paste error in errhint() introduced in 691d79a07933. commit : b7301e3a7b6362d550727deffb0ebd06363efdba author : Andres Freund <andres@anarazel.de> date : Mon, 5 Nov 2018 12:02:25 -0800 committer: Andres Freund <andres@anarazel.

PostgreSQL 9.5.15 commit log

Stamp 9.5.15. commit : 0b09804544cb51e0d90c874f62a1d600ca9321d6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:49:29 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:49:29 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Fix copy-paste error in errhint() introduced in 691d79a07933. commit : a0e450e91ee9b6a79c55b5a5265147e789996549 author : Andres Freund <andres@anarazel.de> date : Mon, 5 Nov 2018 12:02:25 -0800 committer: Andres Freund <andres@anarazel.

PostgreSQL 9.6.11 commit log

Stamp 9.6.11. commit : 518d5492911d445b126e9d5c669a83b5cae43e50 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:47:37 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:47:37 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Fix copy-paste error in errhint() introduced in 691d79a07933. commit : a16e8b440132d0418d7d0c8986ac944b2370a1d4 author : Andres Freund <andres@anarazel.de> date : Mon, 5 Nov 2018 12:02:25 -0800 committer: Andres Freund <andres@anarazel.

PostgreSQL 10.6 commit log

Stamp 10.6. commit : c63d9ebb5940bf3d24a6ecdc300ca9e95e29ddbe author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:45:50 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:45:50 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : bce0ff4080eba1f7175db832227bfde84db3af31 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Nov 2018 16:07:06 -0500 committer: Tom Lane <tgl@sss.

pgBackRest 2.6 commit log

v2.06: Checksum Delta Backup and PostgreSQL 11 Support commit : 904550c97f674d3f576d3113756f2b5c89b55ddf author : David Steele <david@pgmasters.net> date : Tue, 16 Oct 2018 14:56:51 +0100 committer: David Steele <david@pgmasters.net> date : Tue, 16 Oct 2018 14:56:51 +0100 Click here for diff Bug Fixes: * Fix missing missing URI encoding in S3 driver. (Reported by Dan Farrell.) * Fix incorrect error message for duplicate options in configuration files. (Reported by Jesper St John.