Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Run statements before pg_dump in same transaction? - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Run statements before pg_dump in same transaction?
Date
Msg-id ac0cc6cf-637b-bd06-3681-c70993c598b0@hogranch.com
Whole thread Raw
In response to [GENERAL] Run statements before pg_dump in same transaction?  (François Beausoleil <francois@teksol.info>)
Responses Re: [GENERAL] Run statements before pg_dump in same transaction?
List pgsql-general
Tree view 
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'sgrowing and we want to reduce risks. To that end, we'd like to anonymize the data before it leaves the
databaseserver. 

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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Run statements before pg_dump in same transaction?
Next
From: "Armand Pirvu (home)"
Date:
Subject: [GENERAL] audit function and old.column