Displaying 1 result from an estimated 1 matches for "postfix_global_quota_check".
2009 Jan 19
0
Reject message if user is over quota. 2/3 solution for Postfix w/ PostgreSQL
......
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 -----------------------------------^
SQL:
CREATE OR REPLACE FUNCTION postfix_global_quota_check(
IN localpart varchar, IN the_domain varchar,
IN q_stor...