6 If you have installed vmm 0.4/0.4-r41 you have to proceed this steps:

     6 If you have installed vmm 0.4/0.4-r41 you have to proceed this steps:

     7 

     7 

     8     * stop Postfix and Dovecot

     8     * stop Postfix and Dovecot

     9     * backup/dump your database.

     9     * backup/dump your database.

    10     * backup/dump your database!

    10     * backup/dump your database!

    12     * start psql and connect to the appropriate database

    12     * start psql and connect to the appropriate database

    13       (ex. psql mailsys mailsys vmm -W -h localhost)

    13       (ex. psql mailsys mailsys vmm -W -h localhost)

    14     * update the database: \i update_tables_0.4.x-0.5.pgsql

    14     * update the database: \i update_tables_0.4.x-0.5.pgsql

    15     * GRANT SELECT ON postfix_alias TO postfix;

    15     * GRANT SELECT ON postfix_alias TO postfix;

    16                                        ^^^^^^^^ <- your Postfix db user

    16                                        ^^^^^^^^ <- your Postfix db user

    27          dovecot-sql.conf, update it also:

    27          dovecot-sql.conf, update it also:

    28          \i update_types_and_functions_0.5.x_for_dovecot-1.2.x.pgsql

    28          \i update_types_and_functions_0.5.x_for_dovecot-1.2.x.pgsql

    29 

    29 

    30        * You have also to adjust the permissions of the set-uid deliver copy:

    30        * You have also to adjust the permissions of the set-uid deliver copy:

    31          chgrp nogroup /usr/local/lib/dovecot/deliver

    31          chgrp nogroup /usr/local/lib/dovecot/deliver

    33 

    33 

    34     * execute upgrade.sh

    34     * execute upgrade.sh

    35 

    35 

    36     * start Dovecot and Postfix

    36     * start Dovecot and Postfix

    37 

    37