Test your spell checker next. --- On Thu, 9/16/10, Leland Jackson <[email protected]> wrote:
> From: Leland Jackson <[email protected]> > Subject: Re: [NF] test > To: "ProFox Email List" <[email protected]> > Date: Thursday, September 16, 2010, 9:15 PM > 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.
