DBMail over PostgreSQL + Postfix + SASL on Debian. Part 3. Postfix.

1 Comment / Administration, PostgreSQL /

Part 1. Introduction.Part 2. DBMail.Part 3. Postfix.Part 4. SASL.Part 5. SPF. DKIM. DMARC. Clear headers. DNS PTR. Install postfix with No configuration option. apt install postfix Edit /etc/postfix/main.cf config file. mydomain = somewhere-in-the.space myhostname = mail.somewhere-in-the.space #disable /etc/aliases files lookup, all users are stored inside DB alias_maps = alias_database = mydestination = $mydomain, localhost, localhost.localdomain, …

DBMail over PostgreSQL + Postfix + SASL on Debian. Part 3. Postfix. Read More »

DBMail over PostgreSQL + Postfix + SASL on Debian. Part 2. DBMail.

Leave a Comment / Administration, PostgreSQL /

Part 1. Introduction.Part 2. DBMail.Part 3. Postfix.Part 4. SASL.Part 5. SPF. DKIM. DMARC. Clear headers. DNS PTR. nfgd.net repo was gone, so there are no compiled deb packages now. We need to build one manually.Download the latest sources from official site or download 3.2.3 from my backup and unpack it. cd /root wget http://dbmail.org/download/3.2/dbmail-3.2.3.tar.gz tar …

DBMail over PostgreSQL + Postfix + SASL on Debian. Part 2. DBMail. Read More »

DBMail over PostgreSQL + Postfix + SASL on Debian. Part 1. Introduction.

Leave a Comment / Administration, Featured, PostgreSQL /

Databases are bad for email. Howbeit, sometimes you really don’t need fast mailing system, but want to use an existing database backup infrastructure. At this article we will setup our own mail server using DBMail, Postfix and SASL. DBMail is an open source mail server which able to use relational database to store all users …

DBMail over PostgreSQL + Postfix + SASL on Debian. Part 1. Introduction. Read More »

Running QEMU VM with the latest kernel inside 2.6 OpenVZ container.

1 Comment / Administration, Featured, Virtualization /

There are many of cheap NAT OpenVZ VPSes on market. However, OpenVZ virtualization has certain limitations and comes with old 2.6 kernel. Hosting provider can decide to disable tun/tap, nfs or another core feautures, which makes VPS very limited in usage. At this article we will break the rules and run latest Alpine Linux inside …

Running QEMU VM with the latest kernel inside 2.6 OpenVZ container. Read More »

Fault tolerant PostgreSQL cluster. Part 5. Testing. Ansible. Final thoughts.

15 Comments / Database, PostgreSQL /

Part 1. Introduction.Part 2. Replication. Repmgr.Part 3. Auto-failover. Repmgr daemons.Part 4. HA. Backup. Repmgr daemons. Barman.Part 5. Testing. Ansible. Final thoughts. Manual switchover On backup server run. su – postgres repmgr standby switchover -f /etc/repmgrd_db2.conf –log-to-file Auto-failover db2 is a new master now. Gracefully shutdown db2 server. shutdown -h now Wait for db1 server promotion. …

Fault tolerant PostgreSQL cluster. Part 5. Testing. Ansible. Final thoughts. Read More »