Dirk, >Yet I wonder about the number of DB >connections. ASSP opens 133 connections to the postgresql database right >from the start, even without any mail traffic. Is it a bug or a feature? :-) >I did not find a place where I could tune this.
This is normal - every thread opens and holds a DB connection to every table - this could not be changed or tuned and is needed to get realy fast access to the DB. >'Pg' => [qw/ bytea bytea int 0 0 /], I've never used Pg - so sorry for the wrong definition of the data type. Be care full - there is no special import definition for Pg in the file 'assp_db_import.cfg' ! If the 'postgresql database (V 8.3.8)' fully supports ANSI-SQL-92 or supports the same SQL-language like any of the defined, this should not be a problem. If not, a definition record must be defined in this file to do a bulk-import from flat files. An other possible option is to set 'preventBulkImport' to on, this prevents assp from doing a bulk import - instead a record by record import will be done, which takes in the most case much-much more longer. Thomas "Dirk Kulmsee" <d.kulm...@netgroup.de> 23.11.2009 13:51 Bitte antworten an ASSP development mailing list <assp-test@lists.sourceforge.net> An "'ASSP development mailing list'" <assp-test@lists.sourceforge.net> Kopie Thema [Assp-test] 2.01_RC0.5.26 and Postgresql DB Hi all, I installed ASSP 2.01 RC 0.5.26 on Debian Lenny. The mail user accounts are held in a postgresql database (V 8.3.8), so I decided to stay with postgresql for ASSP's tables. On startup ASSP falls back to files instead of database tables and I find errors like these in my postgres.log: 2009-11-22 21:30:30 CET FEHLER: Typ »varbinary« existiert nicht bei Zeichen 33 2009-11-22 21:30:30 CET ANWEISUNG: create table whitelist (pkey varbinary(254) primary key,pvalue varbinary(255)) This "varbinary" apparently does not exist with Postgresql. I dared change line 6022 in assp.pl from: 'Pg' => [qw/ varbinary(254) varbinary(255) int 0 0 /], to 'Pg' => [qw/ bytea bytea int 0 0 /], This way I get ASSP up and running. Yet I wonder about the number of DB connections. ASSP opens 133 connections to the postgresql database right from the start, even without any mail traffic. Is it a bug or a feature? :-) I did not find a place where I could tune this. Best regards Dirk Kulmsee ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test DISCLAIMER: ******************************************************* This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. This email was multiple times scanned for viruses. There should be no known virus in this email! ******************************************************* ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
