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.


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

PGroonga supports WAL with PostgreSQL 9.6 or later. pgroonga.enable_wal parameter is meaningless with PostgreSQL 9.5 or earlier.

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 even when you're using PostgreSQL 9.6 or later.



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

See also