OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Postfix with PostgreSQL

From: Just E. Mail (justemailimwell-usa.com)
Date: Tue Jun 02 2009 - 11:28:02 CDT


CentOS 5.3
PostgreSQL 8.3.7
Postfix 2.6.1

I have setup a Postfix Mail Server & tested it. Now I am trying to setup
Postfix with PostgreSQL as backend. I did build (by following Simon
Mudd's instructions) Postfix with PGSQL support. I have done
considerable reading and searched the Internet, but I need help me with
the following questions:

1. I have read 'man psql_table' & 'Postfix PostgreSQL Howto' (at
www.postfix.org). The first document says that the 'alias_maps' are
located at 'etc/pgsql-aliase' and the second document says that they are
at 'etc/postfix/pgsql-aliases.cf'. I assume that 'pgsql-aliases.cf' can
be in either folder as long as it is similarly listed in
'/etc/postfix/main.cf'. Am I corrent or not?

2. I have not found the DEFAULT file 'pgsql-aliases.cf' anywhere on the
Postfix server. Do I need to build it myself?

3. On the backend SQL server, what Postfix tables are need? Is there a
SCHEMA for these tables or they are hand build?

Considering I am a NEWBIE, your help is highly appreciated.

Jennifer K.