[rt-users] Recovery Assistance

Jesse Vincent jesse at bestpractical.com
Mon Nov 15 16:27:27 EST 2010




On Mon, Nov 15, 2010 at 04:24:22PM -0500, Josh Narins wrote:
> Through admin error, during a practice migration of Postgres to Oracle[1], about 5% of the GroupMembers table was deleted[2].

Is the cached-group-members table intact? You can likely recover all the data from that, though I'm late for a plane. Someone else may be able to recommend exact steps to do so.
 
> 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?

rt-validator


> 
> 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.

-- 



More information about the rt-users mailing list