Re: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl

From: Martin Pitt <martin(at)piware(dot)de>
To: 372115(at)bugs(dot)debian(dot)org, Olivier Bornet <Olivier(dot)Bornet(at)puck(dot)ch>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Cc: Olivier Bornet <Olivier(dot)Bornet(at)puck(dot)ch>
Subject: Re: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl
Date: 2006-06-27 20:28:51
Message-ID: 20060627202850.GA5160@piware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi PostgreSQL gurus, hi Olivier,

Martin Pitt [2006-06-16 0:15 +0200]:
> Upstream confirmed my reply in the last mail in [1]: the complete
> escaping logic in DBMirror.pl is seriously screwew.
>
> [1] http://archives.postgresql.org/pgsql-bugs/2006-06/msg00065.php

I finally found some time to debug this, and I think I found a better
patch than the one you proposed. Mine is still hackish and is still a
workaround around a proper quoting solution, but at least it repairs
the parsing without introducing the \' quoting again.

I consider this a band-aid patch to fix the recent security update.
PostgreSQL gurus, would you consider applying this until a better
solution is found for DBMirror.pl?

Olivier, can you please confirm that the patch works for you, too?

Thank you,

Martin

--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

Attachment Content-Type Size
DBMirror.pl-fixquoteparsing.diff text/plain 469 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-06-27 22:21:01 Re: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl
Previous Message marcin.mank 2006-06-27 18:24:34 BUG #2500: subscribing for digest