PostgreSQL and Collation. What changed in PostgreSQL 10.

Introduction Not so long ago, one of our customers turned to us with problem. The fact is that PostgreSQL refused to use the index on the text field if you try to make a selection using regular expressions (LIKE/ILIKE and POSIX). Our colleagues wondered why Postgres does not use the index, because the database used the ….Read more

13 October 2017 by 1097 0

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 170 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 352 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 241 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"> 389 0
Page 2 of 41234