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!  | 
    11       | 
    11       | 
    12     * start psql and connect to the appropriate database (ex. psql mailsys)  | 
    12     * start psql and connect to the appropriate database  | 
         | 
    13       (ex. psql mailsys mailsys vmm -W -h localhost)  | 
    13     * 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  | 
    14     * GRANT SELECT ON postfix_alias TO postfix;  | 
    15     * GRANT SELECT ON postfix_alias TO postfix;  | 
    15                                        ^^^^^^^^ <- your Postfix db user  | 
    16                                        ^^^^^^^^ <- your Postfix db user  | 
         | 
    17   | 
         | 
    18   | 
         | 
    19   Dovecot v1.2.x  | 
         | 
    20     -> Are you already using Dovecot v1.2.x?  | 
         | 
    21        * update the database for Dovecot v1.2.x:  | 
         | 
    22          \i update_tables_0.5.x_for_dovecot-1.2.x.pgsql  | 
         | 
    23        * GRANT SELECT ON dovecot_password TO dovecot;  | 
         | 
    24                                              ^^^^^^^^ <- your Dovecot db user  | 
         | 
    25   | 
         | 
    26        * When you are using the SQL function »dovecotpassword()« in your  | 
         | 
    27          dovecot-sql.conf, update it also:  | 
         | 
    28          \i update_types_and_functions_0.5.x_for_dovecot-1.2.x.pgsql  | 
         | 
    29   | 
         | 
    30        * You have also to adjust the permissions of the set-uid deliver copy:  | 
         | 
    31          chgrp nogroup /usr/local/lib/dovecot/deliver  | 
         | 
    32 	 chmod u+s,o-rwx /usr/local/lib/dovecot/deliver  | 
    16   | 
    33   | 
    17     * execute upgrade.sh  | 
    34     * execute upgrade.sh  | 
    18   | 
    35   | 
    19     * start Dovecot and Postfix  | 
    36     * start Dovecot and Postfix  | 
    20   | 
    37   | 
    21   | 
    38   | 
    22 If you have installed vmm 0.5:  | 
    39   | 
         | 
    40 If you have installed vmm 0.5.x:  | 
    23   | 
    41   | 
    24     * execute upgrade.sh  | 
    42     * execute upgrade.sh  | 
         | 
    43   | 
         | 
    44     -> Are you already using Dovecot v1.2.x?  | 
         | 
    45        See a few lines above.  | 
    25   | 
    46   | 
    26   | 
    47   | 
    27 else  | 
    48 else  | 
    28      * read INSTALL  | 
    49      * read INSTALL  |