./databases/postgresql11-server, PostgreSQL database server programs

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 11.2, Package name: postgresql11-server-11.2, Maintainer: adam

PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
derived from the Berkeley Postgres database management system. While
PostgreSQL retains the powerful object-relational data model, rich data types
and easy extensibility of Postgres, it replaces the PostQuel query language
with an extended subset of SQL.

PostgreSQL is free and the complete source is available.

This package contains the database server programs.

DEINSTALL [+/-]

Required to run:
[textproc/libxml2] [databases/postgresql11-client]

Required to build:
[pkgtools/cwrappers]

Package options: gssapi

Master sites:

SHA1: 21fd2f0c08dc69514e86a6b25d56059bb0418a62
RMD160: 6b092d1e0695ee14fa1363ce931fa0f179c11b2d
Filesize: 19252.177 KB

Version history: (Expand)


CVS history: (Expand)


   2019-02-17 09:26:13 by Adam Ciarcinski | Files touched by this commit (29) | Package updated
Log message:
postgresqlNN: updated to 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21

PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 Released!
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.

Fix handling of unique indexes with INCLUDE columns on partitioned tables
Ensure that NOT NULL constraints of a partitioned table are honored within its \ 
partitions
Several fixes for constraints on partitioned tables
Fix problems with applying ON COMMIT DROP and ON COMMIT DELETE ROWS to \ 
partitioned tables and tables with inheritance children
Disallow COPY FREEZE on partitioned tables
Several fixes for the ALTER TABLE .. ADD COLUMN with a non-nullable default \ 
feature, including a possible index corruption case
Several fixes in GIN indexes, including avoiding a deadlock with vacuuming and \ 
concurrent index insertions (which partially reverts a performance improvement \ 
introduced in PostgreSQL 10)
Fix possible crashes in logical replication when index expressions or predicates \ 
are in use
Several fixes for the write-ahead log (WAL)
Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT
Fix crash when zero rows are provided to json[b]_populate_recordset() or \ 
json[b]_to_recordset()
Several fixes related to collation handling, including the parsing of \ 
collation-sensitive expressions in the arguments of a CALL statement
Several fixes for the query planner, including an improvement to planning speed \ 
for large inheritance or partitioning table groups
Several fixes for TRUNCATE
Ensure ALTER TABLE ONLY ADD COLUMN IF NOT EXISTS is processed correctly
Allow UNLISTEN in hot-standby (replica) mode
Fix parsing of space-separated lists of host names in the ldapserver parameter \ 
of LDAP authentication entries in pg_hba.conf
Several fixes for ecpg
Several fixes for psql, including having \g target work with COPY TO STDOUT
The random number generation for pgbench is now fully deterministic and \ 
platform-independent when --random-seed=N is specified
Fix pg_basebackup and pg_verify_checksums to appropriately ignore temporary files
Several fixes for pg_dump, including having ALTER INDEX SET STATISTICS commands \ 
present
Prevent false index-corruption reports from contrib/amcheck caused by \ 
inline-compressed data
Support new Makefile variables to help with building extensions
   2019-02-06 23:33:44 by Amitai Schleier | Files touched by this commit (6)
Log message:
As suggested by joerg@, "cd /" works even when initdb hasn't happened yet.
Ride previous PKGREVISION bump.
   2019-02-06 19:45:56 by Amitai Schleier | Files touched by this commit (12) | Package updated
Log message:
${PGUSER} doesn't have read permission in every conceivable working
directory, which causes errors for several actions. But the caller's
working directory isn't needed for anything. cd into ${pgsql_home}
early, just after reading rc.conf. Bump PKGREVISION.
   2018-10-23 18:02:52 by Adam Ciarcinski | Files touched by this commit (51)
Log message:
postgresql11: added version 11.0

PostgreSQL 11 provides users with improvements to overall performance of the \ 
database system, with specific enhancements associated with very large databases \ 
and high computational workloads. Further, PostgreSQL 11 makes significant \ 
improvements to the table partitioning system, adds support for stored \ 
procedures capable of transaction management, improves query parallelism and \ 
adds parallelized data definition capabilities, and introduces just-in-time \ 
(JIT) compilation for accelerating the execution of expressions in queries.