diff -U3 /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache.out /tmp/cirrus-ci-build/contrib/pg_buffercache/results/pg_buffercache.out --- /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache.out 2026-01-28 13:50:04.112981165 +0000 +++ /tmp/cirrus-ci-build/contrib/pg_buffercache/results/pg_buffercache.out 2026-01-28 13:56:50.496479431 +0000 @@ -3,21 +3,13 @@ from pg_settings where name = 'shared_buffers') from pg_buffercache; - ?column? ----------- - t -(1 row) - +ERROR: invalid input syntax for type bigint: "128MB" -- For pg_buffercache_os_pages, we expect at least one entry for each buffer select count(*) >= (select setting::bigint from pg_settings where name = 'shared_buffers') from pg_buffercache_os_pages; - ?column? ----------- - t -(1 row) - +ERROR: invalid input syntax for type bigint: "128MB" select buffers_used + buffers_unused > 0, buffers_dirty <= buffers_used, buffers_pinned <= buffers_used @@ -38,21 +30,13 @@ from pg_settings where name = 'shared_buffers') from pg_buffercache_lookup_table_entries(); - ?column? ----------- - t -(1 row) - +ERROR: invalid input syntax for type bigint: "128MB" -- Check that pg_buffercache_lookup_table view works and count is <= shared_buffers select count(*) <= (select setting::bigint from pg_settings where name = 'shared_buffers') from pg_buffercache_lookup_table; - ?column? ----------- - t -(1 row) - +ERROR: invalid input syntax for type bigint: "128MB" -- Check that the functions / views can't be accessed by default. To avoid -- having to create a dedicated user, use the pg_database_owner pseudo-role. SET ROLE pg_database_owner; diff -U3 /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache_numa.out /tmp/cirrus-ci-build/contrib/pg_buffercache/results/pg_buffercache_numa.out --- /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache_numa.out 2026-01-28 13:50:04.112981165 +0000 +++ /tmp/cirrus-ci-build/contrib/pg_buffercache/results/pg_buffercache_numa.out 2026-01-28 13:56:50.920493303 +0000 @@ -7,11 +7,7 @@ from pg_settings where name = 'shared_buffers') from pg_buffercache_numa; - ?column? ----------- - t -(1 row) - +ERROR: invalid input syntax for type bigint: "128MB" -- Check that the functions / views can't be accessed by default. To avoid -- having to create a dedicated user, use the pg_database_owner pseudo-role. SET ROLE pg_database_owner;