myhostname = test.post.kz
mydomain = test.domain.com
myorigin = $mydomain
mydestination = $mydomain
relayhost =
mynetworks =172.30.73.0/24,127.0.0.0/8 10.0.0.0/8
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
debug_peer_list = 127.0.0.1
mailbox_transport = lmtp:unix:private/dovecot-lmtp
alias_maps = proxy:pgsql:/etc/postfix/pgsql-aliases.cf
local_recipient_maps = proxy:pgsql:/etc/postfix/pgsql-boxes.cf
virtual_alias_maps = $alias_maps

user=***
dbname=***
query = SELECT replace(email,'@domain.com','@test.domain.com') FROM aliases WHERE alias=replace('%s','@test.domain.com','@domain.com')
#query = SELECT replace(email,'@domain.com','@test.domain.com') FROM aliases WHERE alias='%s'
hosts=127.0.0.1
password=***

user=***
dbname=***
query = SELECT replace(email,'@domain.com','@test.domain.com') FROM users WHERE email=replace('%s','@test.domain.com','@domain.com')
hosts=127.0.0.1
password=***

driver = pgsql
connect = host=127.0.0.1 dbname=*** user=***password=***
password_query = SELECT replace(email,'@domain.com','@test.domain.com') as user, password FROM users WHERE email = replace('%u','@test.domain.com','@domain.com')
user_query = SELECT replace(email,'@domain.com','@test.domain.com') as user, 'maildir:/home/mailboxes/maildir/'||maildir as mail, '/home/mailboxes/home/'||maildir as home, 500 as uid, 500 as gid FROM users WHERE email = replace('%u','@test.domain.com','@domain.com')