From: Brian Evans - Postfix List (grknightscent-team.com)
Date: Tue Jun 02 2009 - 15:52:34 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]