On Sat, Apr 15, 2006 at 06:38:58PM -0700, Nagita Karunaratne wrote:
> On a regular basis I wish to download this data onto a local copy of
> the database (running on a local PC) and delete the sensitive parts of
> the records on the hosted database. The hosted DB will still contain
> certain non-sensitive data.
>
> Is there a standard way to do this?
>
> Will the slony project be of any help?
The way I would do this is to use the log shipping features of Slony,
and add a trigger on the target machine (where you want the sensitive
data suppressed) that obfuscated the data in the target database --
set it to NULL, perhaps, or (better) altered it to indicate it was
suppressed.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
