old_snapshot
The functionality provided allows a transaction to see a snapshot of the database as it existed at the start of the transaction, even if that snapshot would normally be discarded due to the passage of time or other transactions completing.
Information Analysis
| Extensibility Types: | Functions |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 160 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 160 |
| 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 old_snapshot ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 190 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 old_snapshot ==============
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 old_snapshot ==============
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_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 old_snapshot ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 25 ms
test version ... ok 22 ms
test guc ... ok 21 ms
test pgsm_query_id ... ok 650 ms
test functions ... FAILED 83 ms
test counters ... ok 92 ms
test relations ... ok 198 ms
test database ... ok 453 ms
test error_insert ... ok 56 ms
test application_name ... ok 23 ms
test application_name_unique ... ok 24 ms
test top_query ... ok 31 ms
test cmd_type ... ok 64 ms
test error ... ok 29 ms
test rows ... ok 76 ms
test tags ... ok 50 ms
test user ... ok 80 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 old_snapshot ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 22 ms
test version ... ok 39 ms
test guc ... ok 26 ms
test pgsm_query_id ... ok 362 ms
test functions ... FAILED 40 ms
test counters ... ok 36 ms
test relations ... ok 96 ms
test database ... ok 272 ms
test error_insert ... ok 47 ms
test application_name ... ok 45 ms
test application_name_unique ... ok 19 ms
test top_query ... ok 27 ms
test cmd_type ... ok 41 ms
test error ... ok 22 ms
test rows ... ok 50 ms
test tags ... ok 44 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 old_snapshot ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 52 ms
test pgextwlist ... FAILED 85 ms
test errors ... FAILED 8 ms
test crossuser ... ok 29 ms
test hooks ... ok 17 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 old_snapshot ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 34 ms
test pgextwlist ... FAILED 79 ms
test errors ... FAILED 13 ms
test crossuser ... ok 45 ms
test hooks ... ok 25 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 1165 ms
test alternate_users ... ok 775 ms
test chunk_utils ... ok 886 ms
test index ... ok 1020 ms
test pg_dump_unprivileged ... ok 796 ms
test tablespace ... ok 741 ms
parallel group (21 tests): create_hypertable create_table cursor-15 broken_tables chunks drop_extension agg_bookends-15 ddl_errors cluster-15 baserel_cache ddl_extra create_chunks delete-15 custom_type ddl-15 drop_hypertable chunk_adaptive copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5248 ms
append-15 ... ok 6771 ms
baserel_cache ... ok 5250 ms
broken_tables ... ok 5244 ms
chunk_adaptive ... ok 5261 ms
chunks ... ok 5245 ms
cluster-15 ... ok 5249 ms
constraint-15 ... ok 5342 ms
copy-15 ... ok 5268 ms
create_chunks ... ok 5251 ms
create_hypertable ... ok 5239 ms
create_table ... ok 5240 ms
cursor-15 ... ok 5240 ms
custom_type ... ok 5251 ms
ddl-15 ... ok 5251 ms
ddl_errors ... ok 5248 ms
ddl_extra ... ok 5250 ms
delete-15 ... ok 5250 ms
drop_extension ... FAILED 5245 ms
drop_hypertable ... ok 5251 ms
drop_owned ... ok 5377 ms
parallel group (21 tests): license hash misc generated_as_identity partitioning dump_meta grant_hypertable histogram_test drop_schema parallel-15 drop_rename_hypertable lateral information_views insert_returning merge extension_scripts insert_single partition null_exclusion insert-15 insert_many
drop_rename_hypertable ... ok 6329 ms
drop_schema ... ok 6324 ms
dump_meta ... ok 6324 ms
extension_scripts ... ok 6340 ms
generated_as_identity ... ok 6320 ms
grant_hypertable ... ok 6324 ms
hash ... ok 6306 ms
histogram_test ... ok 6324 ms
information_views ... ok 6333 ms
insert-15 ... ok 6547 ms
insert_many ... ok 7440 ms
insert_returning ... ok 6333 ms
insert_single ... ok 6341 ms
lateral ... ok 6330 ms
license ... ok 5166 ms
merge ... ok 6333 ms
misc ... ok 6305 ms
null_exclusion ... ok 6364 ms
parallel-15 ... ok 6325 ms
partition ... ok 6340 ms
partitioning ... ok 6320 ms
parallel group (21 tests): reloptions sql_query tableam update-15 rowsecurity-15 sort_optimization query-15 size_utils partitionwise-15 timestamp plan_hypertable_inline-15 plain upsert triggers plan_ordered_append plan_expand_hypertable-15 trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7707 ms
pg_join ... ok 9957 ms
plain ... ok 7709 ms
plan_expand_hypertable-15 ... ok 7727 ms
plan_hashagg-15 ... ok 9058 ms
plan_hypertable_inline-15 ... ok 7709 ms
plan_ordered_append ... ok 7715 ms
query-15 ... ok 7703 ms
relocate_extension ... ok 8375 ms
reloptions ... ok 7135 ms
rowsecurity-15 ... ok 7700 ms
size_utils ... ok 7706 ms
sort_optimization ... ok 7699 ms
sql_query ... ok 7699 ms
tableam ... ok 7699 ms
timestamp ... ok 7706 ms
triggers ... ok 7711 ms
truncate ... ok 8124 ms
trusted_extension ... ok 8072 ms
update-15 ... ok 7698 ms
upsert ... ok 7708 ms
parallel group (4 tests): version util vacuum_parallel vacuum
util ... ok 676 ms
vacuum ... ok 679 ms
vacuum_parallel ... ok 678 ms
version ... ok 669 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 1174 ms
test alternate_users ... ok 830 ms
test chunk_utils ... ok 877 ms
test index ... ok 1016 ms
test pg_dump_unprivileged ... ok 788 ms
test tablespace ... ok 752 ms
parallel group (21 tests): baserel_cache chunk_adaptive create_chunks ddl_extra create_table create_hypertable ddl-15 chunks broken_tables cluster-15 custom_type cursor-15 agg_bookends-15 delete-15 drop_extension ddl_errors drop_hypertable copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5439 ms
append-15 ... ok 7103 ms
baserel_cache ... ok 5417 ms
broken_tables ... ok 5437 ms
chunk_adaptive ... ok 5419 ms
chunks ... ok 5436 ms
cluster-15 ... ok 5437 ms
constraint-15 ... ok 5556 ms
copy-15 ... ok 5461 ms
create_chunks ... ok 5421 ms
create_hypertable ... ok 5434 ms
create_table ... ok 5431 ms
cursor-15 ... ok 5437 ms
custom_type ... ok 5437 ms
ddl-15 ... ok 5434 ms
ddl_errors ... ok 5440 ms
ddl_extra ... ok 5427 ms
delete-15 ... ok 5438 ms
drop_extension ... FAILED 5439 ms
drop_hypertable ... ok 5440 ms
drop_owned ... ok 5564 ms
parallel group (21 tests): hash partitioning drop_schema lateral merge generated_as_identity dump_meta parallel-15 insert_returning histogram_test license null_exclusion insert_single misc grant_hypertable drop_rename_hypertable information_views extension_scripts partition insert-15 insert_many
drop_rename_hypertable ... ok 6231 ms
drop_schema ... ok 6199 ms
dump_meta ... ok 6207 ms
extension_scripts ... ok 6235 ms
generated_as_identity ... ok 6199 ms
grant_hypertable ... ok 6222 ms
hash ... ok 4816 ms
histogram_test ... ok 6215 ms
information_views ... ok 6232 ms
insert-15 ... ok 6447 ms
insert_many ... ok 7552 ms
insert_returning ... ok 6212 ms
insert_single ... ok 6221 ms
lateral ... ok 6198 ms
license ... ok 6218 ms
merge ... ok 6198 ms
misc ... ok 6221 ms
null_exclusion ... ok 6221 ms
parallel-15 ... ok 6205 ms
partition ... ok 6240 ms
partitioning ... ok 6196 ms
parallel group (21 tests): tableam partitionwise-15 triggers timestamp upsert sql_query reloptions plain size_utils sort_optimization plan_hypertable_inline-15 rowsecurity-15 update-15 query-15 plan_ordered_append plan_expand_hypertable-15 trusted_extension relocate_extension truncate plan_hashagg-15 pg_join
partitionwise-15 ... ok 8643 ms
pg_join ... ok 10512 ms
plain ... ok 8662 ms
plan_expand_hypertable-15 ... ok 8691 ms
plan_hashagg-15 ... ok 9155 ms
plan_hypertable_inline-15 ... ok 8666 ms
plan_ordered_append ... ok 8690 ms
query-15 ... ok 8685 ms
relocate_extension ... ok 8767 ms
reloptions ... ok 8658 ms
rowsecurity-15 ... ok 8669 ms
size_utils ... ok 8661 ms
sort_optimization ... ok 8663 ms
sql_query ... ok 8657 ms
tableam ... ok 8641 ms
timestamp ... ok 8644 ms
triggers ... ok 8644 ms
truncate ... ok 8768 ms
trusted_extension ... ok 8752 ms
update-15 ... ok 8668 ms
upsert ... ok 8644 ms
parallel group (4 tests): version util vacuum_parallel vacuum
util ... ok 778 ms
vacuum ... ok 781 ms
vacuum_parallel ... ok 780 ms
version ... ok 771 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".