2 # Sample configuration file for list-remote-forwards.
5 # The name of the database (or file, if SQLite) to which we should connect.
7 # Default: The name of the current user (Postgres only)
9 # database = "postfixadmin"
12 # SQL query used to produce a list of local domains. This should return
13 # the set of all domains (i.e one column) that are local to the
14 # server. See the default value for an example.
16 # Default: "SELECT domain FROM domain WHERE domain <> 'ALL' ORDER BY domain;"
18 # domain_query = "SELECT DISTINCT domain FROM alias;"
21 # SQL query used to produce a list of all forwards on the mail
22 # system. This query should return the set of all (address, goto)
23 # triples, where "goto" is the destination address; i.e. to where
24 # the "address" forwards. The "goto" field may contain more
25 # than one email address, separated by commas.
27 # Default: "SELECT address,goto FROM alias ORDER BY address;"
29 # forward_query = "SELECT address,alias FROM aliases;"
33 # Hostname where the database is located (Postgres-only).
35 # Default: None, a UNIX domain socket connection is attempted (Postgres only)
40 # Password used to connect to the database (Postgres-only).
42 # Default: None (assumes passwordless authentication)
44 # password = "hunter2"
47 # Port number used to connect to the database (Postgres-only).
49 # Default: None, a UNIX domain socket connection is attempted (Postgres only)
55 # Username used to connect to the database (Postgres-only).
57 # Default: The current user
59 # username = "postgres"