Re: BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Joe Van Dyk <joe(at)tanga(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables
Date: 2013-01-25 08:49:42
Message-ID: CABUevEyYy0H04gHvAnUmaU8YvJT1XOa16ga_xLAHSKa=eMuW+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Sun, Jan 20, 2013 at 4:59 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> + PGresult *res = ExecuteSqlQueryForSingleRow(fout, "SELECT pg_is_in_recovery()");
>
> That function call needs to be schema-qualified for security.

Applied and backpatched, with that fix and a sentence in the
documentation added.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2013-01-25 13:11:43 Re: Re: [BUGS] BUG #7515: DROP TABLE IF EXISTS fails if schema does not exist
Previous Message Kevin Grittner 2013-01-25 06:35:08 Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2013-01-25 10:36:00 Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]
Previous Message Magnus Hagander 2013-01-25 08:49:10 pgsql: Make pg_dump exclude unlogged table data on hot standby slaves