====== 8.4 => 9.0 ======
===== Etape 0 : les bases obsolètes =====
drupal6 et pgfr sont juste des vestiges du passé :)
/usr/local/pgsql/bin/dropdb -h 127.0.0.1 -p 5433 drupal6
/usr/local/pgsql/bin/createdb -h 127.0.0.1 -p 5433 drupal6
pg_dump drupal6 | /usr/local/pgsql/bin/psql -h 127.0.0.1 -p 5433 drupal6
/usr/local/pgsql/bin/dropdb -h 127.0.0.1 -p 5433 pgfr
/usr/local/pgsql/bin/createdb -h 127.0.0.1 -p 5433 pgfr
pg_dump pgfr | /usr/local/pgsql/bin/psql -h 127.0.0.1 -p 5433 pgfr
===== Etape 1 : limesurvey =====
/usr/local/pgsql/bin/createuser -h 127.0.0.1 -p 5433 limesurvey -SPRDl
/usr/local/pgsql/bin/createdb -h 127.0.0.1 -p 5433 limesurvey --owner limesurvey
pg_dump limesurvey | /usr/local/pgsql/bin/psql -h 127.0.0.1 -p 5433 limesurvey -U limesurvey
===== Etape 1a : roundcube + postfix + postfixadmin =====
/usr/local/pgsql/bin/createuser -h 127.0.0.1 -p 5433 roundcube -SPRDl
/usr/local/pgsql/bin/createdb -h 127.0.0.1 -p 5433 roundcube --owner roundcube
pg_dump roundcube | /usr/local/pgsql/bin/psql -h 127.0.0.1 -p 5433 roundcube -U roundcube
+ Modification du fichier :
/data/www/fr/postgresql.fr/webmail$/config/db.inc.php
===== Etape 1b : courier + postfix + postfixadmin =====
/usr/local/pgsql/bin/createuser -h 127.0.0.1 -p 5433 postfix -SPRDl
/usr/local/pgsql/bin/createdb -h 127.0.0.1 -p 5433 postfix --owner postfix
pg_dump postfix | /usr/local/pgsql/bin/psql -h 127.0.0.1 -p 5433 postfix -U postfix
fichier à modifier :
* /usr/share/postfixadmin/config.inc.php
* /etc/courier/authpgsqlrc
* /etc/postfix/pgsql
ROLLBACK ! Postfix et postfixadmin supportent mal le port 5433 :-/