Re: Run statements before pg_dump in same transaction?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Run statements before pg_dump in same transaction?
Date: 2017-03-23 19:23:05
Message-ID: ac0cc6cf-637b-bd06-3681-c70993c598b0@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/23/2017 12:06 PM, François Beausoleil wrote:
> For development purposes, we dump the production database to local. It's fine because the DB is small enough. The company's growing and we want to reduce risks. To that end, we'd like to anonymize the data before it leaves the database server.

how about piping the /output/ of pg_dump to GPG or a similar file/stream
encryption module ?

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Armand Pirvu (home) 2017-03-23 21:00:23 audit function and old.column
Previous Message John R Pierce 2017-03-23 19:18:15 Re: Run statements before pg_dump in same transaction?