Introduction As you know postgres_fdw extension using to access data stored in external PostgreSQL servers. postgres_fdw provides has more transparent and standards-compliant syntax for accessing remote tables than dblink. Additionaly, this extension provides...
Read MoreThis post is based on the talk by Oleg Bartunov on pgConf2018.RU It is imperative that a user be able to construct new access methods to provide efficient access to instances of...
Read MoreIntroduction Recently we were approached by one of our clients with an interesting task. The fact is that he has a large database, around 1.5 TB. He also has several standbys from this...
Read MoreOVERVIEW To migrate the data from Oracle to Postgres, we using the utility Ora2Pg. Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema....
Read MoreCorrective updates are available for all supported PostgreSQL branches: 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20 and 9.2.24, which contain a batch of bug fixes, including fixes for problems that could lead...
Read MoreIntroduction 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...
Read MoreAbout 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...
Read MoreIntroduction 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...
Read MoreAgendaQuorum Commit for Synchronous Replication Connection "Failover" in libpq Traceable Commit Physical Replication Temporary replication slotQuorum Commit for Synchronous Replication PostgreSQL 10 implements Quorum-based synchronous replication, which arbitrarily selects an...
Read MoreIntroduction 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...
Read More
