PGCon2008 - Final - we hope
PGCon 2008
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Zdeněk Kotala |
| Schedule | |
|---|---|
| Day | Talks - second day (2008-05-23) |
| Room | G |
| Start time | 16:00 |
| Duration | 01:00 |
| Info | |
| ID | 87 |
| Event type | lecture |
| Track | Hacker |
| Language | en |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
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.