~?~

~?~

~?~

Want to edit, but don't see an edit button when logged in? Click here. Jump to: navigation , search start content 1 What's New In PostgreSQL 10 1.1 Big Data 1.1.1 Native Partitioning 1.1.2 Additional Parallelism 1.1.3 Additional FDW Push-Down 1.1.4 Faster Analytics Queries 1.2 Replication and Scaling 1.2.1 Logical Replication 1.2.2 Quorum Commit for Synchronous Replication 1.2.3 Connection "Failover" in libpq 1.2.4 Traceable Commit 1.2.5 Physical Replication 1.3 Administration 1.3.1 Compression support for pg_receivewal 1.4 SQL features 1.4.1 Identity Columns 1.4.2 Crash Safe, Replicable Hash Indexes 1.4.3 Transition Tables for Triggers 1.5 XML and JSON 1.5.1 XMLTable 1.5.2 Full Text Search support for JSON and JSONB 1.6 Security 1.6.1 SCRAM Authentication 1.6.2 New "monitoring" roles for permission grants 1.6.3 Restrictive Policies ...

Jump to: navigation , search start content This document has been superseded by the new official BDR documentation for BDR 0.9.0 and newer. It is retained here to provide a reference for version 0.8.0 and older. This page is the users and administrators guide for BDR. If you're looking for technical details on the project plan and implementation, see BDR Project . For detailed parameters, etc, see BDR Reference . Just want to dive in and try out BDR? Take a look at the BDR Quick Start . 1 New documentation 2 About BDR 3 BDR Quick Start 4 Administration Guide 5 Reference New documentation This document has been superseded by the new official BDR documentation for BDR 0.9.0 and newer. It is retained here to provide a reference for version 0.8.0 and older. About BDR BDR (Bi-Directional Replication) is the latest replication technology for PostgreSQL, developed by...

Jump to: navigation , search start content BDR stands for B i D irectional R eplication. This page discusses the BDR development project. If you're looking for the user/admin documentation, see BDR User Guide . Design work began in late 2011 to look at ways of adding new features to PostgreSQL core to support a flexible new infrastructure for replication that built upon and enhanced the existing streaming replication features added in 9.1-9.2. Initial design and project planning was by Simon Riggs; implementation lead is now Andres Freund, both from 2ndQuadrant . Various additional development contributions from the wider 2ndQuadrant team as well as reviews and input from other community devs. At the PgCon2012CanadaInCoreReplicationMeeting an inital version of the design was presented. A presentation containing reasons leading to the current design and a prototype of it...

Jump to: navigation , search start content (This page is currently under development ahead of the release of PostgreSQL 9.5) This page contains an overview of PostgreSQL Version 9.5's features, including descriptions, testing and usage information, and links to blog posts containing further information. See also PostgreSQL 9.5 Open Items . 1 Major new features 1.1 IMPORT FOREIGN SCHEMA 1.1.1 Links 1.2 Row-Level Security Policies 1.2.1 Links 1.3 BRIN Indexes 1.3.1 Links 1.4 Foreign Table Inheritance 1.4.1 Links 1.5 pg_rewind 1.5.1 Links 2 Other new features 2.1 ALTER TABLE ... SET LOGGED / UNLOGGED 2.2 SKIP LOCKED 2.2.1 Links 2.3 Parallel VACUUMing 2.3.1 Links 2.4 GiST Index-Only Scans Major new features IMPORT FOREIGN SCHEMA Previously, in order to create a foreign table in PostgreSQL, you would need to define the table, referencing...

~?~

Jump to: navigation , search start content 1 Development Process 2 Administration 2.1 Configuration files 2.2 Tablespaces 2.3 Statistics Collector 2.4 SSL 2.5 Point-In-Time Recovery (PITR) 2.6 Standby server mode 3 Data Types 3.1 Domains 3.2 Dates and Times 3.3 Arrays 3.4 Binary Data 3.5 MONEY Data Type 3.6 Text Search 3.7 XML 4 Functions 4.1 Character Formatting 5 Multi-Language Support 6 Views and Rules 7 SQL Commands 7.1 CREATE 7.2 UPDATE 7.3 ALTER 7.4 CLUSTER 7.5 COPY 7.6 GRANT/REVOKE 7.7 DECLARE CURSOR 7.8 INSERT 7.9 SHOW/SET 7.10 ANALYZE 7.11 Window Functions 8 Integrity Constraints 8.1 Keys 8.2 Referential Integrity 8.3 Check Constraints 9 Server-Side Languages 9.1 SQL-Language Functions 9.2 PL/pgSQL 9.3 PL/Perl 9.4 PL/Python 9.5 PL/Tcl 10 Clients 10.1 pg_ctl 10.2 psql 10.3 pg_dump / pg_restore 10.4 ecpg 1...

Jump to: navigation , search start content 1 Development Process 2 Administration 2.1 Configuration files 2.2 Tablespaces 2.3 Statistics Collector 2.4 SSL 2.5 Point-In-Time Recovery (PITR) 2.6 Standby server mode 3 Data Types 3.1 Domains 3.2 Dates and Times 3.3 Arrays 3.4 Binary Data 3.5 MONEY Data Type 3.6 Text Search 3.7 XML 4 Functions 4.1 Character Formatting 5 Multi-Language Support 6 Views and Rules 7 SQL Commands 7.1 CREATE 7.2 UPDATE 7.3 ALTER 7.4 CLUSTER 7.5 COPY 7.6 GRANT/REVOKE 7.7 DECLARE CURSOR 7.8 INSERT 7.9 SHOW/SET 7.10 ANALYZE 7.11 Window Functions 8 Integrity Constraints 8.1 Keys 8.2 Referential Integrity 8.3 Check Constraints 9 Server-Side Languages 9.1 SQL-Language Functions 9.2 PL/pgSQL 9.3 PL/Perl 9.4 PL/Python 9.5 PL/Tcl 10 Clients 10.1 pg_ctl 10.2 psql 10.3 pg_dump / pg_restore 10.4 ecpg 1...