Validates the rcpt_to addresses (recipient addresses) by connecting to a PostgreSQL database.
cd /my/haraka/config/dir
npm install haraka-plugin-rcpt-postgresql
Add the following line to the config/plugins file.
rcpt-postgresql
The rcpt-postgresql.json file has the following structure (defaults shown). Also note that this file will need to be created, if not present, in the config directory.
{ "user": "thihara", "database": "haraka", "password": "", "host": "127.0.0.1", "port": 5432, "max": 20, "idleTimeoutMillis": 30000, "sqlQuery": "SELECT EXISTS(SELECT 1 FROM valid_emails WHERE email_id=1ドル) AS \"exists\"" }