make installcheck: 3 of 6 tests failed.

[joelonsql]

Hi,

Thanks for making pg_dbms_stats.

There seems to be a problem with some of the tests,
due to permission problems.

$ tail -n 3 results/ut-common.out
/* Reconnection as regular user */
\c - regular_user
\connect: FATAL:  Peer authentication failed for user "regular_user"

$ tail -n 3 results/ut.out
/* reconnection needed to flush cache */
\c - regular_user
\connect: FATAL:  Peer authentication failed for user "regular_user"

$ grep -A 2 ERROR results/ut_imp_exp.out
ERROR:  permission denied for schema dbms_stats
LINE 1: SELECT 1 FROM ONLY "dbms_stats"."relation_stats_locked" x WH...
                          ^
--
ERROR:  permission denied for schema dbms_stats
LINE 1: SELECT *   FROM dbms_stats.column_stats_locked WHERE stareli...
                        ^
--
ERROR:  permission denied for schema dbms_stats
LINE 1: SELECT 1 FROM ONLY "dbms_stats"."relation_stats_locked" x WH...
                          ^

Log output from make installcheck:

$ make installcheck
/usr/lib/postgresql/13/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/13/bin'    --encoding=UTF8 --temp-config=regress.conf --dbname=contrib_regression init-common ut_fdw_init init ut-common ut ut_imp_exp
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries        ==============
test init-common                  ... ok          618 ms
test ut_fdw_init                  ... ok           44 ms
test init                         ... ok           49 ms
test ut-common                    ... FAILED (test process exited with exit code 2)      278 ms
test ut                           ... FAILED (test process exited with exit code 2)     4637 ms
test ut_imp_exp                   ... FAILED     1037 ms

======================
3 of 6 tests failed.
======================