--- 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'
--- 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')
--- 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'
--- 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'
--- 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'
--- 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'
--- 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'
--- 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'