The first PostGIS Meetup in Israel

About PostGIS PostGIS is an extension to Postgresql that implements the OpenGis standard. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). This extension contains extensive functionality for working with spatial data. This allows you to write interesting an useful applications. In particular, OpenStreetMap uses PostGIS to display its maps. It is also widely used in ….Read more

6 October 2017 by 130 0

What’s new in PostgreSQL 10? Part 5 – Authentication and Row Level Security

Introduction Historically, PostgreSQL used a single encryption method. It’s not-so-safe md5 algorithm. In 10 version provided support for new authentication method SCRAM-SHA-256 for password negotiation and storage. Also in 9.6 or earlier version of PostgreSQL when multiple policies were set for a table, policies were determined by OR condition. Now can using the AND condition. ….Read more

28 August 2017 by 233 0

What’s new in PostgreSQL 10? Part 4 – Replication and Scaling

Agenda Quorum Commit for Synchronous Replication Connection “Failover” in libpq Traceable Commit Physical Replication Temporary replication slot Quorum Commit for Synchronous Replication PostgreSQL 10 implements Quorum-based synchronous replication, which arbitrarily selects an instance to perform synchronous replication. The synchronous replication environment is set by the synchronous_standby_names configuration parameter as before. synchronous_standby_names = ANY 2(node1,node2,node3); synchronous_standby_names ….Read more

17 August 2017 by 169 0

What’s new in PostgreSQL 10? Part 3 – Native Logical Replication

Introduction Before 10 version PostgreSQL was supported only Physical Streaming Replication (PSR). PSR is based on the Write-Ahead Log (WAL), which means that all changes are written to the binary transaction log and sent to all standby servers.  The changes  described there are very low-level and it’s give garanties that the data was consistensy. Also, PSR provides minimal ….Read more

7 August 2017 by Emil Shkolnik"> 285 0

What’s new in PostgreSQL 10? Part 2 – Native Partitioning

Overview Before version 10, PostgreSQL used inheritance tables as a method for physically partitioning a large table. The inheritance table creates multiple child tables for the parent table and maintains the consistency of data by CHECK constraints and triggers. The application can send requests to the parent table and transparently use the data of the ….Read more

1 August 2017 by 540 0
Page 2 of 41234