PgConf.Russia 2016

In addition to providing a general purpose web platform, Heroku has a large, supporting Postgres service. Over the years, we've learned a lot about running Postgres at scale.
In this talk, we'll cover:

• why Postgres is attractive to run as a cloud service
• how to provision, manage, and monitor a Postgres fleet
• tradeoffs needed to make Postgres work in this environment
• automating failure recovery
• and more

Diasoft Platform company's technology solutions for migration of applications from proprietary DBMS (on the examples of Oracle and Microsoft SQL Server) to PostgreSQL will be presented in the talk. These solutions are implemented in Diasoft Database Adapter software.

Our technology solutions allow to automate: 1) migration of database schema (including translation of stored procedure and function code); 2) migration of data; 3) migration of client applications without any change in their source code.

The talk is about PostgreSQL clusters using streaming replication and pgpool-II, which are quite popular in Japan. Plus, the next version of pgpool-II will be released this winter, so the talk will be about what's new in the version.

• the architecture
• the design and implementation of PL/pgSQL
• the difference between PL/SQL and PL/pgSQL
• the advantage and issues of PL/pgSQL