32
32
/* obtain main.cf configuration parameters for this search.
34
34
/* In the first case, the configuration parameters below are
35
/* specified in the file as \fIname\fR=\fBvalue\fR pairs.
35
/* specified in the file as \fIname\fR=\fIvalue\fR pairs.
37
37
/* In the second case, the configuration parameters are
38
38
/* prefixed with the value of \fIname\fR and an underscore,
50
50
/* Configuration parameters:
52
/* The parameters encode a number of pieces of information:
53
/* username, password, databasename, table, select_field,
54
/* where_field, and hosts:
56
52
/* Username for connecting to the database.
58
54
/* Password for the above.
60
56
/* Name of the database.
62
58
/* Query template. If not defined a default query template is constructed
63
59
/* from the legacy \fIselect_function\fR or failing that the \fItable\fR,
64
60
/* \fIselect_field\fR, \fIwhere_field\fR, and \fIadditional_conditions\fR
65
61
/* parameters. Before the query is issues, variable substitutions are
66
62
/* performed. See pgsql_table(5).
68
64
/* List of domains the queries should be restricted to. If
69
65
/* specified, only FQDN addresses whose domain parts matching this
70
66
/* list will be queried against the SQL database. Lookups for
71
67
/* partial addresses are also supressed. This can significantly
72
68
/* reduce the query load on the server.
73
/* .IP \fIresult_format\fR
74
70
/* The format used to expand results from queries. Substitutions
75
71
/* are performed as described in pgsql_table(5). Defaults to returning
76
72
/* the lookup result unchanged.
79
75
/* exceed the limit fail with dict_errno=DICT_ERR_RETRY. Note that each
80
76
/* non-empty (and non-NULL) column of a multi-column result row counts as
82
/* .IP \fIselect_function\fR
78
/* .IP select_function
83
79
/* When \fIquery\fR is not defined, the function to be used instead of
84
80
/* the default query based on the legacy \fItable\fR, \fIselect_field\fR,
85
81
/* \fIwhere_field\fR, and \fIadditional_conditions\fR parameters.
87
83
/* When \fIquery\fR and \fIselect_function\fR are not defined, the name of the
88
84
/* FROM table used to construct the default query template, see pgsql_table(5).
89
/* .IP \fIselect_field\fR
90
86
/* When \fIquery\fR and \fIselect_function\fR are not defined, the name of the
91
87
/* SELECT field used to construct the default query template, see pgsql_table(5).
92
/* .IP \fIwhere_field\fR
93
89
/* When \fIquery\fR and \fIselect_function\fR are not defined, the name of the
94
90
/* WHERE field used to construct the default query template, see pgsql_table(5).
95
/* .IP \fIadditional_conditions\fR
91
/* .IP additional_conditions
96
92
/* When \fIquery\fR and \fIselect_function\fR are not defined, the name of the
97
93
/* additional text to add to the WHERE field in the default query template (this
98
94
/* usually begins with "and") see pgsql_table(5).
100
96
/* List of hosts to connect to.
102
98
/* For example, if you want the map to reference databases of
107
103
/* "postfix" and password "passwd" then the configuration file
110
/* \fIuser\fR = \fBpostfix\fR
112
/* \fIpassword\fR = \fBpasswd\fR
114
/* \fIdbname\fR = \fBpostfix_info\fR
116
/* \fItable\fR = \fBaliases\fR
118
/* \fIselect_field\fR = \fBforw_addr\fR
120
/* \fIwhere_field\fR = \fBalias\fR
122
/* \fIhosts\fR = \fBhost1.some.domain\fR \fBhost2.some.domain\fR
110
/* dbname = postfix_info
114
/* select_field = forw_addr
116
/* where_field = alias
118
/* hosts = host1.some.domain\fR \fBhost2.some.domain
125
121
/* dict(3) generic dictionary manager
added
removed
src/global/dict_pgsql.c
