#
# Sample configuration file for mailbox-count.
#

# The name of the database (or file, if SQLite) to which we should connect.
#
# Default: The name of the current user (Postgres only)
#
# database = "postfixadmin"


# Produce a detailed report listing all mailboxes by domain.
#
# Default: false
#
# detail = true


# SQL query used to produce the detail report. This should return the
# set of all (domain, username) pairs. See the default value for an
# example.
#
# Default: "SELECT domain,username FROM mailbox ORDER BY domain;"
#
# detail_query = "SELECT domain,username FROM mailbox LIMIT 1000;"


# Hostname where the database is located (Postgres-only).
#
# Default: None, a UNIX domain socket connection is attempted (Postgres only)
#
# host = "localhost"


# Password used to connect to the database (Postgres-only).
#
# Default: None (assumes passwordless authentication)
#
# password = "hunter2"


# Port number used to connect to the database (Postgres-only).
#
# Default: None, a UNIX domain socket connection is attempted (Postgres only)
#
# port = 5432


# SQL query used to produce the summary report. This should return
# (domain, user count) pairs. See the default value for an
# example.
#
# Default: "SELECT domain,COUNT(username) FROM mailbox GROUP BY domain ORDER BY domain;"
#
# summary_query = "SELECT domain,COUNT(username) as cnt GROUP BY domain ORDER by cnt;"


# Username used to connect to the database (Postgres-only).
#
# Default: The current user
#
# username = "postgres"