# -------
# p-alias
# -------
hosts=10.0.0.123
port=6432
dbname=mail
user=user1
password=password
query=SELECT destination FROM v_alias WHERE source = '%s'

console:~$ postmap -q test@testy.net pgsql:/etc/postfix/p-alias

tester.mc_testy_tester@test_email_address.com

console:~$ cp /etc/postfix/p-alias /etc/postfix/p-alias2
console:~$ vi /etc/postfix/p-alias2

# -------
# p-alias2
# -------
hosts=localhost
port=6432
dbname=mail
user=user1
password=password
query=SELECT destination FROM v_alias WHERE source = '%s'

console:~$ postmap -q test@testy.net pgsql:/etc/postfix/p-alias2

postmap: warning: connect to pgsql server localhost: could not connect to server: Connection refused??
Is the server running on host "localhost" (::1) and accepting??
TCP/IP connections on port 5432??
could not connect to server: Connection refused??
Is the server running on host "localhost" (127.0.0.1) and accepting??
TCP/IP connections on port 5432??
postmap: fatal: table pgsql:/etc/postfix/p-alias2: query error: Operation now in progress

client = yes
pid = /var/run/stunnel.pid
cert = /etc/stunnel/stnl.pem
[pgbouncer]
        protocol = pgsql
        accept = 6433
        connect = 10.0.0.123:6434

pid = /var/run/stunnel.pid
cert = /etc/stunnel/stnl.pem

...

[pgbouncer]
        protocol = pgsql
        accept = 6434
        connect = 5432

# -------
# p-alias3
# -------
hosts=127.0.0.1
port=6433
dbname=mail
user=user1
password=password
query=SELECT destination FROM v_alias WHERE source = '%s'

console:~$ postmap -q test@testy.net pgsql:/etc/postfix/p-alias3
postmap: warning: connect to pgsql server 127.0.0.1: could not connect to server: Connection refused??
Is the server running on host "127.0.0.1" and accepting??
TCP/IP connections on port 5432??
postmap: fatal: table pgsql:/etc/postfix/p-alias3: query error: Operation now in progress

# -------
# p-alias4
# -------
hosts=10.0.0.123
port=6434
dbname=mail
user=user1
password=password
query=SELECT destination FROM v_alias WHERE source = '%s'

console:~$ postmap -q test@testy.net pgsql:/etc/postfix/p-alias4
tester.mc_testy_tester@test_email_address.com

[databases]

; ...
;mail = host=localhost port=6433 dbname=mail
mail = host=10.0.0.123 port=5432 dbname=mail

[pgbouncer]

listen_addr = *
listen_port = 6432

; ...

auth_type = md5

auth_file = /etc/pgbouncer/userlist.txt


pool_mode = transaction

server_reset_query = DISCARD ALL

server_check_query = SELECT 1

server_check_delay = 30

; ...