diff options
| author | Palle Girgensohn <girgen@FreeBSD.org> | 2019-02-15 11:02:22 +0000 |
|---|---|---|
| committer | Palle Girgensohn <girgen@FreeBSD.org> | 2019-02-15 11:02:22 +0000 |
| commit | f7e9e29abb1593ce90e54df31cf7c327ef1e03cb (patch) | |
| tree | 57fd167c04384663545f34f8218b5b573867a5c8 /databases/postgresql95-server | |
| parent | Update to 6.3.63 (diff) | |
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.2, 10.7, 9.6.12,
9.5.16, and 9.4.21. This release changes the behavior in how PostgreSQL
interfaces with `fsync()` and includes fixes for partitioning and over
70 other bugs that were reported over the past three months.
Users should plan to apply this update at the next scheduled downtime.
FreeBSD port adds OPTIONS knob to support LLVM JIT. [1]
Highlight: Change in behavior with fsync()
------------------------------------------
When available in an operating system and enabled in the configuration
file (which it is by default), PostgreSQL uses the kernel function
`fsync()` to help ensure that data is written to a disk. In some
operating systems that provide `fsync()`, when the kernel is unable to
write out the data, it returns a failure and flushes the data that was
supposed to be written from its data buffers.
This flushing operation has an unfortunate side-effect for PostgreSQL:
if PostgreSQL tries again to write the data to disk by again calling
`fsync()`, `fsync()` will report back that it succeeded, but the data
that PostgreSQL believed to be saved to the disk would not actually be
written. This presents a possible data corruption scenario.
This update modifies how PostgreSQL handles a `fsync()` failure:
PostgreSQL will no longer retry calling `fsync()` but instead will
panic. In this case, PostgreSQL can then replay the data from the
write-ahead log (WAL) to help ensure the data is written. While this may
appear to be a suboptimal solution, there are presently few alternatives
and, based on reports, the problem case occurs extremely rarely.
A new server parameter `data_sync_retry` has been added to manage this
behavior. If you are certain that your kernel does not discard dirty
data buffers in such scenarios, you can set `data_sync_retry` to `on` to
restore the old behavior.
Release Notes: https://www.postgresql.org/about/news/1920/
PR: 232490 [1]
Notes
Notes:
svn path=/head/; revision=492989
Diffstat (limited to 'databases/postgresql95-server')
| -rw-r--r-- | databases/postgresql95-server/Makefile | 6 | ||||
| -rw-r--r-- | databases/postgresql95-server/distinfo | 6 | ||||
| -rw-r--r-- | databases/postgresql95-server/pkg-plist-server | 1 |
3 files changed, 7 insertions, 6 deletions
diff --git a/databases/postgresql95-server/Makefile b/databases/postgresql95-server/Makefile index 7e4e19781032..e2a54b85fab6 100644 --- a/databases/postgresql95-server/Makefile +++ b/databases/postgresql95-server/Makefile @@ -1,8 +1,8 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.5.15 -PORTREVISION= 1 +DISTVERSION?= 9.5.16 +PORTREVISION= 0 PKGNAMESUFFIX?= ${PORTVERSION:R:S/.//}${COMPONENT} MAINTAINER?= pgsql@FreeBSD.org @@ -23,4 +23,4 @@ PG_USER?= pgsql PG_GROUP?= pgsql PG_UID?= 70 -.include "${.CURDIR}/../postgresql10-server/Makefile" +.include "${.CURDIR}/../postgresql11-server/Makefile" diff --git a/databases/postgresql95-server/distinfo b/databases/postgresql95-server/distinfo index 35224ed67357..f821c7f8937b 100644 --- a/databases/postgresql95-server/distinfo +++ b/databases/postgresql95-server/distinfo @@ -1,5 +1,5 @@ -TIMESTAMP = 1541712782 -SHA256 (postgresql/postgresql-9.5.15.tar.bz2) = dbda3fdefd7f9fd5359a7989085aaef25c9f9d08816eda6378c2575d1ff55444 -SIZE (postgresql/postgresql-9.5.15.tar.bz2) = 18707696 +TIMESTAMP = 1550095350 +SHA256 (postgresql/postgresql-9.5.16.tar.bz2) = a4576c95d4dcee8d4b7835b333d38e909848222e4b87895878bb1c026206e131 +SIZE (postgresql/postgresql-9.5.16.tar.bz2) = 17506874 SHA256 (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5fa083ec38087d6a0961642208f012e902221270708b919b92e9eedaa755e365 SIZE (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5952 diff --git a/databases/postgresql95-server/pkg-plist-server b/databases/postgresql95-server/pkg-plist-server index 866dba0de614..be0433732081 100644 --- a/databases/postgresql95-server/pkg-plist-server +++ b/databases/postgresql95-server/pkg-plist-server @@ -453,6 +453,7 @@ lib/libpgcommon.a %%TZDATA%%%%DATADIR%%/timezone/Asia/Pontianak %%TZDATA%%%%DATADIR%%/timezone/Asia/Pyongyang %%TZDATA%%%%DATADIR%%/timezone/Asia/Qatar +%%TZDATA%%%%DATADIR%%/timezone/Asia/Qostanay %%TZDATA%%%%DATADIR%%/timezone/Asia/Qyzylorda %%TZDATA%%%%DATADIR%%/timezone/Asia/Rangoon %%TZDATA%%%%DATADIR%%/timezone/Asia/Riyadh |