Postgres Pro
Downloads
Home   >   mailing lists

Re: Hot disable WAL archiving - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Hot disable WAL archiving
Date
Msg-id A737B7A37273E048B164557ADEF4A58B53862193@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Hot disable WAL archiving  (Job <Job@colliniconsulting.it>)
Responses R: Hot disable WAL archiving
List pgsql-general
Tree view 
Job wrote:
> is there a way in Postgresql-9.5 to disable temporarily WAL archiving to speed up pg_bulkload with
> restarting database engine?

You can set 'archive_command=/bin/true' and reload, then no WAL
archives will be written.

Make sure to perform a base backup as soon as your bulk load
is finished.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Job
Date:
Subject: Hot disable WAL archiving
Next
From: Oleg Bartunov
Date:
Subject: Re: Question about RUM-index