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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: boy(at)atsc(dot)nl
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump
Date: 2012-09-06 19:39:04
Message-ID: CA+TgmoaOceVGQW9PZ-vBd6tLGP9p=_Fp=AvPVhLOgHfM-EPXzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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 19:55:07 Re: BUG #7521: Cannot disable WAL log while using pg_dump
Previous Message Robert Haas 2012-09-06 18:52:36 Re: BUG #7514: postgres -k no longer works with spaces in the path

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-09-06 19:55:07 Re: BUG #7521: Cannot disable WAL log while using pg_dump
Previous Message Jeff Davis 2012-09-06 17:56:52 Re: Proof of concept: standalone backend with full FE/BE protocol