PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Alexander Korotkov
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Morisset 221
Start time 11:00
Duration 00:45
ID 700
Event type Lecture
Track Case Studies
Language used for presentation English

PostgreSQL experience in Russian Parliament

Success story of PostgreSQL in Russian State Duma

In 2010 Russian State Duma (lower chamber of parliament) renewed its web site. That was the first step in modernization towards open data and e-goverment in further years. PostgreSQL took a central place in data integration between intranet systems and open web services. During recent years many new open data systems were launched powered by PostgreSQL.

This talk covers the issues of PostgreSQL integration into State Duma intranet systems, which were mostly running Oracle Database as well as implementation of many open data systems. Data between intranet systems and PostgreSQL databases are mostly synchronized using ora2pg. Full synchronization was used for small databases as well as incremental synchronization for large databases. Open data systems implemented on PostgreSQL including:

  • Law and draft law search systems
  • Open vote system
  • Verbatim system

Using PostgreSQL database allows to save license const as well as achieve great performance and features.