Provide list{addresses,aliases,users,relocated} subcommands The patch provides the list{addresses,aliases,users,relocated} subcommands to the UI. All commands actually take the same path in the code and only one query is run with different parameters for each case. There are still two shortcomings: 1. With alias domains, the output order is not as one might want it, e.g. foo@example.org bar@example.org foo@example.com bar@example.com when it should really be foo@ twice and then bar@ twice. I have not found a way to modify the SQL accordingly. 2. The SELECT queries for Accounts, Alias and Relocated are hard-coded in common.py.

     1

# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS

     2

#

     3

# The hosts that Postfix will try to connect to and query from.

     4

hosts = localhost

     5

     6

# The user name and password to log into the pgsql server.

     7

user = postfix

     8

password = some_password

     9

    10

# The database name on the servers.

    11

dbname = mailsys

    12

    13

# XXX see create_optional_types_and_functions.pgsql

    14

# 	* line  9: type sender_login

    15

# 	* line 26: function postfix_smtpd_sender_login_map + comment above

    16

#

    17

# The SQL query template used to search the database

    18

query = SELECT login FROM postfix_smtpd_sender_login_map('%u', '%d')