UPGRADE
author Pascal Volk <neverseen@users.sourceforge.net>
Tue, 26 Aug 2008 01:53:48 +0000
changeset 67 e4d25f50164d
parent 42 9d10877e1c10
child 106 dc98cc162c66
permissions -rw-r--r--
* 'create_tables.pgsql' * 'update_tables_0.4.x-0.5.pgsql' - Changed length of address column in table from varchar(256) to varchar(64) because only the local part will be stored. * 'UPGRADE' - Updated, privileges on view postfix_alias have to be set once again.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     1
If you still have installed vmm 0.3.x you have to proceed this step first:
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     2
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     3
    * upgrade your vmm installation to version 0.4-r41
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     4
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     5
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     6
If you have installed vmm 0.4/0.4-r41 you have to proceed this steps:
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     7
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     8
    * stop Postfix and Dovecot
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
     9
    * backup/dump your database.
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    10
    * backup/dump your database!
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    11
    
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    12
    * start psql and connect to the appropriate database (ex. psql mailsys)
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    13
    * update the database: \i update_tables_0.4.x-0.5.pgsql
67
e4d25f50164d * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 42
diff changeset
    14
    * GRANT SELECT ON postfix_alias TO postfix;
e4d25f50164d * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 42
diff changeset
    15
                                       ^^^^^^^^ <- your Postfix db user
42
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    16
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    17
    * execute upgrade.sh
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    18
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    19
    * start Dovecot and Postfix
9d10877e1c10 * 'create_tables.pgsql'
Pascal Volk <neverseen@users.sourceforge.net>
parents: 38
diff changeset
    20
38
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    21
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    22
else
c44ea4526546 * 'VirtualMailManager/Alias.py'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    23
     * read INSTALL