tcn
The table compression notification feature provides a mechanism for notifying registered listeners when data is inserted, updated, or deleted from a compressed heap, allowing external processes to track changes and maintain auxiliary data structures.
Information Analysis
| Extensibility Types: | Functions |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 180 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 180 |
| 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 tcn ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 181 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 tcn ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 145 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 tcn ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 88 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_show_plans
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 tcn ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 20 ms
test version ... ok 18 ms
test guc ... ok 20 ms
test pgsm_query_id ... ok 685 ms
test functions ... FAILED 85 ms
test counters ... ok 71 ms
test relations ... ok 196 ms
test database ... ok 444 ms
test error_insert ... ok 84 ms
test application_name ... ok 42 ms
test application_name_unique ... ok 40 ms
test top_query ... ok 48 ms
test cmd_type ... ok 83 ms
test error ... ok 52 ms
test rows ... ok 69 ms
test tags ... ok 50 ms
test user ... ok 82 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 tcn ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 25 ms
test version ... ok 20 ms
test guc ... ok 25 ms
test pgsm_query_id ... ok 403 ms
test functions ... FAILED 53 ms
test counters ... ok 35 ms
test relations ... ok 90 ms
test database ... ok 260 ms
test error_insert ... ok 61 ms
test application_name ... ok 28 ms
test application_name_unique ... ok 20 ms
test top_query ... ok 17 ms
test cmd_type ... ok 26 ms
test error ... ok 24 ms
test rows ... ok 75 ms
test tags ... ok 45 ms
test user ... ok 34 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 tcn ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 64 ms
test pgextwlist ... FAILED 84 ms
test errors ... FAILED 8 ms
test crossuser ... ok 32 ms
test hooks ... ok 16 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 tcn ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 43 ms
test pgextwlist ... FAILED 67 ms
test errors ... FAILED 7 ms
test crossuser ... ok 16 ms
test hooks ... ok 8 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 1118 ms
test alternate_users ... ok 809 ms
test chunk_utils ... ok 864 ms
test index ... ok 1056 ms
test pg_dump_unprivileged ... ok 777 ms
test tablespace ... ok 713 ms
parallel group (21 tests): baserel_cache agg_bookends-15 delete-15 chunks cursor-15 chunk_adaptive drop_hypertable custom_type ddl_extra cluster-15 create_chunks broken_tables create_table drop_extension ddl_errors create_hypertable ddl-15 copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5019 ms
append-15 ... ok 6729 ms
baserel_cache ... ok 5018 ms
broken_tables ... ok 5036 ms
chunk_adaptive ... ok 5025 ms
chunks ... ok 5019 ms
cluster-15 ... ok 5036 ms
constraint-15 ... ok 5133 ms
copy-15 ... ok 5063 ms
create_chunks ... ok 5036 ms
create_hypertable ... ok 5049 ms
create_table ... ok 5036 ms
cursor-15 ... ok 5020 ms
custom_type ... ok 5034 ms
ddl-15 ... ok 5056 ms
ddl_errors ... ok 5040 ms
ddl_extra ... ok 5034 ms
delete-15 ... ok 5018 ms
drop_extension ... FAILED 5039 ms
drop_hypertable ... ok 5028 ms
drop_owned ... ok 5141 ms
parallel group (21 tests): generated_as_identity information_views insert_returning lateral partitioning dump_meta histogram_test merge drop_rename_hypertable license hash insert_single misc grant_hypertable null_exclusion parallel-15 partition extension_scripts drop_schema insert-15 insert_many
drop_rename_hypertable ... ok 6041 ms
drop_schema ... ok 6062 ms
dump_meta ... ok 6039 ms
extension_scripts ... ok 6060 ms
generated_as_identity ... ok 4651 ms
grant_hypertable ... ok 6051 ms
hash ... ok 6043 ms
histogram_test ... ok 6040 ms
information_views ... ok 6036 ms
insert-15 ... ok 6463 ms
insert_many ... ok 7541 ms
insert_returning ... ok 6036 ms
insert_single ... ok 6049 ms
lateral ... ok 6036 ms
license ... ok 6040 ms
merge ... ok 6039 ms
misc ... ok 6050 ms
null_exclusion ... ok 6053 ms
parallel-15 ... ok 6054 ms
partition ... ok 6055 ms
partitioning ... ok 6035 ms
parallel group (21 tests): tableam plan_hypertable_inline-15 size_utils reloptions sort_optimization sql_query partitionwise-15 timestamp plain update-15 triggers query-15 upsert plan_expand_hypertable-15 plan_ordered_append rowsecurity-15 trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7707 ms
pg_join ... ok 9887 ms
plain ... ok 7708 ms
plan_expand_hypertable-15 ... ok 7734 ms
plan_hashagg-15 ... ok 9066 ms
plan_hypertable_inline-15 ... ok 7682 ms
plan_ordered_append ... ok 7735 ms
query-15 ... ok 7719 ms
relocate_extension ... ok 8387 ms
reloptions ... ok 7702 ms
rowsecurity-15 ... ok 7735 ms
size_utils ... ok 7692 ms
sort_optimization ... ok 7703 ms
sql_query ... ok 7705 ms
tableam ... ok 7109 ms
timestamp ... ok 7705 ms
triggers ... ok 7717 ms
truncate ... ok 8044 ms
trusted_extension ... ok 7939 ms
update-15 ... ok 7706 ms
upsert ... ok 7718 ms
parallel group (4 tests): version vacuum util vacuum_parallel
util ... ok 695 ms
vacuum ... ok 694 ms
vacuum_parallel ... ok 696 ms
version ... ok 685 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 2406 ms
test alternate_users ... ok 1691 ms
test chunk_utils ... ok 1861 ms
test index ... ok 2216 ms
test pg_dump_unprivileged ... ok 1469 ms
test tablespace ... ok 1524 ms
parallel group (21 tests): chunks create_table broken_tables custom_type drop_extension baserel_cache ddl_extra ddl-15 delete-15 cursor-15 drop_hypertable cluster-15 ddl_errors agg_bookends-15 create_hypertable create_chunks chunk_adaptive copy-15 append-15 constraint-15 drop_owned
agg_bookends-15 ... ok 10967 ms
append-15 ... ok 10981 ms
baserel_cache ... ok 10961 ms
broken_tables ... ok 10959 ms
chunk_adaptive ... ok 10970 ms
chunks ... ok 10953 ms
cluster-15 ... ok 10966 ms
constraint-15 ... ok 11150 ms
copy-15 ... ok 10980 ms
create_chunks ... ok 10969 ms
create_hypertable ... ok 10966 ms
create_table ... ok 10955 ms
cursor-15 ... ok 10965 ms
custom_type ... ok 10958 ms
ddl-15 ... ok 10960 ms
ddl_errors ... ok 10966 ms
ddl_extra ... ok 10960 ms
delete-15 ... ok 10964 ms
drop_extension ... FAILED 10958 ms
drop_hypertable ... ok 10964 ms
drop_owned ... ok 11229 ms
parallel group (21 tests): hash drop_schema histogram_test generated_as_identity drop_rename_hypertable grant_hypertable insert_returning lateral dump_meta insert_single partitioning null_exclusion merge partition misc information_views license parallel-15 extension_scripts insert-15 insert_many
drop_rename_hypertable ... ok 15515 ms
drop_schema ... ok 15500 ms
dump_meta ... ok 15515 ms
extension_scripts ... ok 15601 ms
generated_as_identity ... ok 15514 ms
grant_hypertable ... ok 15515 ms
hash ... ok 11143 ms
histogram_test ... ok 15513 ms
information_views ... ok 15584 ms
insert-15 ... ok 16399 ms
insert_many ... ok 18450 ms
insert_returning ... ok 15514 ms
insert_single ... ok 15514 ms
lateral ... ok 15514 ms
license ... ok 15583 ms
merge ... ok 15520 ms
misc ... ok 15583 ms
null_exclusion ... ok 15514 ms
parallel-15 ... ok 15583 ms
partition ... ok 15519 ms
partitioning ... ok 15514 ms
parallel group (21 tests): tableam plan_hypertable_inline-15 plain sql_query size_utils plan_expand_hypertable-15 timestamp partitionwise-15 reloptions plan_ordered_append sort_optimization plan_hashagg-15 upsert rowsecurity-15 query-15 triggers update-15 pg_join truncate trusted_extension relocate_extension
partitionwise-15 ... ok 19794 ms
pg_join ... ok 20152 ms
plain ... ok 19673 ms
plan_expand_hypertable-15 ... ok 19692 ms
plan_hashagg-15 ... ok 19795 ms
plan_hypertable_inline-15 ... ok 19673 ms
plan_ordered_append ... ok 19794 ms
query-15 ... ok 19794 ms
relocate_extension ... ok 20178 ms
reloptions ... ok 19794 ms
rowsecurity-15 ... ok 19794 ms
size_utils ... ok 19684 ms
sort_optimization ... ok 19794 ms
sql_query ... ok 19673 ms
tableam ... ok 19668 ms
timestamp ... ok 19763 ms
triggers ... ok 19794 ms
truncate ... ok 20174 ms
trusted_extension ... ok 20177 ms
update-15 ... ok 19793 ms
upsert ... ok 19793 ms
parallel group (4 tests): util version vacuum vacuum_parallel
util ... ok 1586 ms
vacuum ... ok 1613 ms
vacuum_parallel ... ok 1613 ms
version ... ok 1609 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".