Purpose
This package contains changes necessary to use PostgreSql rather than Mysql. It is based upon the following installation tutorial:
DISCLAIMER: Take this data with a grain of salt. If you don't know what you're doing, don't to it !!! Since I haven't tried to install a mailserver again it's possibly that some information might have slipped although I don't believe so.
Folders
- ./dovecot - changes for the dovecot installation
- ./postfix - changes for the postfix installation
- ./setup-db - sql scripts for the database setup. for postgres user you need to invoke psql rather mysql.
Different Packages
- instead of dovecot-mysql use dovecot-pgsql
- instead of postfix-mysql use postfix-pgsql
Commands
- New domain: INSERT INTO domains (id, domain) VALUES (NEXTVAL('idgenerator'), 'mysystems.tld');
- New mailbox: INSERT INTO accounts (id, username, domain, password, quota, enabled, sendonly, fullusername) VALUES (NEXTVAL('idgenerator'), 'user1', 'mysystems.tld', '{SHA512-CRYPT}$6$wHyJsS[...]', 2048, true, false, 'user1@mysystems.tld');
- New alias: INSERT INTO aliases (id, source_username, source_domain, destination_username, destination_domain, enabled) VALUES (NEXTVAL('idgenerator'), 'alias', 'mysystems.tld', 'user1', 'mysystems.tld', true);
- New Tls Policy: INSERT INTO tlspolicies (id, domain, policy, params) VALUES (NEXTVAL('idgenerator'), 'gmx.de', 'secure', 'match=.gmx.net');