This file contains important information about PostgreSQL Mageia's rpms.

This document is dedicated to postgres administrators and or system
administrators.
I assume you know:
  - what is postgres
  - what is database backup
  - what are and how to use pg_dump, pgdump_all and psql
  - how to backup and restore your database by hand.

If you have any doubt, please refer to postgresql documentation.

Olivier Thauvin <nanardon@mandriva.org>

* Database migration

If you plan to later change your postgresql major version (eg 8.2 => 8.3),
you'll have to dump and restore your databases yourself.

- how to configure tablespace:
    Tablespace as know by postgresql 8 and higher are supported, location on
    previous will not be moved. Anyway, postgresql 8 is unable to automatically
    translate pg location to tablespace.

    As all data directory, a directory with name suffixed by backup id is
    created, files are moved from old to the new directory:
    if your location is /foo/data, /foo/data.ID is created, files from
    /foo/data are moved into /foo/data.ID, leaving /foo/data empty and ready
    to store new database.

    A good practice is to respect the pgsql/data structure to allow data to be
    easilly moved, eg if you want a dedicated partition for your data, mount
    point should be pgsql/ and your data into subdirectory.

* Version 8.1 and later

- pg_autovacuum
    pg_autovacuum is a daemon which monitor database and run vacuum and analyze
    when needed. Introduced as a postgresql contrib in version 8.0, mandriva rpm was
    providing an initscript to start the daemon at boot.
    This feature is now included into the backend itself, it is disabled by
    default. Set autovacuum parameter to true into postgresql.conf