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 »

How to minimize your Docker image. 5 tips and tricks. Example of minifying from 328MB to 56MB.

You can be surprised how much disk space Docker images can consume. In this article we will look at several ways of how to minimize your Docker image. We will build an image with Dante socks server as an example. Dante will not be installed from binary packages, but will be compiled by ourselves inside …

How to minimize your Docker image. 5 tips and tricks. Example of minifying from 328MB to 56MB. Read More »

Multicast Proxy Server

My new OpenSource project. A fast hybrid of Reverse Proxy and Deep Packet Inspection (DPI) written on C.Unlike classic Reverse Proxy, it can redirect client requests to multiple backend servers behind ONE port.The right backend server is selected on-the-fly using DPI of protocol negotiation phase. After selection MPServer acts like a classic Reverse Proxy.In case …

Multicast Proxy Server 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 »