Just E. Mail wrote: > Magnus Bäck wrote: >> 3. On the backend SQL server, what Postfix tables are need? Is there a >> SCHEMA for these tables or they are hand build? >> >> You can choose any schema you like as long as you can construct an >> SQL query that returns the desired data given the input Postfix will >> provide. The input depends on each table; for alias_maps Postfix the >> input is the localpart of the email address, as documented in >> aliases(5). >> > I appreciate if someone can post or email me a sample copy of: > > a. A Schema of Postfix-PGSQL tables/keys > b. A copy of the pgsql-aliases.cf
a. Be creative. Postfix does not care about schema itself. It simply runs the query in the map. b. Modify the example in http://www.postfix.org/PGSQL_README.html to the schema YOU create. This can be named anything. Postfix does not require map files to be named certain things. Brian
