melissa

miel.colmena.biz || melissa.colmena.biz

"melissa" is technically a bee. at a "beehive" domain. get over it.

backup mx and database server for www.colmena.biz

Powered by Postfix Powered by PostgreSQL
[ Powered by nginx ] Powered by Fedora GNU/Linux
Powered by Vultr
http:// || https://

the elephant in the room

HowTo/DovecotPostgresql
POSTFIX, DOVECOT AND POSTGRESQL SETUP
How To Set Up a Postfix Email Server with Dovecot: Dynamic Maildirs and LMTP
Postfix Gateway with PostgreSQL
Postfix PostgreSQL Howto
PostgreSQL+Postfix+Nginx+PHP+RoundCube+Dovecot+ SpamAssassin+Clamav+Spamd

postgresql://justina_lectora:DRz2eqtsO1msKr3Pw6N2WkbSwkJU@db.colmena.biz/justina?sslmode=verify-full
(read-only access for the curious — i find it is not necessary to specify username or password for the connection; these are already specified in the url ‐ if your PostgreSQL client has trouble verifying the certficate, it is proabably looking for a trusted root certificate in "~/.postgresql/root.crt ‐ which is usually located somewhere else on your system such as /etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt for fedora — even on Microsoft Windows you will have a trusted root certificate bundle somewhere — just copy it over, or better yet, make a link or shortcut to that file so that your PostgreSQL client can find it)