Re: Configuration problems (postfix, dovecot, postgresql, thunderbird)

2017-01-14 Thread /dev/rob0
On Sat, Jan 14, 2017 at 12:34:26PM +0100, Mohamed Maalej wrote: > I installed Postfix and Dovecot on a Ubuntu 16.04 LTS machine. I > used PostgreSQL as a database. > > My configuration .txt file and the issues I found was hosted on > Guthub: > https://github.com/MedMaalej/Postfix-Dovecot-setup

Configuration problems (postfix, dovecot, postgresql, thunderbird)

2017-01-14 Thread Mohamed Maalej
Hi, I installed Postfix and Dovecot on a Ubuntu 16.04 LTS machine. I used PostgreSQL as a database. My configuration .txt file and the issues I found was hosted on Guthub: https://github.com/MedMaalej/Postfix-Dovecot-setup Please advise. Regards, Mohamed Maalej.

Postfix with PostgreSQL backend - number of connections to the database issue

2010-08-27 Thread Adam PAPAI
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I use postfix with postgresql backend using pgsql_virtual_* maps. Is it possible somehow to limit the number of the connections to the postgresql databases? Sometimes the connection number grows up to 30-40. And it uses persistent connection

Re: Postfix with PostgreSQL backend - number of connections to the database issue

2010-08-27 Thread Simon Waters
On Friday 27 August 2010 10:52:46 Adam PAPAI wrote: It seems postfix keeps-up 8-10-15 connections always, but i guess 2 or 3 would be enough. The queries are very quick, so it's not necessary to keep the SQL connection open. The documentation does not mention any part of this issue. Read

Re: Postfix with PostgreSQL backend - number of connections to the database issue

2010-08-27 Thread Adam PAPAI
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 8/27/10 12:24 PM, Simon Waters wrote: Read the documentation concerning proxymap, if all tables are proxied then the connections should be limited by the number of proxymap processes, and all will be efficient. Proxymap will probably solve

Re: Postfix with PostgreSQL

2009-06-03 Thread Charles Marcus
On 6/2/2009, Just E. Mail (justem...@imwell-usa.com) wrote: I am setting up LVS. I have two Real Servers running CentOS, PostgeSQL Client, freeRADIUS, Postfix, etc. Both of the Real Servers access data from the backend PostgreSQL Server. I have setup freeRADIUS application. It authenticates

Re: Postfix with PostgreSQL - CLOSE

2009-06-03 Thread Just E. Mail
I have this posting out for couple of days and many Techies from this mailing list responded with suggestions. I did not understand any one of them because I am a NEWBIE and I was thinking more closed in a SQL box and thinking of Postfix using the backend PGSQL in some what a conventional

Re: Postfix with PostgreSQL - CLOSE

2009-06-03 Thread Victor Duchovni
On Wed, Jun 03, 2009 at 09:05:16AM -0600, Just E. Mail wrote: I have only one more wish; I wish there was a list of all the MAPS used in Postfix? You really don't want this. Less is more. Only define or override Postfix parameters that implement a non-default behaviour you need to control in

Postfix with PostgreSQL

2009-06-02 Thread Just E. Mail
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

Re: Postfix with PostgreSQL

2009-06-02 Thread Magnus Bäck
On Tuesday, June 02, 2009 at 18:28 CEST, Just E. Mail justem...@imwell-usa.com wrote: 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

Re: Postfix with PostgreSQL

2009-06-02 Thread Just E. Mail
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

Re: Postfix with PostgreSQL

2009-06-02 Thread Brian Evans - Postfix List
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

Re: Postfix with PostgreSQL

2009-06-02 Thread Victor Duchovni
On Tue, Jun 02, 2009 at 02:28:34PM -0600, Just E. Mail wrote: 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 Why are you trying to use Postgres with Postfix if you don't actually know what the Postgres

Re: Postfix with PostgreSQL

2009-06-02 Thread Just E. Mail
Victor Duchovni wrote: On Tue, Jun 02, 2009 at 02:28:34PM -0600, Just E. Mail wrote: 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 Why are you trying to use Postgres with Postfix if you don't

Re: Postfix with PostgreSQL

2009-06-02 Thread Victor Duchovni
On Tue, Jun 02, 2009 at 05:24:04PM -0600, Just E. Mail wrote: Start by answering the question: - What data will I be storing in Postgres? - Why Postgres and not a CDB file, or similar? First get Postfix working with simple tools, add complexity slowly. I am setting up LVS. I have two

Postfix with PostgreSQL

