My mail system wasn't working when I got up this morning. I'm running Postfix, (eg my MTA) and dbmail LMTP, (eg Local Mail Transfer Protocol). Dbmail's LMTP hands all mail to PostgreSQL, who insert them into a database named "dbmail". The dbmail tables are highly normalized, and somehow the sequences that auto-increment on almost every tabel's PK fell out of sync with the tables sequences being about 63 increments behind the last actual PKs in the tables. All my incoming mail was being lost due to duplicate PK numbers.
I updated my WebCalendar application yesterday to version WebCalendar-1.2.3. WebCalendar also uses PostgreSQL, so before starting the upgrade I performed a backup of the WebCalendar database. Somewhere along the way, I did a restore of the backup, and upon investigating my problem this morning, I discovered all the WebCalendar tables in my dbmail database. I really had a bad day yesterday. LOL Restoring the WebCalendar tables to the Dbmail Database didn't seem the problem I thought it might be. I just deleted the webCalendar tables from the Dbmail Database, as all the webCalendar tables had names that started with "cal", and webCalendar doesn't use sequences, trigger, functions or anything like that. Anyway, things seem to be mostly working now. I'll watch the logs for awhile, just to see if anything else is screwed up. If so, I may need to run more test. Regards, LelandJ On 09/16/2010 07:27 PM, Grigore Dolghin wrote: > Received ;) > >> -----Original Message----- >> From: [email protected] [mailto:profoxtech- >> [email protected]] On Behalf Of Leland Jackson >> Sent: Friday, September 17, 2010 3:25 AM >> To: [email protected] >> Subject: [NF] test >> >> Another test. >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
