Life with Open Source

pgAudit 1.2.2 (upcoming) commit log

Update copyright end year. commit : 96b86ae6fa5095b97d055e1271417c8221a7d1f4 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:11 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:11 -0400 Click here for diff M pgaudit.c

pgAudit 1.3.2 (upcoming) commit log

Update copyright end year. commit : 38e59beda8bd207a1f2a8da829f40258f5bb60b3 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:19:56 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:19:56 -0400 Click here for diff M pgaudit.c

pgAudit 1.0.7 commit log

Stamp 1.0.7. commit : 847d3bdbaba356a46d1408b2fe9105dd73d52cc7 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:25:52 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:25:52 -0400 Click here for diff M Makefile A pgaudit–1.0.6–1.0.7.sql R094 pgaudit–1.0.6.sql pgaudit–1.0.7.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 4a25265974287f45e987aa4e15bba17de651bef2 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:36:16 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.1.2 commit log

Stamp 1.1.2. commit : 527fa2114bf9fec12593c71e00ed30f314acaf3a author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:15:43 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:15:43 -0400 Click here for diff M Makefile A pgaudit–1.1.1–1.1.2.sql R094 pgaudit–1.1.1.sql pgaudit–1.1.2.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 5caff1395cf9070e70a1e85a7592d7010e4ff1e2 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:34:05 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.2.1 commit log

Stamp 1.2.1. commit : f56258e1cf0642e7df02bbd85535f2fb446bdd9f author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:06:58 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:06:58 -0400 Click here for diff M Makefile A pgaudit–1.2–1.2.1.sql R094 pgaudit–1.2.sql pgaudit–1.2.1.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 3a969f4fc1ae7d5e8e17002f43bb5872211ea14f author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:32:14 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.3.1 commit log

Stamp 1.3.1. commit : 4e2e968b364ebb6bb244784c5be39b0abd0bed7a author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:58:41 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:58:41 -0400 Click here for diff M Makefile A pgaudit–1.3–1.3.1.sql R094 pgaudit–1.3.sql pgaudit–1.3.1.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 1487811fe7bcf1f0212dc5462cfaa738feb85412 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:30:15 -0400 committer: David Steele <david@pgmasters.

pgBackRest 2.14 commit log

v2.14: Bug Fix and Improvements commit : 0f685a33a02adde45792711b957a75391fc5f34e author : David Steele <david@crunchydata.com> date : Mon, 20 May 2019 11:51:58 -0400 committer: David Steele <david@crunchydata.com> date : Mon, 20 May 2019 11:51:58 -0400 Click here for diff Bug Fixes: * Fix segfault when process-max > 8 for archive-push/archive-get. (Reported by Jens Wilke.) Improvements: * Bypass database checks when stanza-delete issued with force. (Contributed by Cynthia Shang. Suggested by hatifnatt.

PostgreSQL 9.4.22 commit log

Stamp 9.4.22. commit : 30b1e1ac4cea9ab32f2912e503589cda09e535aa author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:54:48 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:54:48 -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 : ffe69b4afdae8284ad3f0d4c57640f077799cfa9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 12:45:59 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.17 commit log

Stamp 9.5.17. commit : b221b78f83f5bc337b596170d70ab0a9d72a2951 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:52:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:52:44 -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 : 1760514e73e942dcb73231b6d65f6c2ef210c7da author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 12:45:59 -0400 committer: Tom Lane <tgl@sss.

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.