Re: FPW compression leaks information - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: FPW compression leaks information
Date
Msg-id 20150409160739.GC3663@tamriel.snowman.net
Whole thread Raw
In response to Re: FPW compression leaks information  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: FPW compression leaks information
List pgsql-hackers
* Heikki Linnakangas (hlinnaka@iki.fi) wrote:
> On 04/09/2015 06:28 PM, Stephen Frost wrote:
> >* Heikki Linnakangas (hlinnaka@iki.fi) wrote:
> >>What should we do about this? Make it configurable on a per-table
> >>basis? Disable FPW compression on system tables? Disable FPW on
> >>tables you don't have SELECT access to? Add a warning to the docs?
> >
> >REVOKE EXECUTE ON FUNCTION pg_current_xlog_insert_location() FROM public;
>
> Yeah, that's one option. Will also have to revoke access to
> pg_stat_replication and anything else that might indirectly give
> away the current WAL position.

Sure, though pg_stat_replication already only returns the PID and no
details, unless you're a superuser.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: FPW compression leaks information
Next
From: Alvaro Herrera
Date:
Subject: Re: deparsing utility commands