Re: BUG #7521: Cannot disable WAL log while using pg_dump

From: "Boy de Laat" <boy(at)atsc(dot)nl>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump
Date: 2012-09-06 20:24:35
Message-ID: 6542094C-D8DC-4F96-B989-B1445103ADBF@atsc.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


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(at)gmail(dot)com> het
volgende geschreven:

> On Wed, Sep 5, 2012 at 9:57 AM, <boy(at)atsc(dot)nl> wrote:
> > The following bug has been logged on the website:
> >
> > Bug reference: 7521
> > Logged by: Boy de Laat
> > Email address: boy(at)atsc(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-09-06 20:58:11 Re: BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram
Previous Message Tom Lane 2012-09-06 20:23:07 Re: BUG #7521: Cannot disable WAL log while using pg_dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-09-06 21:01:02 Re: Minor document updates
Previous Message Tom Lane 2012-09-06 20:23:07 Re: BUG #7521: Cannot disable WAL log while using pg_dump