Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

On Thu, Nov 19, 2015 at 09:01:47AM -0600, Merlin Moncure wrote: > It's quite a stretch to assume that HIPAA applies to internal garbage > collection minutia. It, of course, does. Which is why applying your suggestion ... > A much better way to look at compliance is to encrypt all sensitive >

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

On 11/19/2015 08:50 AM, Day, David wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, November 19, 2015 11:06 AM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead

Re: [GENERAL] Fetching from psql procedures

Hi 2015-11-19 14:51 GMT+01:00 Marc Mamin : > Hi, > > I'm looking for a way to build large xml documents based on a set of > tables, hence using recursive queries. > > > something like: > > FOR rec1 IN ... > FOR rec2 IN ... > > RETURN QUERY select ' > FOR

Re: [GENERAL] controlling memory management with regard to a specific query (or groups of connections)

On Wed, 18 Nov 2015 20:10:00 -0500 Jonathan Vanasco wrote: > As a temporary fix I need to write some uploaded image files to PostgreSQL > until a task server can read/process/delete them. > > The problem I've run into (via server load tests that model our production >

Re: [GENERAL] controlling memory management with regard to a specific query (or groups of connections)

On 11/19/2015 12:29 PM, Bill Moran wrote: On Wed, 18 Nov 2015 20:10:00 -0500 Jonathan Vanasco wrote: As a temporary fix I need to write some uploaded image files to PostgreSQL until a task server can read/process/delete them. The problem I've run into (via server load

[GENERAL] Postgres BDR Conflict Issue

Hi We are setting 4 node BDR replication setup at our end. BDR Version is 0.8.0-2014-12-28-15f97b3. I am continuously getting following logs in the log file. CONFLICT: remote UPDATE on relation public.agents originating at node 6208111525856296403:1:16384 at ts 2015-11-19 00:02:01.861176+05:30;

Re: [GENERAL] Postgres BDR Conflict Issue

On 20 November 2015 at 14:18, vikas452 wrote: > Hi > > We are setting 4 node BDR replication setup at our end. > BDR Version is 0.8.0-2014-12-28-15f97b3. > > I am continuously getting following logs in the log file. > > CONFLICT: remote UPDATE on relation public.agents

Re: [GENERAL] BDR and Backup and Recovery

On 18 November 2015 at 23:46, Will McCormick wrote: > What viable options exist for Backup & Recovery in a BDR environment? From > the reading I have done PITR recovery is not an option with BDR. It's > important to preface this that I have almost no exposure to postgres

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

On 11/19/2015 07:01 AM, Day, David wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, November 18, 2015 4:05 PM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, November 19, 2015 10:32 AM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data. On 11/19/2015

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

On 11/19/2015 07:47 AM, Day, David wrote: So what are you working on? The document you link to starts with this: " Examples of network devices that are covered by requirements in this cPP include routers, firewalls, VPN gateways, IDSs, and switches. ..." So embedded devices. Not sure how

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, November 18, 2015 4:05 PM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data. On 11/18/2015

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

On Wed, Nov 18, 2015 at 3:49 PM, John McKown wrote: > Not necessarily. Think PHI or HIPAA information which was "erased" because > you lost a customer. Or just something as "simple" as a name, address, and > credit card number for someone. It's still important and

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, November 19, 2015 11:06 AM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data. On 11/19/2015

[GENERAL] Fetching from psql procedures

Hi, I'm looking for a way to build large xml documents based on a set of tables, hence using recursive queries. something like: FOR rec1 IN ... FOR rec2 IN ... RETURN QUERY select ' FOR rec3 IN ... RETURN QUERY select (XMLELEMENT (...))::text