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