Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation without

I'm seeing these messages in the standby server log:

WARNING: unlogged operation performed, data may be missing
HINT: This can happen if you temporarily disable archive_mode without
taking a new base backup.
CONTEXT: xlog redo unlogged operation: heap inserts on "pg_temp_65646"

which connected with operations on temp tables, probably as a result of
VACUUM FULL and CLUSTER.

I don't think those messages should be there.

On Wed, 2010-01-20 at 19:43 +0000, Heikki Linnakangas wrote:
> Log Message:
> -----------
> Write a WAL record whenever we perform an operation without WAL-logging
> that would've been WAL-logged if archiving was enabled. If we encounter
> such records in archive recovery anyway, we know that some data is
> missing from the log. A WARNING is emitted in that case.
>
> Original patch by Fujii Masao, with changes by me.
>
> Modified Files:
> --------------
> pgsql/src/backend/access/heap:
> heapam.c (r1.282 -> r1.283)
> (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c?r1=1.282&r2=1.283)
> pgsql/src/backend/access/nbtree:
> nbtsort.c (r1.122 -> r1.123)
> (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtsort.c?r1=1.122&r2=1.123)
> pgsql/src/backend/access/transam:
> xlog.c (r1.358 -> r1.359)
> (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.358&r2=1.359)
> pgsql/src/backend/commands:
> cluster.c (r1.193 -> r1.194)
> (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c?r1=1.193&r2=1.194)
> tablecmds.c (r1.316 -> r1.317)
> (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.316&r2=1.317)
> pgsql/src/include/access:
> xlog.h (r1.97 -> r1.98)
> (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/xlog.h?r1=1.97&r2=1.98)
> pgsql/src/include/catalog:
> pg_control.h (r1.48 -> r1.49)
> (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_control.h?r1=1.48&r2=1.49)
>
--
Simon Riggs www.2ndQuadrant.com