pg_prewarm
The functionality provides a means to preload data into shared buffers, allowing for explicit control over which relations are preloaded and when, thereby potentially improving performance by reducing the need for subsequent disk I/O.
Information Analysis
| Extensibility Types: | Functions |
| System Components: | Background Workers, Custom Configuration Variables |
Duplicate Code Analysis
| Total Lines of Code: ? | 1123 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 1123 |
| Lines of Encapsulated Versioning Code: ? | 0 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0% |
Compatibility Analysis
| Number of Failed Extensions: | 6 |
| Failure Rate: | 5.8% |
Failed Extensions
earthdistance
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_prewarm ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 183 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_prewarm ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 149 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".
waiting for server to shut down.... done
server stopped
pg_queryid
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_prewarm ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 63 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_kcache
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_monitor
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_prewarm ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 22 ms
test version ... ok 23 ms
test guc ... ok 25 ms
test pgsm_query_id ... ok 666 ms
test functions ... FAILED 84 ms
test counters ... ok 64 ms
test relations ... ok 171 ms
test database ... ok 485 ms
test error_insert ... ok 93 ms
test application_name ... ok 52 ms
test application_name_unique ... ok 33 ms
test top_query ... ok 39 ms
test cmd_type ... ok 60 ms
test error ... ok 37 ms
test rows ... ok 85 ms
test tags ... ok 31 ms
test user ... ok 94 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_prewarm ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 14 ms
test version ... ok 13 ms
test guc ... ok 13 ms
test pgsm_query_id ... ok 417 ms
test functions ... FAILED 37 ms
test counters ... ok 35 ms
test relations ... ok 72 ms
test database ... ok 330 ms
test error_insert ... ok 49 ms
test application_name ... ok 26 ms
test application_name_unique ... ok 27 ms
test top_query ... ok 20 ms
test cmd_type ... ok 23 ms
test error ... ok 15 ms
test rows ... ok 38 ms
test tags ... ok 45 ms
test user ... ok 37 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
pgextwlist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_prewarm ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 76 ms
test pgextwlist ... FAILED 88 ms
test errors ... FAILED 8 ms
test crossuser ... ok 33 ms
test hooks ... ok 19 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_prewarm ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 36 ms
test pgextwlist ... FAILED 69 ms
test errors ... FAILED 8 ms
test crossuser ... ok 30 ms
test hooks ... ok 14 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
timescaledb
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
CREATE EXTENSION
waiting for server to shut down.... done
server stopped
TESTS
IGNORES
SKIPS
(using postmaster on localhost, port 5432)
============== dropping database "single" ==============
SET
DROP DATABASE
============== dropping role "super_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user_2" ==============
SET
DROP ROLE
============== dropping role "cluster_super_user" ==============
SET
DROP ROLE
============== dropping role "test_role_1" ==============
SET
DROP ROLE
============== dropping role "test_role_2" ==============
SET
DROP ROLE
============== dropping role "test_role_3" ==============
SET
DROP ROLE
============== dropping role "test_role_4" ==============
SET
DROP ROLE
============== dropping role "test_role_read_only" ==============
SET
DROP ROLE
============== creating database "single" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== creating role "super_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user_2" ==============
CREATE ROLE
GRANT
============== creating role "cluster_super_user" ==============
CREATE ROLE
GRANT
============== creating role "test_role_1" ==============
CREATE ROLE
GRANT
============== creating role "test_role_2" ==============
CREATE ROLE
GRANT
============== creating role "test_role_3" ==============
CREATE ROLE
GRANT
============== creating role "test_role_4" ==============
CREATE ROLE
GRANT
============== creating role "test_role_read_only" ==============
CREATE ROLE
GRANT
============== running regression test queries ==============
test alter ... ok 1138 ms
test alternate_users ... ok 819 ms
test chunk_utils ... ok 862 ms
test index ... ok 1057 ms
test pg_dump_unprivileged ... ok 783 ms
test tablespace ... ok 759 ms
parallel group (21 tests): custom_type cursor-15 create_table drop_hypertable ddl_errors baserel_cache chunks cluster-15 create_chunks drop_extension broken_tables delete-15 create_hypertable copy-15 ddl-15 agg_bookends-15 ddl_extra chunk_adaptive constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5006 ms
append-15 ... ok 6657 ms
baserel_cache ... ok 4985 ms
broken_tables ... ok 4997 ms
chunk_adaptive ... ok 5021 ms
chunks ... ok 4985 ms
cluster-15 ... ok 4987 ms
constraint-15 ... ok 5109 ms
copy-15 ... ok 5001 ms
create_chunks ... ok 4995 ms
create_hypertable ... ok 4998 ms
create_table ... ok 4980 ms
cursor-15 ... ok 4968 ms
custom_type ... ok 4962 ms
ddl-15 ... ok 5002 ms
ddl_errors ... ok 4983 ms
ddl_extra ... ok 5009 ms
delete-15 ... ok 4997 ms
drop_extension ... FAILED 4994 ms
drop_hypertable ... ok 4981 ms
drop_owned ... ok 5119 ms
parallel group (21 tests): hash information_views drop_schema histogram_test insert_returning partitioning misc generated_as_identity lateral license dump_meta parallel-15 partition drop_rename_hypertable extension_scripts grant_hypertable insert_single merge null_exclusion insert-15 insert_many
drop_rename_hypertable ... ok 6133 ms
drop_schema ... ok 6118 ms
dump_meta ... ok 6128 ms
extension_scripts ... ok 6132 ms
generated_as_identity ... ok 6127 ms
grant_hypertable ... ok 6132 ms
hash ... ok 4752 ms
histogram_test ... ok 6122 ms
information_views ... ok 6109 ms
insert-15 ... ok 6372 ms
insert_many ... ok 7530 ms
insert_returning ... ok 6121 ms
insert_single ... ok 6131 ms
lateral ... ok 6126 ms
license ... ok 6126 ms
merge ... ok 6131 ms
misc ... ok 6125 ms
null_exclusion ... ok 6131 ms
parallel-15 ... ok 6126 ms
partition ... ok 6126 ms
partitioning ... ok 6122 ms
parallel group (21 tests): sort_optimization tableam plain update-15 reloptions plan_hypertable_inline-15 rowsecurity-15 size_utils upsert sql_query partitionwise-15 plan_ordered_append triggers timestamp query-15 plan_expand_hypertable-15 trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7793 ms
pg_join ... ok 9662 ms
plain ... ok 7776 ms
plan_expand_hypertable-15 ... ok 7814 ms
plan_hashagg-15 ... ok 8973 ms
plan_hypertable_inline-15 ... ok 7781 ms
plan_ordered_append ... ok 7796 ms
query-15 ... ok 7807 ms
relocate_extension ... ok 7994 ms
reloptions ... ok 7780 ms
rowsecurity-15 ... ok 7783 ms
size_utils ... ok 7784 ms
sort_optimization ... ok 7771 ms
sql_query ... ok 7786 ms
tableam ... ok 7772 ms
timestamp ... ok 7798 ms
triggers ... ok 7795 ms
truncate ... ok 7992 ms
trusted_extension ... ok 7981 ms
update-15 ... ok 7777 ms
upsert ... ok 7783 ms
parallel group (4 tests): version vacuum util vacuum_parallel
util ... ok 652 ms
vacuum ... ok 651 ms
vacuum_parallel ... ok 653 ms
version ... ok 642 ms
=======================
1 of 73 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
CREATE EXTENSION
waiting for server to shut down.... done
server stopped
TESTS
IGNORES
SKIPS
(using postmaster on localhost, port 5432)
============== dropping database "single" ==============
SET
DROP DATABASE
============== dropping role "super_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user_2" ==============
SET
DROP ROLE
============== dropping role "cluster_super_user" ==============
SET
DROP ROLE
============== dropping role "test_role_1" ==============
SET
DROP ROLE
============== dropping role "test_role_2" ==============
SET
DROP ROLE
============== dropping role "test_role_3" ==============
SET
DROP ROLE
============== dropping role "test_role_4" ==============
SET
DROP ROLE
============== dropping role "test_role_read_only" ==============
SET
DROP ROLE
============== creating database "single" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== creating role "super_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user_2" ==============
CREATE ROLE
GRANT
============== creating role "cluster_super_user" ==============
CREATE ROLE
GRANT
============== creating role "test_role_1" ==============
CREATE ROLE
GRANT
============== creating role "test_role_2" ==============
CREATE ROLE
GRANT
============== creating role "test_role_3" ==============
CREATE ROLE
GRANT
============== creating role "test_role_4" ==============
CREATE ROLE
GRANT
============== creating role "test_role_read_only" ==============
CREATE ROLE
GRANT
============== running regression test queries ==============
test alter ... ok 2323 ms
test alternate_users ... ok 1620 ms
test chunk_utils ... ok 1793 ms
test index ... ok 2135 ms
test pg_dump_unprivileged ... ok 1429 ms
test tablespace ... ok 1465 ms
parallel group (21 tests): cursor-15 ddl_extra broken_tables create_table drop_hypertable ddl-15 ddl_errors create_hypertable custom_type delete-15 drop_extension agg_bookends-15 chunks cluster-15 baserel_cache create_chunks chunk_adaptive append-15 copy-15 constraint-15 drop_owned
agg_bookends-15 ... ok 11268 ms
append-15 ... ok 11296 ms
baserel_cache ... ok 11268 ms
broken_tables ... ok 11262 ms
chunk_adaptive ... ok 11296 ms
chunks ... ok 11268 ms
cluster-15 ... ok 11267 ms
constraint-15 ... ok 11473 ms
copy-15 ... ok 11296 ms
create_chunks ... ok 11287 ms
create_hypertable ... ok 11266 ms
create_table ... ok 11261 ms
cursor-15 ... ok 11255 ms
custom_type ... ok 11266 ms
ddl-15 ... ok 11265 ms
ddl_errors ... ok 11265 ms
ddl_extra ... ok 11256 ms
delete-15 ... ok 11265 ms
drop_extension ... FAILED 11266 ms
drop_hypertable ... ok 11262 ms
drop_owned ... ok 11499 ms
parallel group (21 tests): partitioning misc grant_hypertable drop_schema dump_meta information_views insert_returning drop_rename_hypertable parallel-15 partition lateral generated_as_identity license insert_single histogram_test merge hash null_exclusion extension_scripts insert-15 insert_many
drop_rename_hypertable ... ok 15330 ms
drop_schema ... ok 15323 ms
dump_meta ... ok 15323 ms
extension_scripts ... ok 15407 ms
generated_as_identity ... ok 15330 ms
grant_hypertable ... ok 15321 ms
hash ... ok 15388 ms
histogram_test ... ok 15388 ms
information_views ... ok 15324 ms
insert-15 ... ok 16207 ms
insert_many ... ok 18132 ms
insert_returning ... ok 15324 ms
insert_single ... ok 15329 ms
lateral ... ok 15329 ms
license ... ok 15329 ms
merge ... ok 15387 ms
misc ... ok 15309 ms
null_exclusion ... ok 15387 ms
parallel-15 ... ok 15328 ms
partition ... ok 15328 ms
partitioning ... ok 10819 ms
parallel group (21 tests): tableam update-15 query-15 size_utils upsert timestamp sort_optimization rowsecurity-15 reloptions plain triggers plan_expand_hypertable-15 plan_hypertable_inline-15 sql_query partitionwise-15 plan_hashagg-15 plan_ordered_append trusted_extension truncate pg_join relocate_extension
partitionwise-15 ... ok 18482 ms
pg_join ... ok 19667 ms
plain ... ok 18474 ms
plan_expand_hypertable-15 ... ok 18475 ms
plan_hashagg-15 ... ok 18482 ms
plan_hypertable_inline-15 ... ok 18475 ms
plan_ordered_append ... ok 18500 ms
query-15 ... ok 18467 ms
relocate_extension ... ok 19900 ms
reloptions ... ok 18471 ms
rowsecurity-15 ... ok 18469 ms
size_utils ... ok 18467 ms
sort_optimization ... ok 18468 ms
sql_query ... ok 18475 ms
tableam ... ok 17262 ms
timestamp ... ok 18467 ms
triggers ... ok 18473 ms
truncate ... ok 19540 ms
trusted_extension ... ok 19185 ms
update-15 ... ok 18461 ms
upsert ... ok 18466 ms
parallel group (4 tests): util version vacuum vacuum_parallel
util ... ok 1573 ms
vacuum ... ok 1604 ms
vacuum_parallel ... ok 1607 ms
version ... ok 1598 ms
=======================
1 of 73 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".