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

`pgroonga.enable_wal` parameter

Since 1.1.6.

Summary

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