Through admin error, during a practice migration of Postgres to Oracle[1], about 5% of the GroupMembers table was deleted[2].
So far, things have been working fine. It was all recent changes, a few of which I was able to remember. However, one user is experiencing odd behavior likely linked to the mis-step. I recall reading about a database integrity check available, but searching the web and the RT wiki doesn't yield any positive hits. Am I misremembering reading about an integrity tool? Thanks in advance, Josh [1] We already are paying an Oracle DBA for system monitoring, backups, etc, and don't have any other Postgres applications. [2] It failed 95% of the way through, then I deleted from the source, rather than the target. I was able to copy ~76400 rows back to the table which originally had ~80400. Josh Narins Director of Application Development SeniorBridge 845 Third Ave 7th Floor New York, NY 10022 Tel: (212) 994-6194 Fax: (212) 994-4260 Mobile: (917) 488-6248 [email protected] seniorbridge.com<http://www.seniorbridge.com/> [http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif] ________________________________ SeniorBridge Statement of Confidentiality: The contents of this email message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. Any dissemination, distribution or copying of this email by an unintended or mistaken recipient is strictly prohibited. In said event, kindly reply to the sender and destroy all entries of this message and any attachments from your system. Thank you.
