PGCon2008 - Final - we hope

PGCon 2008
The PostgreSQL Conference

Zdeněk Kotala
Day Talks - second day (2008-05-23)
Room G
Start time 16:00
Duration 01:00
ID 87
Event type lecture
Track Hacker
Language en

PostgreSQL upgrade project

Upgrade on-the-fly or with minimal down time.

Upgrade from old PostgreSQL version to the new is now possible only through data export and import. PG upgrade is a project which should allow to upgrade database on-fly or with minimal down time.

Database upgrade is not easy task. Session will show current situation and it will focus on each affected parts of PostgreSQL and its conversion process. Presentation will start with storage module. Difference between page versions will be described include a way how to convert page structures and tuple headers. Second very important part is system catalog. Each new version of postgreSQL usually has modified system catalog structure. Catalog contains very important data for postgreSQL run and its conversion is very complicated. Talk will show some possible ways. Data types on disk structure conversion is last big part of upgrade process which will be presented. It also include varlena encoding change.