2009-05-31 Thread Just E. Mail
I installed postfix-2.6.1 (SRPM from Simon Mudd's web site) on a freshly installed LINUX CentOS 5.3 machine. I followed Roger Mudd's Instructions (see http://postfix.wl0.org/en/building-rpms/). Subsequently,I build a local RPM by following these instructions. I did include PostgreSQL: #

Re: Postfix with PostgreSQL

2009-05-31 Thread Just E. Mail
I reinstalled Postfix with PostgreSQL. This time it seems that PG is included.

Re: Postfix with PostgreSQL

2009-05-31 Thread Barney Desmond
of the same reason; PostgrSQL is not installed with Postfix! 2009/6/1 Just E. Mail justem...@imwell-usa.com: I reinstalled Postfix with PostgreSQL. This time it seems that PG is included. Yep. For the record, you'll need Postgres packages installed before building the Postfix RPM because

Re: Postfix with PostgreSQL

2009-05-19 Thread Just E. Mail
server at the backend to store emails. Now my question: How to build Postfix with PostgreSQL support? I noticed that http://www.postfix.org has example of Postfix PostgreSQL Howto but it is for Postfix installed source (tar.gz?). Is there a similar procedure when Postfix is installed

RE: Postfix with PostgreSQL

2009-05-19 Thread MacShane, Tracy
-Original Message- From: owner-postfix-us...@postfix.org [mailto:owner-postfix-us...@postfix.org] On Behalf Of Just E. Mail Sent: Wednesday, 20 May 2009 10:10 AM To: postfix-users@postfix.org Subject: Re: Postfix with PostgreSQL In my first post, I mentioned that I plan to use

Re: Postfix with PostgreSQL

2009-05-11 Thread Rainer Frey (Inxmail GmbH)
On Saturday 09 May 2009 23:31:43 Just E. Mail wrote: % make -f Makefile.init makefiles \ 'CCARGS=-DHAS_PGSQL -I/usr/local/include/pgsql' \ 'AUXLIBS=-L/usr/local/lib -lpq' Since I have pg Server Client machines, I have no idea where is '-I/usr/local/include/pgsql'

Re: Postfix with PostgreSQL

2009-05-11 Thread Just E. Mail
Rainer: This my school project. I am setting up a new machine with just CentOS 5.3 installed and then I will first install PostgreSQL. Can you kindly give me the name of the files I need to install and in what order. Thank you, Rainer. Jenn Rainer Frey (Inxmail GmbH) wrote: On Saturday

Re: Postfix with PostgreSQL

2009-05-11 Thread Rainer Frey (Inxmail GmbH)
On Monday 11 May 2009 14:43:43 Just E. Mail wrote: Rainer: This my school project. I am setting up a new machine with just CentOS 5.3 installed and then I will first install PostgreSQL. Can you kindly give me the name of the files I need to install and in what order. Thank you, Rainer.

Re: Postfix with PostgreSQL

2009-05-11 Thread Just E. Mail
Rainer: Just to let you know that I have read several times all the documentation you have mentioned. I have also installed the files you suggested in your previous post. The reason I asked for a list of files to install, to make sure that I was installing the correct files. Jennifer PS: I

Re: Postfix with PostgreSQL

2009-05-11 Thread Magnus Bäck
confident in what you're doing, perhaps using a source RPM would be preferable to building Postfix from source (obviously lacking a binary Postfix package with PostgreSQL support). Please do not top-post. -- Magnus Bäck mag...@dsek.lth.se

Re: Postfix with PostgreSQL

2009-05-11 Thread Andrew Ho
You can install all the following packages by using yum. yum -y install postgresql-server postgresql-libs postgresql-devel postgresql-contrib postfix Andrew -- Just E. Mail wrote: Rainer: Just to let you know that I have read several times all the documentation you have mentioned. I have

Re: Postfix with PostgreSQL

2009-05-11 Thread mouss
Just E. Mail a écrit : Rainer: Just to let you know that I have read several times all the documentation you have mentioned. I have also installed the files you suggested in your previous post. The reason I asked for a list of files to install, to make sure that I was installing the correct

Postfix with PostgreSQL

2009-05-09 Thread Just E. Mail
This question is about installing Postfix with PostgreSQL. I am posting on this Forum hoping that somebody has done it and help me out. CentOS 5.3, PostgreSQL-8.3.7, Postfix-2.5.6 I have setup a PostgreSQL Server and PostgreSQL Client under DEFAULT folders. I can connect PostgreSQL Server

Re: Postfix with PostgreSQL

2009-05-09 Thread /dev/rob0
On Sat May 9 2009 16:31:43 Just E. Mail wrote: This question is about installing Postfix with PostgreSQL. I am posting on this Forum hoping that somebody has done it and help me out. CentOS 5.3, PostgreSQL-8.3.7, Postfix-2.5.6 CentOS probably has PostgreSQL in their RPM repository. If so, I

Re: Postfix with PostgreSQL

2009-05-09 Thread Barney Desmond
2009/5/10 Just E. Mail justem...@imwell-usa.com: This question is about installing Postfix with PostgreSQL. I am posting on this Forum hoping that somebody has done it and help me out. Indeed, I've done this before. Enable the centosplus repo, then you can get a build of Postfix with the pgsql