# HG changeset patch # User Pascal Volk # Date 1250042027 0 # Node ID 0332b85f55e12ebbb902a8e54bb15b1de6856831 # Parent c0b5afb890881654a4719cecae6dd3bd142ed234 Updated Postfix PostgreSQL client configuration files diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-relocated_maps.cf --- a/pgsql-relocated_maps.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-relocated_maps.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,5 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). +# The SQL query template used to search the database query = SELECT destination FROM postfix_relocated WHERE address='%s' diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-smtpd_sender_login_maps.cf --- a/pgsql-smtpd_sender_login_maps.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-smtpd_sender_login_maps.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,9 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). -query = SELECT login FROM postfix_smtpd_sender_login_map('%u', '%d') +# XXX see create_optional_types_and_functions.pgsql +# * line 9: type sender_login +# * line 26: function postfix_smtpd_sender_login_map + comment above +# +# The SQL query template used to search the database +#query = SELECT login FROM postfix_smtpd_sender_login_map('%u', '%d') diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-transport.cf --- a/pgsql-transport.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-transport.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,5 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). +# The SQL query template used to search the database query = SELECT transport FROM postfix_transport WHERE address='%s' diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-virtual_alias_maps.cf --- a/pgsql-virtual_alias_maps.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-virtual_alias_maps.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,5 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). +# The SQL query template used to search the database query = SELECT destination FROM postfix_alias WHERE address='%s' diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-virtual_gid_maps.cf --- a/pgsql-virtual_gid_maps.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-virtual_gid_maps.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,5 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). +# The SQL query template used to search the database query = SELECT gid FROM postfix_gid WHERE domainname='%d' diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-virtual_mailbox_domains.cf --- a/pgsql-virtual_mailbox_domains.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-virtual_mailbox_domains.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,5 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). -query = SELECT gid FROM postfix_gid WHERE domainname = '%s' +# The SQL query template used to search the database +query = SELECT gid FROM postfix_gid WHERE domainname='%s' diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-virtual_mailbox_maps.cf --- a/pgsql-virtual_mailbox_maps.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-virtual_mailbox_maps.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,5 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). +# The SQL query template used to search the database query = SELECT maildir FROM postfix_maildir WHERE address='%s' diff -r c0b5afb89088 -r 0332b85f55e1 pgsql-virtual_uid_maps.cf --- a/pgsql-virtual_uid_maps.cf Mon Aug 10 03:29:52 2009 +0000 +++ b/pgsql-virtual_uid_maps.cf Wed Aug 12 01:53:47 2009 +0000 @@ -1,5 +1,7 @@ -# The hosts that Postfix will try to connect to -hosts = host1.some.domain host2.some.domain +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost # The user name and password to log into the pgsql server. user = postfix @@ -8,5 +10,5 @@ # The database name on the servers. dbname = mailsys -# Postfix 2.2 and later The SQL query template. See pgsql_table(5). +# The SQL query template used to search the database query = SELECT uid FROM postfix_uid WHERE address='%s'