Database

About distribution, hashing and target segment number calculation in GPDB 5x.

In GPDB 5x, table’s data can be distributed RANDOMLY or by set of columns. The essential parts of column-based distribution are: hashing target segment number calculation I will try to dig into them in this article. To hash, or not to hash (on dispatcher), that is the question. Based on logic and common sense, you …

About distribution, hashing and target segment number calculation in GPDB 5x. Read More »

DBMail over PostgreSQL + Postfix + SASL on Debian. Part 5. SPF. DKIM. DMARC. Clear headers. DNS PTR.

Part 1. Introduction.Part 2. DBMail.Part 3. Postfix.Part 4. SASL.Part 5. SPF. DKIM. DMARC. Clear headers. DNS PTR. SPF Sender Policy Framework is an email authentication method designed to detect forged sender addresses in emails (email spoofing). SPF allows the receiver to check that an email claiming to come from a specific domain comes from an …

DBMail over PostgreSQL + Postfix + SASL on Debian. Part 5. SPF. DKIM. DMARC. Clear headers. DNS PTR. Read More »

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

Part 1. Introduction.Part 2. DBMail.Part 3. Postfix.Part 4. SASL.Part 5. SPF. DKIM. DMARC. Clear headers. DNS PTR. Install SASL. apt install libsasl2-modules sasl2-bin Add postfix user to sasl group. adduser postfix sasl Create /etc/postfix/sasl/smtpd.conf file. pwcheck_method: saslauthd mech_list: PLAIN LOGIN Edit /etc/default/saslauthd file. START=yes DESC=”SASL Authentication Daemon” NAME=”saslauthd” MECHANISMS=”rimap” MECH_OPTIONS=”localhost” THREADS=5 OPTIONS=”-c -m /var/spool/postfix/var/run/saslauthd -r” …

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

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

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.

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 »