JohnD wrote: > Hi, > > I have been running Postfix 2.5.x on a linux server using virtual > domains with PostgreSQL for a while now and I've just implemented a > basic check_sender_access policy using a hash. Everything works fine, > but now I would like to convert this to an SQL statement and store the > data in the database. > > I've looked through both [1] and [2] but am uncertain as to what the > appropriate query, and table structure, need to be: > > [1] <http://www.postfix.org/pgsql_table.5.html> > http://www.postfix.org/pgsql_table.5.html > [2] http://www.postfix.org/postconf.5.html#smtpd_client_restrictions > > Can someone point me to any documentation to assist me? >
Use the Email Address Patterns for the lookup key sequence in http://www.postfix.org/access.5.html and apply that to the pgsql_table document.. A check sender access will always reference the MAIL FROM given to Postfix. It is up to you and your needs as to what the table will contain and its structure. Brian
