Stamp 9.3.14.
commit : 757f567ec8d6d4767e74cf987a5cc63e63f1c9dc
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 16:31:43 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 16:31:43 -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 : 43957e873d22ce5d279a91d3acda6fc9e848fda7
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 11:56:10 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 11:56:10 -0400
Click here for diff
Stamp 9.4.9.
commit : 860f8fb1aa4ee01259bac8fa4e1c4da9570ac1b7
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 16:29:39 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 16:29:39 -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 : cf21e6f7e9448b9f0964e9864f570ade9d672496
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 11:56:10 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 11:56:10 -0400
Click here for diff
Stamp 9.5.4.
commit : eb4dfa239e6f54fef5c486caf4b58a9805c19572
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 16:27:53 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 16:27:53 -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 : 2183966c6d00a16cc307f8563da469b14ed07b6f
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 11:56:10 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Aug 2016 11:56:10 -0400
Click here for diff
v1.04: Various Bug Fixes
commit : 277934447b0f4602260978ecb12d2e3d580632df
author : David Steele <david@pgmasters.net>
date : Sat, 30 Jul 2016 09:42:35 -0400
committer: David Steele <david@pgmasters.net>
date : Sat, 30 Jul 2016 09:42:35 -0400
Click here for diff
Bug Fixes:
* Fixed an issue an where an extraneous remote was created causing threaded backup/restore to possibly timeout and/or throw a lock conflict. (Reported by Michael Vitale.)
* Fixed an issue where db-path was not required for the check command so an assert was raised when it was missing rather than a polite error message. (Reported by Michael Vitale.)
* Fixed check command to throw an error when database version/id does not match that of the archive. (Fixed by Cynthia Shang.)
* Fixed an issue where a remote could try to start its own remote when the backup-host option was not present in pgbackrest.conf on the database server. (Reported by Lardière Sébastien.)
* Fixed an issue where the contents of pg_xlog were being backed up if the directory was symlinked. This didn't cause any issues during restore but was a waste of space.
* Fixed an invalid log() call in lock routines.
Features:
* Experimental support for non-exclusive backups in PostgreSQL 9.6 beta3. Changes to the control/catalog/WAL versions in subsequent betas may break compatibility but pgBackRest will be updated with each release to keep pace.
Refactoring:
* Enhancements to the protocol layer for improved reliability and error handling.
* All remote types now take locks. The exceptions date to when the test harness and pgBackRest were running in the same VM and no longer apply.
* Exceptions are now passed back from threads as messages when possible rather than raised directly.
* Temp files created during backup are now placed in the same directory as the target file.
* Output lock file name when a lock cannot be acquired to aid in debugging.
* Reduce calls to protocolGet() in backup/restore.
* Suppress banners on SSH protocol connections.
* Improved remote error messages to identify the host where the error was raised.
M README.md
M doc/release.pl
M doc/resource/exe.cache
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
v1.03: Check Command and Bug Fixes
commit : 1b62354dcb6cd815fc8a5b235b0aaf52eb85a692
author : David Steele <david@pgmasters.net>
date : Sat, 2 Jul 2016 10:22:52 -0400
committer: David Steele <david@pgmasters.net>
date : Sat, 2 Jul 2016 10:22:52 -0400
Click here for diff
Bug Fixes:
* Fixed an issue where keep-alives could be starved out by lots of small files during multi-threaded backup. They were also completely absent from single/multi-threaded backup resume and restore checksumming. (Reported by Janice Parkinson, Chris Barber.)
* Fixed an issue where the expire command would refuse to run when explicitly called from the command line if the db-host option was set. This was not an issue when expire was run automatically after a backup (Reported by Chris Barber.)
* Fixed an issue where validation was being running on archive_command even when the archive-check option was disabled.
Features:
* Added check command to validate that pgBackRest is configured correctly for archiving and backups. (Contributed by Cynthia Shang.)
* Added the protocol-timeout option. Previously protocol-timeout was set as db-timeout + 30 seconds.
* Failure to shutdown remotes at the end of the backup no longer throws an exception. Instead a warning is generated that recommends a higher protocol-timeout.
* Experimental support for non-exclusive backups in PostgreSQL 9.6 beta2. Changes to the control/catalog/WAL versions in subsequent betas may break compatibility but pgBackRest will be updated with each release to keep pace.
Refactoring:
* The pg_xlogfile_name() function is no longer used to construct WAL filenames from LSNs. While this function is convenient it is not available on a standby. Instead, the archive is searched for the LSN in order to find the timeline. If due to some misadventure the LSN appears on multiple timelines then an error will be thrown, whereas before this condition would have passed unnoticed.
* Option handling is now far more strict. Previously it was possible for a command to use an option that was not explicitly assigned to it. This was especially true for the backup-host and db-host options which are used to determine locality.
* Improved handling of users/groups captured during backup that do not exist on the restore host. Also explicitly handle the case where user/group is not mapped to a name.
* Changed version variable to a constant. It had originally been designed to play nice with a specific packaging tool but that tool was never used.
M README.md
M doc/resource/exe.cache
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
Fix when using shared_preload_libraries on Windows.
commit : 1c99eb969d28e950f8a236bc066aceac169bdc3a
author : Joe Conway <mail@joeconway.com>
date : Tue, 14 Jun 2016 09:24:46 -0400
committer: David Steele <david@pgmasters.net>
date : Tue, 14 Jun 2016 09:24:46 -0400
Click here for diff
IsUnderPostmaster behaves differently under Windows than it does under Linux. Instead use
process_shared_preload_libraries_in_progress to determine if pgaudit is being loaded by shared_preload_libraries.
M pgaudit.c
Remove 'use threads' from Wait.pm, fix potential undefined scenario that happened on Solaris (#12)
commit : a91f29388bdec6346e80fd596957659087706ac2
author : crunchyjohn <crunchyjohn@users.noreply.github.com>
date : Fri, 10 Jun 2016 14:48:42 -0400
committer: David Steele <dwsteele@users.noreply.github.com>
date : Fri, 10 Jun 2016 14:48:42 -0400
Click here for diff
M analyze/bin/pgaudit_analyze
M analyze/lib/PgAudit/Wait.pm
Update authors section.
commit : 2a989ac3732d9486c84f287a84da44d33c8a0892
author : David Steele <david@pgmasters.net>
date : Sat, 4 Jun 2016 11:30:47 -0400
committer: David Steele <david@pgmasters.net>
date : Sat, 4 Jun 2016 11:30:47 -0400
Click here for diff
v1.02: Bug Fix for Perl 5.22
commit : bfaee7380d6aa0a4a4573df2a6a28581537d169b
author : David Steele <david@pgmasters.net>
date : Thu, 2 Jun 2016 11:10:24 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 2 Jun 2016 11:10:24 -0400
Click here for diff
* Fix usage of sprintf() due to new constraints in Perl 5.22. Parameters not referenced in the format string are no longer allowed. (Fixed by Adrian Vondendriesch.)
M README.md
A doc/resource/exe.cache
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
Update .gitignore
commit : 26a7781f3ff223073867252210c0448c26df8547
author : David Steele <david@crunchydata.com>
date : Wed, 1 Jun 2016 10:44:53 -0400
committer: David Steele <david@crunchydata.com>
date : Wed, 1 Jun 2016 10:44:53 -0400
Click here for diff
M .gitignore
Fix for custom source.
commit : 8cae59f3acd4a4d4e1f810e012002af960c86a31
author : David Steele <david@pgmasters.net>
date : Tue, 31 May 2016 20:47:19 -0400
committer: David Steele <david@pgmasters.net>
date : Tue, 31 May 2016 20:47:19 -0400
Click here for diff
v1.01: Enhanced Info, Selective Restore, and 9.6 Support
commit : b710c016302d8d29c502aab5688197bf9a664131
author : David Steele <david@pgmasters.net>
date : Tue, 17 May 2016 01:04:01 -0400
committer: David Steele <david@pgmasters.net>
date : Tue, 17 May 2016 01:04:01 -0400
Click here for diff
* Enhanced text output of `info` command to include timestamps, sizes, and the reference list for all backups. Contributed by Cynthia Shang.
* Allow selective restore of databases from a cluster backup. This feature can result in major space and time savings when only specific databases are restored. Unrestored databases will not be accessible but must be manually dropped before they will be removed from the shared catalogue.
* Experimental support for non-exclusive backups in PostgreSQL 9.6 beta1. Changes to the control/catalog/WAL versions in subsequent betas may break compatibility but pgBackRest will be updated with each release to keep pace.
M CHANGELOG.md
M README.md
M doc/xml/change-log.xml
M lib/pgBackRest/Version.pm
Stamp 9.1.22.
commit : ddb0843d44a53518cfbbb5c2fd535021d75d07cd
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:57:25 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:57:25 -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
Translation updates
commit : e712933c80a15719293f0c55eeb02e0aae401820
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:10:35 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:10:35 -0400
Click here for diff
Stamp 9.2.17.
commit : e9dca8ce147f32d7d64a9e64f9d8339310ad6535
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:56:07 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:56:07 -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
Translation updates
commit : 3ad64ae4dadc56b756cb50845963c13ceb85d33f
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:09:45 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:09:45 -0400
Click here for diff
Stamp 9.3.13.
commit : cd5a6521fa8e9d51090330eb500157079fda1381
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:53:56 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:53:56 -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
Translation updates
commit : b81b97794cc81780105024667766d2f2f63fc62e
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:08:57 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:08:57 -0400
Click here for diff
Stamp 9.4.8.
commit : d130536e93378d9b6512d268639324ba7f60a815
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:52:03 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:52:03 -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
Translation updates
commit : c20dd81034ebeed38a372e3696dfe12550a26ce4
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:06:37 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:06:37 -0400
Click here for diff
Stamp 9.5.3.
commit : ba37ac217791dfdf2b327c4b75e7083b6b03a2f5
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:50:23 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 9 May 2016 16:50:23 -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
Translation updates
commit : e51547e05a44101667ef277c89319647e52c0f62
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:05:46 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 9 May 2016 10:05:46 -0400
Click here for diff
Passwords are now redacted in CREATE/ALTER ROLE statements.
commit : 506ed71d906f875328b92d5bcf589047f322ff0f
author : David Steele <david@pgmasters.net>
date : Thu, 5 May 2016 15:25:16 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 5 May 2016 15:25:16 -0400
Click here for diff
Note that all text in the statement after the "password" token is redacted so non-password related clauses will also be redacted when they follow the "password" token.
M expected/pgaudit.out
M pgaudit.c
M sql/pgaudit.sql
commit : 9ab0dd80f70cc69a6edc9e61b6053752a789fde3
author : David Steele <david@pgmasters.net>
date : Thu, 14 Apr 2016 23:04:20 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 14 Apr 2016 23:04:20 -0400
Click here for diff
* This flag day release breaks compatibility with older versions of pgBackRest. The manifest format, on-disk structure, configuration scheme, and the exe/path names have all changed. You must create a new repository to hold backups for this version of pgBackRest and keep your older repository for a time in case you need to do a restore. Restores from the prior repository will require the prior version of pgBackRest but because of name changes it is possible to have 1.00 and a prior version of pgBackRest installed at the same time. See the notes below for more detailed information on what has changed.
* Implemented a new configuration scheme which should be far simpler to use. See the User Guide and Configuration Reference for details but for a simple configuration all options can now be placed in the stanza section. Options that are shared between stanzas can be placed in the [global] section. More complex configurations can still make use of command sections though this should be a rare use case.
* The repo-path option now always refers to the repository where backups and archive are stored, whether local or remote, so the repo-remote-path option has been removed. The new spool-path option can be used to define a location for queueing WAL segments when archiving asynchronously. A local repository is no longer required.
* The default configuration filename is now pgbackrest.conf instead of pg_backrest.conf. This was done for consistency with other naming changes but also to prevent old config files from being loaded accidentally when migrating to 1.00.
* The default repository name was changed from /var/lib/backup to /var/lib/pgbackrest.
* Lock files are now stored in /tmp/pgbackrest by default. These days /run/pgbackrest is the preferred location but that would require init scripts which are not part of this release. The lock-path option can be used to configure the lock directory.
* Log files are now stored in /var/log/pgbackrest by default and no longer have the date appended so they can be managed with logrotate. The log-path option can be used to configure the lock directory.
* Executable filename changed from pg_backrest to pgbackrest.
* All files and directories linked from PGDATA are now included in the backup. By default links will be restored directly into PGDATA as files or directories. The --link-all option can be used to restore all links to their original locations. The --link-map option can be used to remap a link to a new location.
* Removed --tablespace option and replaced with --tablespace-map-all option which should more clearly indicate its function.
* Added detail log level which will output more information than info without being as verbose as debug.
M CHANGELOG.md
M doc/xml/change-log.xml
M lib/pgBackRest/Version.pm
Closed #9: CREATE EXTENSION problem.
commit : 3296ceff06d06ab95ea4285e40503509c17a3cec
author : David Steele <david@pgmasters.net>
date : Tue, 29 Mar 2016 21:38:54 -0400
committer: David Steele <david@pgmasters.net>
date : Tue, 29 Mar 2016 21:38:54 -0400
Click here for diff
This was happening because pgaudit.log was set before CREATE EXTENSION was called. This caused an issue where pgaudit was trying to log itself being created which won't work properly with event triggers. Documented that pgaudit.log must not be set when the pgaudit extension is created.
M README.md
Stamp 9.1.21.
commit : 158a0fb254578e93cec7a940c780426217b79343
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:16:20 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:16:20 -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
Translation updates
commit : 83b228a0babbbd637e830796a670a18a468732d5
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:52:41 +0200
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:52:41 +0200
Click here for diff
Stamp 9.2.16.
commit : 4edcd5f5d23c55f60d6c11451437437611731fff
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:14:18 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:14: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
Translation updates
commit : 190e273416968205db5110a561f5a314ad4b0119
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:51:44 +0200
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:51:44 +0200
Click here for diff
Stamp 9.3.12.
commit : a3c643938166abed9a390cdbd8a5df09bfe39523
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:12:29 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:12:29 -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
Translation updates
commit : e0f4c9e7c5dbeec4d63da0a3dd60c6159bd3ffac
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:50:07 +0200
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:50:07 +0200
Click here for diff
Stamp 9.4.7.
commit : d77841d1cebd3514603af055f141a84c8e53cbd3
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:09:55 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:09:55 -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
Translation updates
commit : a08a6dca995528cbf011cd8251daf1c190dd324d
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:48:08 +0200
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 28 Mar 2016 08:48:08 +0200
Click here for diff
Stamp 9.5.2.
commit : 730811c7d1600b92d4bcb91ac66d2206cf3a06ef
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:07:39 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 16:07:39 -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 : b56f7b1f0c5e41e85828774debf8b911a203e012
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 11:32:17 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 28 Mar 2016 11:32:17 -0400
Click here for diff
Stamp 9.1.20.
commit : 3dca6f36fcd694c8c49d26e7c4971194dee2754a
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Feb 2016 16:21:40 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Feb 2016 16:21:40 -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 : 862b4a427c18579327a7cfff4ac0377ef762dfa7
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 8 Feb 2016 14:50:20 -0500
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 8 Feb 2016 14:50:20 -0500
Click here for diff
Stamp 9.2.15.
commit : a0606058016b7d20406910b7a73e60ddb3e4c9ff
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Feb 2016 16:19:37 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Feb 2016 16:19: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
Translation updates
commit : 6a10dd08006e8f0ce9c1dc2f45379bb17f428e27
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 8 Feb 2016 14:42:59 -0500
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 8 Feb 2016 14:42:59 -0500
Click here for diff