Re: COPYable logs status

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: COPYable logs status
Date: 2007-06-08 13:43:55
Message-ID: 20070608134355.GF9071@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Martijn van Oosterhout wrote:
> On Fri, Jun 08, 2007 at 08:31:54AM -0400, Andrew Dunstan wrote:
> > The situation with this patch is that I now have it in a state where I
> > think it could be applied, but there is one blocker, namely that we do
> > not have a way of preventing the interleaving of log messages from
> > different backends, which leads to garbled logs. This is an existing
> > issue about which we have had complaints, but it becomes critical for a
> > facility the whole purpose of which is to provide logs in a format
> > guaranteed to work with our COPY command.
>
> The whole semantics of PIPEBUF should prevent garbling, as long as each
> write is a complete set of lines and no more than PIPEBUF bytes long.
> Have we determined the actual cause of the garbling?

No, that's the main problem -- but it has been reported to happen on
entries shorter than PIPE_BUF chars.

--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
"La persona que no quería pecar / estaba obligada a sentarse
en duras y empinadas sillas / desprovistas, por cierto
de blandos atenuantes" (Patricio Vogel)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew O'Connor 2007-06-08 13:49:56 Re: Autovacuum launcher doesn't notice death of postmaster immediately
Previous Message Martijn van Oosterhout 2007-06-08 13:35:12 Re: COPYable logs status

Browse pgsql-patches by date

  From Date Subject
Next Message Matthew O'Connor 2007-06-08 13:49:56 Re: Autovacuum launcher doesn't notice death of postmaster immediately
Previous Message Martijn van Oosterhout 2007-06-08 13:35:12 Re: COPYable logs status