pg_partman
Repository:
https://github.com/pgpartman/pg_partman
Partition management is automated through a set of functions and background worker processes that handle creation, maintenance, and retention of partitioned tables based on predefined rules and constraints.
Information Analysis
Duplicate Code Analysis
| Total Lines of Code: ? | 530 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 530 |
| Lines of Encapsulated Versioning Code: ? | 62 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 11.7% |
| PostgreSQL Versions Cased On: ? | 9,10,11 |
Compatibility Analysis
| Number of Failed Extensions: | 7 |
| Failure Rate: | 6.8% |
Failed Extensions
earthdistance
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 210 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 157 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".
waiting for server to shut down.... done
server stopped
pg_queryid
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 72 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_repack
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 TABLESPACE
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test init-extension ... ok 18 ms
test repack-setup ... ok 564 ms
test repack-run ... FAILED 1699 ms
test error-on-invalid-idx ... FAILED 1520 ms
test after-schema ... ok 65 ms
test repack-check ... ok 3959 ms
test nosuper ... ok 234 ms
test tablespace ... ok 1933 ms
test get_order_by ... ok 966 ms
======================
2 of 9 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.out".
ERROR: tablespace "testts" is not empty
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
CREATE TABLESPACE
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test init-extension ... ok 13 ms
test repack-setup ... ok 245 ms
test repack-run ... FAILED 1001 ms
test error-on-invalid-idx ... FAILED 956 ms
test after-schema ... ok 34 ms
test repack-check ... ok 2520 ms
test nosuper ... ok 127 ms
test tablespace ... ok 1088 ms
test get_order_by ... ok 672 ms
======================
2 of 9 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.out".
ERROR: tablespace "testts" is not empty
waiting for server to shut down.... done
server stopped
pg_stat_kcache
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_monitor
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 23 ms
test version ... ok 18 ms
test guc ... ok 19 ms
test pgsm_query_id ... ok 709 ms
test functions ... FAILED 60 ms
test counters ... ok 92 ms
test relations ... ok 190 ms
test database ... ok 491 ms
test error_insert ... ok 87 ms
test application_name ... ok 50 ms
test application_name_unique ... ok 31 ms
test top_query ... ok 39 ms
test cmd_type ... ok 61 ms
test error ... ok 32 ms
test rows ... ok 71 ms
test tags ... ok 31 ms
test user ... ok 93 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 16 ms
test version ... ok 15 ms
test guc ... ok 16 ms
test pgsm_query_id ... ok 327 ms
test functions ... FAILED 41 ms
test counters ... ok 51 ms
test relations ... ok 104 ms
test database ... ok 256 ms
test error_insert ... ok 35 ms
test application_name ... ok 20 ms
test application_name_unique ... ok 16 ms
test top_query ... ok 18 ms
test cmd_type ... ok 25 ms
test error ... ok 15 ms
test rows ... ok 56 ms
test tags ... ok 34 ms
test user ... ok 50 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
pgextwlist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 61 ms
test pgextwlist ... FAILED 82 ms
test errors ... FAILED 8 ms
test crossuser ... ok 44 ms
test hooks ... ok 31 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_partman ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 26 ms
test pgextwlist ... FAILED 44 ms
test errors ... FAILED 8 ms
test crossuser ... ok 33 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 1176 ms
test alternate_users ... FAILED 800 ms
test chunk_utils ... ok 889 ms
test index ... ok 1037 ms
test pg_dump_unprivileged ... ok 785 ms
test tablespace ... ok 770 ms
parallel group (21 tests): custom_type cluster-15 baserel_cache ddl_errors agg_bookends-15 broken_tables create_table ddl_extra chunks drop_hypertable cursor-15 drop_extension create_chunks delete-15 ddl-15 create_hypertable copy-15 chunk_adaptive constraint-15 drop_owned append-15
agg_bookends-15 ... ok 4682 ms
append-15 ... ok 6628 ms
baserel_cache ... ok 4677 ms
broken_tables ... ok 4682 ms
chunk_adaptive ... ok 4715 ms
chunks ... ok 4687 ms
cluster-15 ... ok 4676 ms
constraint-15 ... ok 4833 ms
copy-15 ... ok 4708 ms
create_chunks ... ok 4688 ms
create_hypertable ... ok 4702 ms
create_table ... ok 4682 ms
cursor-15 ... ok 4687 ms
custom_type ... ok 4674 ms
ddl-15 ... ok 4694 ms
ddl_errors ... ok 4679 ms
ddl_extra ... ok 4685 ms
delete-15 ... ok 4690 ms
drop_extension ... FAILED 4686 ms
drop_hypertable ... FAILED 4686 ms
drop_owned ... ok 4841 ms
parallel group (21 tests): drop_schema generated_as_identity misc dump_meta license hash parallel-15 merge grant_hypertable partition partitioning extension_scripts drop_rename_hypertable information_views lateral insert_returning null_exclusion histogram_test insert_single insert-15 insert_many
drop_rename_hypertable ... FAILED 5976 ms
drop_schema ... ok 4705 ms
dump_meta ... FAILED 5955 ms
extension_scripts ... ok 5974 ms
generated_as_identity ... ok 5948 ms
grant_hypertable ... ok 5969 ms
hash ... ok 5961 ms
histogram_test ... ok 5998 ms
information_views ... ok 5975 ms
insert-15 ... ok 6152 ms
insert_many ... ok 7405 ms
insert_returning ... ok 5996 ms
insert_single ... ok 6001 ms
lateral ... ok 5991 ms
license ... ok 5954 ms
merge ... ok 5966 ms
misc ... ok 5952 ms
null_exclusion ... ok 5997 ms
parallel-15 ... ok 5964 ms
partition ... ok 5969 ms
partitioning ... ok 5969 ms
parallel group (21 tests): plain sort_optimization tableam sql_query partitionwise-15 plan_hypertable_inline-15 triggers upsert update-15 reloptions timestamp query-15 size_utils rowsecurity-15 plan_expand_hypertable-15 plan_ordered_append trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7852 ms
pg_join ... ok 9773 ms
plain ... FAILED 7122 ms
plan_expand_hypertable-15 ... ok 7878 ms
plan_hashagg-15 ... ok 9089 ms
plan_hypertable_inline-15 ... ok 7853 ms
plan_ordered_append ... ok 7886 ms
query-15 ... ok 7868 ms
relocate_extension ... ok 8018 ms
reloptions ... ok 7855 ms
rowsecurity-15 ... ok 7874 ms
size_utils ... ok 7873 ms
sort_optimization ... ok 7846 ms
sql_query ... ok 7850 ms
tableam ... ok 7847 ms
timestamp ... ok 7862 ms
triggers ... ok 7852 ms
truncate ... ok 8017 ms
trusted_extension ... ok 7988 ms
update-15 ... ok 7853 ms
upsert ... ok 7851 ms
parallel group (4 tests): version util vacuum_parallel vacuum
util ... ok 666 ms
vacuum ... ok 672 ms
vacuum_parallel ... ok 669 ms
version ... ok 658 ms
=======================
6 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 2355 ms
test alternate_users ... FAILED 1626 ms
test chunk_utils ... ok 1771 ms
test index ... ok 2150 ms
test pg_dump_unprivileged ... ok 1437 ms
test tablespace ... ok 1459 ms
parallel group (21 tests): baserel_cache ddl_extra ddl-15 ddl_errors broken_tables drop_extension create_table chunks cursor-15 agg_bookends-15 create_chunks create_hypertable custom_type drop_hypertable cluster-15 delete-15 append-15 copy-15 chunk_adaptive constraint-15 drop_owned
agg_bookends-15 ... ok 11390 ms
append-15 ... ok 11408 ms
baserel_cache ... ok 11372 ms
broken_tables ... ok 11387 ms
chunk_adaptive ... ok 11431 ms
chunks ... ok 11389 ms
cluster-15 ... ok 11398 ms
constraint-15 ... ok 11615 ms
copy-15 ... ok 11424 ms
create_chunks ... ok 11390 ms
create_hypertable ... ok 11394 ms
create_table ... ok 11388 ms
cursor-15 ... ok 11389 ms
custom_type ... ok 11396 ms
ddl-15 ... ok 11383 ms
ddl_errors ... ok 11385 ms
ddl_extra ... ok 11381 ms
delete-15 ... ok 11397 ms
drop_extension ... FAILED 11385 ms
drop_hypertable ... FAILED 11396 ms
drop_owned ... ok 11671 ms
parallel group (21 tests): hash null_exclusion parallel-15 partition generated_as_identity merge partitioning misc drop_rename_hypertable grant_hypertable histogram_test dump_meta extension_scripts insert_single insert_returning information_views lateral drop_schema license insert-15 insert_many
drop_rename_hypertable ... FAILED 14820 ms
drop_schema ... ok 14826 ms
dump_meta ... FAILED 14823 ms
extension_scripts ... ok 14824 ms
generated_as_identity ... ok 14820 ms
grant_hypertable ... ok 14820 ms
hash ... ok 10860 ms
histogram_test ... ok 14822 ms
information_views ... ok 14825 ms
insert-15 ... ok 15228 ms
insert_many ... ok 17402 ms
insert_returning ... ok 14825 ms
insert_single ... ok 14824 ms
lateral ... ok 14825 ms
license ... ok 14826 ms
merge ... ok 14818 ms
misc ... ok 14818 ms
null_exclusion ... ok 14797 ms
parallel-15 ... ok 14818 ms
partition ... ok 14818 ms
partitioning ... ok 14818 ms
parallel group (21 tests): tableam plain timestamp reloptions size_utils update-15 query-15 upsert partitionwise-15 plan_hypertable_inline-15 plan_expand_hypertable-15 sql_query triggers sort_optimization rowsecurity-15 plan_hashagg-15 plan_ordered_append pg_join truncate trusted_extension relocate_extension
partitionwise-15 ... ok 19631 ms
pg_join ... ok 20232 ms
plain ... FAILED 19617 ms
plan_expand_hypertable-15 ... ok 19665 ms
plan_hashagg-15 ... ok 19771 ms
plan_hypertable_inline-15 ... ok 19631 ms
plan_ordered_append ... ok 19771 ms
query-15 ... ok 19624 ms
relocate_extension ... ok 20309 ms
reloptions ... ok 19623 ms
rowsecurity-15 ... ok 19744 ms
size_utils ... ok 19624 ms
sort_optimization ... ok 19727 ms
sql_query ... ok 19723 ms
tableam ... ok 19601 ms
timestamp ... ok 19615 ms
triggers ... ok 19726 ms
truncate ... ok 20283 ms
trusted_extension ... ok 20287 ms
update-15 ... ok 19623 ms
upsert ... ok 19629 ms
parallel group (4 tests): version util vacuum vacuum_parallel
util ... ok 1595 ms
vacuum ... ok 1598 ms
vacuum_parallel ... ok 1598 ms
version ... ok 1569 ms
=======================
6 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".