driver = pgsql
connect = host=db.lxc.br0tkasten.de dbname=users user=mail
default_pass_scheme = PLAIN-MD5

#user_query = SELECT home, uid, gid FROM users WHERE userid = '%n'
user_query = SELECT r.home, r.uid, r.gid FROM users r, users v WHERE v.userid = '%n' AND v.realuser = r.userid
password_query = SELECT realuser as user, '{PLAIN-MD5}' || password as password FROM users WHERE userid = '%n'