Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-committers <pgsql-committers(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves
Date: 2013-01-25 13:43:19
Message-ID: CA+TgmoZ2PGbWU27_XQf6iG1yBX4HCV6Tkk4MBa3v=+7Zx06opQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Fri, Jan 25, 2013 at 8:01 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Fri, Jan 25, 2013 at 1:59 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
>> On 2013-01-25 13:56:11 +0100, Magnus Hagander wrote:
>>> On Fri, Jan 25, 2013 at 1:31 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
>>> > On 2013-01-25 08:49:10 +0000, Magnus Hagander wrote:
>>> >> Make pg_dump exclude unlogged table data on hot standby slaves
>>> >
>>> > This missed the fact that there is no ExecuteSqlQueryForSingleRow and
>>> > surroundign infrastructure.
>>>
>>> Ugh, that's what I get for pushing something just before getting on a
>>> plane. Thanks for spotting.
>>>
>>> Fix looks good, except I'd just put the query text inline in PQexec()
>>> and not bother with a separate variable..
>>
>> The query needs to get passed to check_sql_result and write_msg as well,
>> thats why I added the extra variable.
>
> Ahh, gotcha.
>
>
>> I don't think my -committers post got through (seems to be restricted),
>> so I am CCing -hackers so somebody else can see the patch.
>
> Ok! I just talked to Robert, and he's taking a look at it for me.

Committed.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2013-01-25 15:00:52 pgsql: Add some randomness to the choice of which GiST page to insert t
Previous Message Robert Haas 2013-01-25 13:43:06 pgsql: Eliminate use of ExecuteSqlQueryForSingleRow, which is not in 9.

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-01-25 13:47:51 Re: SYSV shared memory vs mmap performance
Previous Message Bruce Momjian 2013-01-25 13:40:20 Re: SYSV shared memory vs mmap performance