Re: BUG #7521: Cannot disable WAL log while using pg_dump - Mailing list pgsql-bugs

From Boy de Laat
Subject Re: BUG #7521: Cannot disable WAL log while using pg_dump
Date
Msg-id 6542094C-D8DC-4F96-B989-B1445103ADBF@atsc.nl
Whole thread Raw
In response to Re: BUG #7521: Cannot disable WAL log while using pg_dump  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: BUG #7521: Cannot disable WAL log while using pg_dump  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
At the time my backup starts i see much WAL logs being generated?

Met vriendelijke groet,

Boy de Laat

Verzonden via iPhone

Op 6 sep. 2012 om 21:44 heeft "Robert Haas" <robertmhaas@gmail.com> het
volgende geschreven:

> On Wed, Sep 5, 2012 at 9:57 AM,  <boy@atsc.nl> wrote:
> > The following bug has been logged on the website:
> >
> > Bug reference:      7521
> > Logged by:          Boy de Laat
> > Email address:      boy@atsc.nl
> > PostgreSQL version: 9.1.4
> > Operating system:   CentOS 6.2 x86_64
> > Description:
> >
> > I've setup some slave replication and just to be sure i use pg_dump as
a
> > backup mechanism besides replication. But when the pg_dump command is
issued
> > much WAL logs will be generated and this is causing my slave to stop
> > replicating because it is to far behind.
> >
> > So it would be nice if there is an option to disable WAL logging while
> > running pg_dump.
>
> pg_dump doesn't modify any data, so I don't see how it could be
> causing WAL logs to get generated.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump
Next
From: Tom Lane
Date:
Subject: Re: BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram