Skip to content

README.md

Latest commit

 

History

History
31 lines (18 loc) · 1.47 KB

README.md

File metadata and controls

31 lines (18 loc) · 1.47 KB

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');