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