This is a document for PGroonga 2.X and 3.X. See PGroonga 1.x document when you're using old PGroonga.

`pgroonga.enable_wal` parameter

Since 1.1.6.

Notices

If PostgreSQL is 15 or higher, please use the pgroonga_wal_resource_manager module instead of this module.

It has the following advantages.

Apply WAL in real time on standby
On standby, it prevents unstable during recovery
- Connection will not be available during recovery
- When using crash-safer, there was a status where we connected but could not execute a query
When used with Replication Slots, it prevents the WAL size from continuing to increase

pgroonga.enable_wal parameter controls whether WAL is enabled or not.

If you enable WAL support, you can use PostgreSQL's streaming replication feature. See Replication for details.

If you enable WAL support, update performance will be decreased because some extra disk writes are needed.

The default value is off. It means that PGroonga doesn't generate WAL.

In SQL:

SET pgroonga.enable_wal = boolean;

In postgresql.conf:

pgroonga.enable_wal = boolean

boolean is a boolean value. There are some literals for boolean value such as on, off, true, false, yes and no.

Here is an example SQL to enable WAL support:

SET pgroonga.enable_wal = on;

Here is an example configration to enable WAL support:

pgroonga.enable_wal = on