Displaying 1 result from an estimated 1 matches for "your_postfix_database_user".
2009 Jan 19
0
Reject message if user is over quota. 2/3 solution for Postfix w/ PostgreSQL
...pient_restrictions =
...
reject_unlisted_recipient
check_recipient_access pgsql:/etc/postfix/virtual_global_quota_check.cf
...
virtual_global_quota_check.cf:
# The hosts that Postfix will try to connect to
hosts = localhost
# The user name and password to log into the pgsql server.
user = $Your_Postfix_database_user
password = $PASSWORD
# The database name on the servers.
dbname = mailsys
# The query
query = SELECT postfix_global_quota_check('%u', '%d', 10485760, 1000)
# quota limit in bytes ----------------------------^
# quota limit in messages --------------------------------...