pgrowlocks
The row-level locking information for a specified relation can be obtained through a set of functions that provide details about the transaction IDs, modes, and timestamps associated with existing locks on rows within that relation.
Information Analysis
| Extensibility Types: | Functions |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 276 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 276 |
| 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 pgrowlocks ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 218 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 pgrowlocks ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 137 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 pgrowlocks ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 62 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 pgrowlocks ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 23 ms
test version ... ok 19 ms
test guc ... ok 20 ms
test pgsm_query_id ... ok 592 ms
test functions ... FAILED 84 ms
test counters ... ok 89 ms
test relations ... ok 186 ms
test database ... ok 434 ms
test error_insert ... ok 60 ms
test application_name ... ok 24 ms
test application_name_unique ... ok 24 ms
test top_query ... ok 32 ms
test cmd_type ... ok 63 ms
test error ... ok 53 ms
test rows ... ok 85 ms
test tags ... ok 30 ms
test user ... ok 60 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 pgrowlocks ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 14 ms
test version ... ok 13 ms
test guc ... ok 14 ms
test pgsm_query_id ... ok 408 ms
test functions ... FAILED 44 ms
test counters ... ok 45 ms
test relations ... ok 98 ms
test database ... ok 250 ms
test error_insert ... ok 59 ms
test application_name ... ok 27 ms
test application_name_unique ... ok 16 ms
test top_query ... ok 18 ms
test cmd_type ... ok 40 ms
test error ... ok 48 ms
test rows ... ok 64 ms
test tags ... ok 26 ms
test user ... ok 56 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 pgrowlocks ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 39 ms
test pgextwlist ... FAILED 75 ms
test errors ... FAILED 8 ms
test crossuser ... ok 34 ms
test hooks ... ok 20 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 pgrowlocks ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 27 ms
test pgextwlist ... FAILED 49 ms
test errors ... FAILED 10 ms
test crossuser ... ok 32 ms
test hooks ... ok 18 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 1122 ms
test alternate_users ... ok 803 ms
test chunk_utils ... ok 851 ms
test index ... ok 1015 ms
test pg_dump_unprivileged ... ok 772 ms
test tablespace ... ok 734 ms
parallel group (21 tests): chunks ddl-15 drop_hypertable create_chunks custom_type cursor-15 ddl_extra broken_tables create_table delete-15 drop_extension ddl_errors create_hypertable baserel_cache agg_bookends-15 chunk_adaptive cluster-15 copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5232 ms
append-15 ... ok 6823 ms
baserel_cache ... ok 5230 ms
broken_tables ... ok 5227 ms
chunk_adaptive ... ok 5233 ms
chunks ... ok 5209 ms
cluster-15 ... ok 5240 ms
constraint-15 ... ok 5311 ms
copy-15 ... ok 5241 ms
create_chunks ... ok 5219 ms
create_hypertable ... ok 5229 ms
create_table ... ok 5227 ms
cursor-15 ... ok 5221 ms
custom_type ... ok 5219 ms
ddl-15 ... ok 5210 ms
ddl_errors ... ok 5228 ms
ddl_extra ... ok 5223 ms
delete-15 ... ok 5227 ms
drop_extension ... FAILED 5227 ms
drop_hypertable ... ok 5217 ms
drop_owned ... ok 5331 ms
parallel group (21 tests): hash license insert_returning merge drop_schema dump_meta grant_hypertable lateral partitioning drop_rename_hypertable extension_scripts information_views insert_single histogram_test misc null_exclusion generated_as_identity partition parallel-15 insert-15 insert_many
drop_rename_hypertable ... ok 6176 ms
drop_schema ... ok 6158 ms
dump_meta ... ok 6158 ms
extension_scripts ... ok 6176 ms
generated_as_identity ... ok 6210 ms
grant_hypertable ... ok 6158 ms
hash ... ok 4949 ms
histogram_test ... ok 6182 ms
information_views ... ok 6175 ms
insert-15 ... ok 6391 ms
insert_many ... ok 7433 ms
insert_returning ... ok 6156 ms
insert_single ... ok 6180 ms
lateral ... ok 6169 ms
license ... ok 6150 ms
merge ... ok 6157 ms
misc ... ok 6205 ms
null_exclusion ... ok 6207 ms
parallel-15 ... ok 6214 ms
partition ... ok 6213 ms
partitioning ... ok 6174 ms
parallel group (21 tests): tableam triggers partitionwise-15 plan_hypertable_inline-15 update-15 sort_optimization rowsecurity-15 reloptions plain upsert size_utils sql_query plan_expand_hypertable-15 timestamp query-15 plan_ordered_append trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7546 ms
pg_join ... ok 9748 ms
plain ... ok 7573 ms
plan_expand_hypertable-15 ... ok 7581 ms
plan_hashagg-15 ... ok 8884 ms
plan_hypertable_inline-15 ... ok 7564 ms
plan_ordered_append ... ok 7594 ms
query-15 ... ok 7587 ms
relocate_extension ... ok 8270 ms
reloptions ... ok 7568 ms
rowsecurity-15 ... ok 7566 ms
size_utils ... ok 7573 ms
sort_optimization ... ok 7566 ms
sql_query ... ok 7580 ms
tableam ... ok 7004 ms
timestamp ... ok 7582 ms
triggers ... ok 7544 ms
truncate ... ok 7968 ms
trusted_extension ... ok 7835 ms
update-15 ... ok 7563 ms
upsert ... ok 7571 ms
parallel group (4 tests): version util vacuum vacuum_parallel
util ... ok 700 ms
vacuum ... ok 700 ms
vacuum_parallel ... ok 702 ms
version ... ok 689 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 2399 ms
test alternate_users ... ok 1694 ms
test chunk_utils ... ok 1859 ms
test index ... ok 2215 ms
test pg_dump_unprivileged ... ok 1497 ms
test tablespace ... ok 1521 ms
parallel group (21 tests): create_table cursor-15 create_chunks chunks ddl-15 drop_extension custom_type ddl_extra drop_hypertable ddl_errors broken_tables agg_bookends-15 baserel_cache cluster-15 create_hypertable delete-15 append-15 chunk_adaptive copy-15 constraint-15 drop_owned
agg_bookends-15 ... ok 11292 ms
append-15 ... ok 11311 ms
baserel_cache ... ok 11295 ms
broken_tables ... ok 11292 ms
chunk_adaptive ... ok 11318 ms
chunks ... ok 11280 ms
cluster-15 ... ok 11295 ms
constraint-15 ... ok 11470 ms
copy-15 ... ok 11318 ms
create_chunks ... ok 11278 ms
create_hypertable ... ok 11295 ms
create_table ... ok 11277 ms
cursor-15 ... ok 11278 ms
custom_type ... ok 11283 ms
ddl-15 ... ok 11281 ms
ddl_errors ... ok 11285 ms
ddl_extra ... ok 11283 ms
delete-15 ... ok 11294 ms
drop_extension ... FAILED 11282 ms
drop_hypertable ... ok 11284 ms
drop_owned ... ok 11545 ms
parallel group (21 tests): misc merge generated_as_identity dump_meta hash null_exclusion grant_hypertable license lateral insert_returning partitioning histogram_test drop_schema drop_rename_hypertable information_views insert_single parallel-15 partition extension_scripts insert-15 insert_many
drop_rename_hypertable ... ok 15120 ms
drop_schema ... ok 15109 ms
dump_meta ... ok 15101 ms
extension_scripts ... ok 15126 ms
generated_as_identity ... ok 15101 ms
grant_hypertable ... ok 15102 ms
hash ... ok 15101 ms
histogram_test ... ok 15108 ms
information_views ... ok 15120 ms
insert-15 ... ok 15763 ms
insert_many ... ok 17927 ms
insert_returning ... ok 15107 ms
insert_single ... ok 15119 ms
lateral ... ok 15107 ms
license ... ok 15107 ms
merge ... ok 15086 ms
misc ... ok 10821 ms
null_exclusion ... ok 15099 ms
parallel-15 ... ok 15119 ms
partition ... ok 15124 ms
partitioning ... ok 15106 ms
parallel group (21 tests): plain update-15 tableam reloptions size_utils sort_optimization partitionwise-15 plan_hypertable_inline-15 sql_query query-15 plan_expand_hypertable-15 triggers timestamp upsert rowsecurity-15 plan_ordered_append plan_hashagg-15 truncate trusted_extension pg_join relocate_extension
partitionwise-15 ... ok 19220 ms
pg_join ... ok 19876 ms
plain ... ok 18427 ms
plan_expand_hypertable-15 ... ok 19226 ms
plan_hashagg-15 ... ok 19263 ms
plan_hypertable_inline-15 ... ok 19222 ms
plan_ordered_append ... ok 19257 ms
query-15 ... ok 19224 ms
relocate_extension ... ok 20441 ms
reloptions ... ok 19214 ms
rowsecurity-15 ... ok 19241 ms
size_utils ... ok 19214 ms
sort_optimization ... ok 19218 ms
sql_query ... ok 19221 ms
tableam ... ok 19213 ms
timestamp ... ok 19228 ms
triggers ... ok 19227 ms
truncate ... ok 19761 ms
trusted_extension ... ok 19856 ms
update-15 ... ok 19210 ms
upsert ... ok 19227 ms
parallel group (4 tests): util vacuum_parallel version vacuum
util ... ok 1561 ms
vacuum ... ok 1591 ms
vacuum_parallel ... ok 1588 ms
version ... ok 1591 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".