On Tue, 2007-04-17 at 19:56 +0200, Mark Martinec wrote: > Robert, > > > I am trying to setup storage in our PgSQL database using the following > > doc, but I am not sure which schemas are to be loaded in which > > databases. I assume I am to cut/paste the necessary CREATE TABLE > > sections as the schema to use? But which tables should be created in > > mail_logs and which for mail_prefs? > > http://www.ijs.si/software/amavisd/README.sql-pg.txt > > Yes, you can cut/paste the schemas as-is from this readme file. > > The database in @lookup_sql_dsn needs the read-only tables, > i.e. the users, mailaddr, wblist, policy. > > The database in @storage_sql_dsn needs the read/write tables, > i.e. the maddr, msgs, msgrcpt, quarantine. > > Both the @lookup_sql_dsn and the @storage_sql_dsn may point > to the same database, so in this case you would place > all tables in the same database. Name it whatever you want. >
Thanks, that clarified a lot, and WORKS! I had one other question. I see it logs the from address and client ip, but is there any way to get it to log recipient server and e-mail address? -- Robert ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
