[rt-users] Recovery Assistance

Josh Narins jnarins at seniorbridge.com
Mon Nov 15 16:24:22 EST 2010


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
jnarins at seniorbridge.com
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20101115/3cc913ce/attachment.htm>


More information about the rt-users mailing list