Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to know if my Postfix supports MySQL and PostgreSQL?

356 views
Skip to first unread message

Andre Lopes

unread,
Feb 3, 2012, 5:55:21 AM2/3/12
to
Hi,

I'm using CentOS6 that comes with Postfix "mail_version = 2.6.6". I
need to know if my Postfix supports MySQL and PostgreSQL to a
virtualhost/virtualusers configuration. How can know if my Postfix
supports MySQL and PostgreSQL?

Best Regards,

Laurent RAYSSIGUIER

unread,
Feb 3, 2012, 5:57:53 AM2/3/12
to
Hello,
postconf -c /etc/postfix -m

I know that since yesterday :-)

Best regards
Laurent

Pinter Tibor

unread,
Feb 3, 2012, 5:58:41 AM2/3/12
to
On 02/03/2012 11:55 AM, Andre Lopes wrote:
> Hi,
>
> I'm using CentOS6 that comes with Postfix "mail_version = 2.6.6". I
> need to know if my Postfix supports MySQL and PostgreSQL to a
> virtualhost/virtualusers configuration. How can know if my Postfix
> supports MySQL and PostgreSQL?
>
> Best Regards,
# /usr/sbin/postconf -m

t

Andre Lopes

unread,
Feb 3, 2012, 6:01:51 AM2/3/12
to
Thanks for the reply's,

The output is:

[root@mailserver ~]# postconf -c /etc/postfix -m
btree
cidr
environ
hash
ldap
mysql
nis
pcre
proxy
regexp
static
unix

How can I add PostgreSQL support?

Best Regards,

Laurent RAYSSIGUIER

unread,
Feb 3, 2012, 6:11:11 AM2/3/12
to
> How can I add PostgreSQL support?
root@smtp:~# aptitude search postfix |grep pgsq
p postfix-pgsql - PostgreSQL map support for Postfix


/dev/rob0

unread,
Feb 3, 2012, 6:27:13 AM2/3/12
to
On Fri, Feb 03, 2012 at 12:11:11PM +0100, Laurent RAYSSIGUIER wrote:
Andre:
> > How can I add PostgreSQL support?
> root@smtp:~# aptitude search postfix |grep pgsq
> p postfix-pgsql - PostgreSQL map support for Postfix

A Debian-specific answer might not be of much use to CentOS users.

For CentOS support, see CentOS documentation and support forums.

The Postfix answer: http://www.postfix.org/PGSQL_README.html
--
http://rob0.nodns4.us/ -- system administration and consulting
Offlist GMX mail is seen only if "/dev/rob0" is in the Subject:

Andre Lopes

unread,
Feb 3, 2012, 6:50:07 AM2/3/12
to
Thanks for all reply's. I will use MySQL. CentOS6 don´t have any
usable RPM to PostgreSQL and many users out there had troubles
recompiling Postfix with pgsql support.

Thanks for the help.

Best Regards,


On Fri, Feb 3, 2012 at 10:59 AM, <lst_...@kwsoft.de> wrote:
> Zitat von Andre Lopes <lopes8...@gmail.com>:
>
>
>> Hi,
>>
>> I'm using CentOS6 that comes with Postfix "mail_version = 2.6.6". I
>> need to know if my Postfix supports MySQL and PostgreSQL to a
>> virtualhost/virtualusers configuration. How can know if my Postfix
>> supports MySQL and PostgreSQL?
>
>
> postconf -m is your friend. You might need to install some postfix-xxx
> package to get the map types desired.
>
> Regards
>
> Andreas
>
>
>

Peter

unread,
Feb 3, 2012, 6:31:47 PM2/3/12
to
On 04/02/12 00:50, Andre Lopes wrote:
> Thanks for all reply's. I will use MySQL. CentOS6 don´t have any
> usable RPM to PostgreSQL and many users out there had troubles
> recompiling Postfix with pgsql support.

If you rebuild the RPM with these lines in your .rpmmacros file you will
have both postgresql and mysql support:
%MYSQL 1
%PGSQL 1


Peter

0 new messages