btree_gist
The btree_gist implementation provides a GiST (Generalized Search Tree) index operator class that supports efficient searching and indexing of data types using B-tree-like algorithms, allowing for range queries and other advanced search operations on normally non-indexable data.
Information Analysis
| Extensibility Types: | Functions, Types, Index Access Methods |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 6147 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 6147 |
| Lines of Encapsulated Versioning Code: ? | 0 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0% |
Compatibility Analysis
| Number of Failed Extensions: | 17 |
| Failure Rate: | 15.3% |
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 "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube ==============
CREATE EXTENSION
============== installing earthdistance ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 37 ms
test int2 ... ok 34 ms
test int4 ... ok 29 ms
test int8 ... ok 28 ms
test float4 ... ok 52 ms
test float8 ... ok 53 ms
test cash ... ok 50 ms
test oid ... ok 39 ms
test timestamp ... ok 38 ms
test timestamptz ... ok 39 ms
test time ... ok 30 ms
test timetz ... ok 179 ms
test date ... ok 51 ms
test interval ... ok 52 ms
test macaddr ... ok 50 ms
test macaddr8 ... ok 50 ms
test inet ... ok 82 ms
test cidr ... ok 54 ms
test text ... ok 79 ms
test varchar ... ok 37 ms
test char ... ok 40 ms
test bytea ... ok 70 ms
test bit ... ok 37 ms
test varbit ... ok 51 ms
test numeric ... ok 82 ms
test uuid ... ok 20 ms
test not_equal ... ok 92 ms
test enum ... ok 31 ms
test bool ... ok 29 ms
======================
All 29 tests passed.
======================
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 186 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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 259 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".
(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 cube ==============
CREATE EXTENSION
============== installing earthdistance ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 61 ms
test int2 ... ok 20 ms
test int4 ... ok 37 ms
test int8 ... ok 47 ms
test float4 ... ok 38 ms
test float8 ... ok 37 ms
test cash ... ok 40 ms
test oid ... ok 34 ms
test timestamp ... ok 35 ms
test timestamptz ... ok 50 ms
test time ... ok 39 ms
test timetz ... ok 175 ms
test date ... ok 51 ms
test interval ... ok 54 ms
test macaddr ... ok 55 ms
test macaddr8 ... ok 50 ms
test inet ... ok 84 ms
test cidr ... ok 59 ms
test text ... ok 77 ms
test varchar ... ok 29 ms
test char ... ok 31 ms
test bytea ... ok 41 ms
test bit ... ok 42 ms
test varbit ... ok 64 ms
test numeric ... ok 99 ms
test uuid ... ok 20 ms
test not_equal ... ok 72 ms
test enum ... ok 56 ms
test bool ... ok 43 ms
======================
All 29 tests passed.
======================
waiting for server to shut down.... done
server stopped
imcs
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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 36 ms
test int2 ... ok 19 ms
test int4 ... ok 18 ms
test int8 ... ok 17 ms
test float4 ... FAILED 34 ms
test float8 ... FAILED 48 ms
test cash ... ok 33 ms
test oid ... ok 36 ms
test timestamp ... ok 38 ms
test timestamptz ... ok 68 ms
test time ... ok 31 ms
test timetz ... ok 143 ms
test date ... ok 50 ms
test interval ... ok 51 ms
test macaddr ... ok 50 ms
test macaddr8 ... ok 48 ms
test inet ... ok 79 ms
test cidr ... ok 55 ms
test text ... ok 49 ms
test varchar ... ok 29 ms
test char ... ok 46 ms
test bytea ... ok 39 ms
test bit ... ok 27 ms
test varbit ... ok 48 ms
test numeric ... ok 89 ms
test uuid ... ok 25 ms
test not_equal ... ok 78 ms
test enum ... ok 55 ms
test bool ... ok 42 ms
=======================
2 of 29 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/btree_gist/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/btree_gist/regression.out".
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 222 ms
test span ... ok 18 ms
test operators ... ok 30 ms
test math ... ok 14 ms
test datetime ... ok 17 ms
test transform ... ok 27 ms
test scalarop ... ok 12 ms
test grandagg ... ok 19 ms
test groupbyagg ... ok 17 ms
test gridagg ... ok 12 ms
test windowagg ... ok 15 ms
test hashagg ... ok 26 ms
test cumagg ... ok 25 ms
test sort ... ok 35 ms
test spec ... ok 36 ms
test drop ... ok 29 ms
======================
All 16 tests passed.
======================
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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 159 ms
test span ... ok 17 ms
test operators ... ok 31 ms
test math ... ok 16 ms
test datetime ... ok 18 ms
test transform ... ok 28 ms
test scalarop ... ok 12 ms
test grandagg ... ok 20 ms
test groupbyagg ... ok 17 ms
test gridagg ... ok 12 ms
test windowagg ... ok 15 ms
test hashagg ... ok 22 ms
test cumagg ... ok 13 ms
test sort ... ok 24 ms
test spec ... ok 29 ms
test drop ... ok 30 ms
======================
All 16 tests passed.
======================
(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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 80 ms
test int2 ... ok 32 ms
test int4 ... ok 29 ms
test int8 ... ok 34 ms
test float4 ... FAILED 31 ms
test float8 ... FAILED 31 ms
test cash ... ok 41 ms
test oid ... ok 45 ms
test timestamp ... ok 54 ms
test timestamptz ... ok 64 ms
test time ... ok 37 ms
test timetz ... ok 179 ms
test date ... ok 36 ms
test interval ... ok 35 ms
test macaddr ... ok 36 ms
test macaddr8 ... ok 42 ms
test inet ... ok 83 ms
test cidr ... ok 55 ms
test text ... ok 75 ms
test varchar ... ok 27 ms
test char ... ok 31 ms
test bytea ... ok 45 ms
test bit ... ok 31 ms
test varbit ... ok 57 ms
test numeric ... ok 96 ms
test uuid ... ok 106 ms
test not_equal ... ok 113 ms
test enum ... ok 55 ms
test bool ... ok 41 ms
=======================
2 of 29 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/btree_gist/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/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
ip4r
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 ip4r ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 37 ms
test int2 ... ok 35 ms
test int4 ... ok 49 ms
test int8 ... ok 48 ms
test float4 ... FAILED 37 ms
test float8 ... FAILED 37 ms
test cash ... ok 36 ms
test oid ... ok 35 ms
test timestamp ... ok 38 ms
test timestamptz ... ok 62 ms
test time ... ok 51 ms
test timetz ... ok 180 ms
test date ... ok 49 ms
test interval ... ok 50 ms
test macaddr ... ok 36 ms
test macaddr8 ... ok 35 ms
test inet ... ok 75 ms
test cidr ... ok 48 ms
test text ... ok 76 ms
test varchar ... ok 28 ms
test char ... ok 32 ms
test bytea ... ok 40 ms
test bit ... ok 23 ms
test varbit ... ok 34 ms
test numeric ... ok 72 ms
test uuid ... ok 26 ms
test not_equal ... ok 92 ms
test enum ... ok 55 ms
test bool ... ok 42 ms
=======================
2 of 29 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/btree_gist/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/btree_gist/regression.out".
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test ip4r ... ok 1416 ms
test ip4r-v11 ... ok 9 ms
=====================
All 2 tests passed.
=====================
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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test ip4r ... ok 1475 ms
test ip4r-v11 ... ok 9 ms
=====================
All 2 tests passed.
=====================
(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 ip4r ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 40 ms
test int2 ... ok 20 ms
test int4 ... ok 38 ms
test int8 ... ok 47 ms
test float4 ... FAILED 37 ms
test float8 ... FAILED 37 ms
test cash ... ok 36 ms
test oid ... ok 35 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 48 ms
test time ... ok 37 ms
test timetz ... ok 167 ms
test date ... ok 50 ms
test interval ... ok 49 ms
test macaddr ... ok 41 ms
test macaddr8 ... ok 36 ms
test inet ... ok 62 ms
test cidr ... ok 39 ms
test text ... ok 60 ms
test varchar ... ok 36 ms
test char ... ok 56 ms
test bytea ... ok 43 ms
test bit ... ok 26 ms
test varbit ... ok 52 ms
test numeric ... ok 76 ms
test uuid ... ok 36 ms
test not_equal ... ok 84 ms
test enum ... ok 52 ms
test bool ... ok 42 ms
=======================
2 of 29 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/btree_gist/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/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
isn
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 isn ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 45 ms
test int2 ... ok 29 ms
test int4 ... ok 30 ms
test int8 ... ok 30 ms
test float4 ... ok 31 ms
test float8 ... ok 45 ms
test cash ... ok 50 ms
test oid ... ok 42 ms
test timestamp ... ok 45 ms
test timestamptz ... ok 69 ms
test time ... ok 32 ms
test timetz ... ok 182 ms
test date ... ok 50 ms
test interval ... ok 53 ms
test macaddr ... ok 51 ms
test macaddr8 ... ok 49 ms
test inet ... ok 83 ms
test cidr ... ok 53 ms
test text ... ok 80 ms
test varchar ... ok 38 ms
test char ... ok 40 ms
test bytea ... ok 74 ms
test bit ... ok 56 ms
test varbit ... ok 62 ms
test numeric ... ok 100 ms
test uuid ... ok 37 ms
test not_equal ... ok 110 ms
test enum ... ok 47 ms
test bool ... ok 39 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/regression.out".
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test isn ... ok 117 ms
=====================
All 1 tests passed.
=====================
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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test isn ... ok 69 ms
=====================
All 1 tests passed.
=====================
(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 isn ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 35 ms
test int2 ... ok 20 ms
test int4 ... ok 37 ms
test int8 ... ok 50 ms
test float4 ... ok 152 ms
test float8 ... ok 53 ms
test cash ... ok 50 ms
test oid ... ok 46 ms
test timestamp ... ok 51 ms
test timestamptz ... ok 70 ms
test time ... ok 36 ms
test timetz ... ok 175 ms
test date ... ok 33 ms
test interval ... ok 29 ms
test macaddr ... ok 32 ms
test macaddr8 ... ok 31 ms
test inet ... ok 63 ms
test cidr ... ok 36 ms
test text ... ok 69 ms
test varchar ... ok 38 ms
test char ... ok 40 ms
test bytea ... ok 71 ms
test bit ... ok 49 ms
test varbit ... ok 47 ms
test numeric ... ok 85 ms
test uuid ... ok 22 ms
test not_equal ... ok 90 ms
test enum ... ok 56 ms
test bool ... ok 41 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
lsm3
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 lsm3 ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 32 ms
test int2 ... ok 12 ms
test int4 ... ok 12 ms
test int8 ... ok 12 ms
test float4 ... ok 12 ms
test float8 ... ok 29 ms
test cash ... ok 43 ms
test oid ... ok 40 ms
test timestamp ... ok 44 ms
test timestamptz ... ok 32 ms
test time ... ok 23 ms
test timetz ... ok 76 ms
test date ... ok 43 ms
test interval ... ok 45 ms
test macaddr ... ok 23 ms
test macaddr8 ... ok 22 ms
test inet ... ok 55 ms
test cidr ... ok 48 ms
test text ... ok 62 ms
test varchar ... ok 20 ms
test char ... ok 16 ms
test bytea ... ok 23 ms
test bit ... ok 12 ms
test varbit ... ok 36 ms
test numeric ... ok 62 ms
test uuid ... ok 13 ms
test not_equal ... ok 71 ms
test enum ... ok 52 ms
test bool ... ok 39 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/regression.out".
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test test ... ok 11167 ms
=====================
All 1 tests passed.
=====================
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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test test ... ok 11474 ms
=====================
All 1 tests passed.
=====================
(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 lsm3 ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 31 ms
test int2 ... ok 11 ms
test int4 ... ok 11 ms
test int8 ... ok 11 ms
test float4 ... ok 12 ms
test float8 ... ok 12 ms
test cash ... ok 15 ms
test oid ... ok 11 ms
test timestamp ... ok 12 ms
test timestamptz ... ok 17 ms
test time ... ok 13 ms
test timetz ... ok 53 ms
test date ... ok 42 ms
test interval ... ok 45 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 18 ms
test inet ... ok 28 ms
test cidr ... ok 20 ms
test text ... ok 30 ms
test varchar ... ok 24 ms
test char ... ok 26 ms
test bytea ... ok 30 ms
test bit ... ok 18 ms
test varbit ... ok 33 ms
test numeric ... ok 91 ms
test uuid ... ok 15 ms
test not_equal ... ok 48 ms
test enum ... ok 25 ms
test bool ... ok 18 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
pg_bigm
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_bigm ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 72 ms
test int2 ... ok 16 ms
test int4 ... ok 32 ms
test int8 ... ok 35 ms
test float4 ... ok 34 ms
test float8 ... ok 45 ms
test cash ... ok 49 ms
test oid ... ok 45 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 45 ms
test time ... ok 33 ms
test timetz ... ok 133 ms
test date ... ok 47 ms
test interval ... ok 52 ms
test macaddr ... ok 48 ms
test macaddr8 ... ok 47 ms
test inet ... ok 57 ms
test cidr ... ok 38 ms
test text ... ok 58 ms
test varchar ... ok 42 ms
test char ... ok 27 ms
test bytea ... ok 43 ms
test bit ... ok 28 ms
test varbit ... ok 39 ms
test numeric ... ok 76 ms
test uuid ... ok 21 ms
test not_equal ... ok 81 ms
test enum ... ok 45 ms
test bool ... ok 39 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/regression.out".
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_bigm ... ok 115 ms
test pg_bigm_ja ... ok 158 ms
=====================
All 2 tests passed.
=====================
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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_bigm ... ok 164 ms
test pg_bigm_ja ... ok 56 ms
=====================
All 2 tests passed.
=====================
(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_bigm ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 41 ms
test int2 ... ok 18 ms
test int4 ... ok 18 ms
test int8 ... ok 18 ms
test float4 ... ok 19 ms
test float8 ... ok 19 ms
test cash ... ok 20 ms
test oid ... ok 25 ms
test timestamp ... ok 36 ms
test timestamptz ... ok 56 ms
test time ... ok 44 ms
test timetz ... ok 180 ms
test date ... ok 49 ms
test interval ... ok 52 ms
test macaddr ... ok 54 ms
test macaddr8 ... ok 49 ms
test inet ... ok 63 ms
test cidr ... ok 54 ms
test text ... ok 79 ms
test varchar ... ok 36 ms
test char ... ok 51 ms
test bytea ... ok 75 ms
test bit ... ok 51 ms
test varbit ... ok 66 ms
test numeric ... ok 92 ms
test uuid ... ok 21 ms
test not_equal ... ok 70 ms
test enum ... ok 51 ms
test bool ... ok 143 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
pg_hint_plan
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_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 63 ms
test int2 ... ok 19 ms
test int4 ... ok 20 ms
test int8 ... ok 38 ms
test float4 ... ok 53 ms
test float8 ... ok 51 ms
test cash ... ok 31 ms
test oid ... ok 29 ms
test timestamp ... ok 31 ms
test timestamptz ... ok 40 ms
test time ... ok 31 ms
test timetz ... ok 164 ms
test date ... ok 45 ms
test interval ... ok 55 ms
test macaddr ... ok 52 ms
test macaddr8 ... ok 50 ms
test inet ... ok 85 ms
test cidr ... ok 56 ms
test text ... ok 76 ms
test varchar ... ok 31 ms
test char ... ok 32 ms
test bytea ... ok 40 ms
test bit ... ok 24 ms
test varbit ... ok 30 ms
test numeric ... ok 96 ms
test uuid ... ok 23 ms
test not_equal ... ok 101 ms
test enum ... ok 50 ms
test bool ... ok 43 ms
======================
All 29 tests passed.
======================
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2902 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7607 ms
test ut-init ... FAILED 1451 ms
test ut-A ... ok 651 ms
test ut-S ... ok 223 ms
test ut-J ... ok 126 ms
test ut-L ... ok 96 ms
test ut-G ... ok 49 ms
test ut-R ... ok 498 ms
test ut-fdw ... ok 92 ms
test ut-W ... ok 124 ms
test ut-T ... ok 25 ms
test ut-fini ... ok 33 ms
test hints_anywhere ... ok 26 ms
test plpgsql ... ok 89 ms
test oldextversions ... ok 146 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_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1347 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7437 ms
test ut-init ... FAILED 831 ms
test ut-A ... ok 379 ms
test ut-S ... ok 194 ms
test ut-J ... ok 133 ms
test ut-L ... ok 94 ms
test ut-G ... ok 31 ms
test ut-R ... ok 444 ms
test ut-fdw ... ok 37 ms
test ut-W ... ok 81 ms
test ut-T ... ok 24 ms
test ut-fini ... ok 21 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 135 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_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(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_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 58 ms
test int2 ... ok 12 ms
test int4 ... ok 11 ms
test int8 ... ok 11 ms
test float4 ... ok 11 ms
test float8 ... ok 12 ms
test cash ... ok 11 ms
test oid ... ok 10 ms
test timestamp ... ok 11 ms
test timestamptz ... ok 15 ms
test time ... ok 13 ms
test timetz ... ok 74 ms
test date ... ok 19 ms
test interval ... ok 12 ms
test macaddr ... ok 11 ms
test macaddr8 ... ok 11 ms
test inet ... ok 21 ms
test cidr ... ok 15 ms
test text ... ok 23 ms
test varchar ... ok 17 ms
test char ... ok 20 ms
test bytea ... ok 45 ms
test bit ... ok 23 ms
test varbit ... ok 27 ms
test numeric ... ok 68 ms
test uuid ... ok 13 ms
test not_equal ... ok 28 ms
test enum ... ok 12 ms
test bool ... ok 14 ms
======================
All 29 tests passed.
======================
waiting for server to shut down.... done
server stopped
pg_query_rewrite
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_query_rewrite ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 55 ms
test int2 ... ok 19 ms
test int4 ... ok 19 ms
test int8 ... ok 23 ms
test float4 ... ok 23 ms
test float8 ... ok 26 ms
test cash ... ok 35 ms
test oid ... ok 32 ms
test timestamp ... ok 51 ms
test timestamptz ... ok 64 ms
test time ... ok 30 ms
test timetz ... ok 173 ms
test date ... ok 55 ms
test interval ... ok 54 ms
test macaddr ... ok 51 ms
test macaddr8 ... ok 51 ms
test inet ... ok 86 ms
test cidr ... ok 56 ms
test text ... ok 79 ms
test varchar ... ok 37 ms
test char ... ok 44 ms
test bytea ... ok 73 ms
test bit ... ok 42 ms
test varbit ... ok 56 ms
test numeric ... ok 96 ms
test uuid ... ok 38 ms
test not_equal ... ok 128 ms
test enum ... ok 56 ms
test bool ... ok 42 ms
======================
All 29 tests passed.
======================
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 12 ms
test test1 ... ok 28 ms
test test2 ... ok 53 ms
test test3 ... ok 91 ms
test test4 ... ok 270 ms
test test5 ... ok 31 ms
test test6 ... ok 71 ms
test test7 ... FAILED 17 ms
test test8 ... ok 19 ms
======================
1 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_query_rewrite/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_query_rewrite/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 "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_stat_statements ==============
CREATE EXTENSION
============== installing pg_queryid ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 45 ms
test int2 ... ok 46 ms
test int4 ... ok 35 ms
test int8 ... ok 53 ms
test float4 ... ok 55 ms
test float8 ... ok 53 ms
test cash ... ok 52 ms
test oid ... ok 46 ms
test timestamp ... ok 43 ms
test timestamptz ... ok 41 ms
test time ... ok 42 ms
test timetz ... ok 193 ms
test date ... ok 52 ms
test interval ... ok 54 ms
test macaddr ... ok 52 ms
test macaddr8 ... ok 51 ms
test inet ... ok 83 ms
test cidr ... ok 34 ms
test text ... ok 56 ms
test varchar ... ok 47 ms
test char ... ok 51 ms
test bytea ... ok 70 ms
test bit ... ok 46 ms
test varbit ... ok 55 ms
test numeric ... ok 96 ms
test uuid ... ok 23 ms
test not_equal ... ok 99 ms
test enum ... ok 51 ms
test bool ... ok 44 ms
======================
All 29 tests passed.
======================
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 73 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"
(using postmaster on Unix socket, default port)
============== dropping database "contrib_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 \"contrib_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"
(using postmaster on Unix socket, default port)
============== dropping database "contrib_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 \"contrib_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_stat_monitor ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 44 ms
test int2 ... ok 21 ms
test int4 ... ok 20 ms
test int8 ... ok 20 ms
test float4 ... ok 37 ms
test float8 ... ok 56 ms
test cash ... ok 52 ms
test oid ... ok 46 ms
test timestamp ... ok 49 ms
test timestamptz ... ok 33 ms
test time ... ok 26 ms
test timetz ... ok 159 ms
test date ... ok 26 ms
test interval ... ok 24 ms
test macaddr ... ok 25 ms
test macaddr8 ... ok 25 ms
test inet ... ok 58 ms
test cidr ... ok 51 ms
test text ... ok 81 ms
test varchar ... ok 54 ms
test char ... ok 34 ms
test bytea ... ok 45 ms
test bit ... ok 27 ms
test varbit ... ok 51 ms
test numeric ... ok 97 ms
test uuid ... ok 21 ms
test not_equal ... ok 76 ms
test enum ... ok 61 ms
test bool ... ok 44 ms
======================
All 29 tests passed.
======================
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 20 ms
test version ... ok 26 ms
test guc ... ok 28 ms
test pgsm_query_id ... ok 640 ms
test functions ... FAILED 57 ms
test counters ... ok 90 ms
test relations ... ok 193 ms
test database ... ok 514 ms
test error_insert ... ok 56 ms
test application_name ... ok 22 ms
test application_name_unique ... ok 22 ms
test top_query ... ok 30 ms
test cmd_type ... ok 75 ms
test error ... ok 46 ms
test rows ... ok 97 ms
test tags ... ok 41 ms
test user ... ok 94 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 23 ms
test version ... ok 18 ms
test guc ... ok 20 ms
test pgsm_query_id ... ok 725 ms
test functions ... FAILED 77 ms
test counters ... ok 91 ms
test relations ... ok 186 ms
test database ... ok 455 ms
test error_insert ... ok 69 ms
test application_name ... ok 52 ms
test application_name_unique ... ok 39 ms
test top_query ... ok 47 ms
test cmd_type ... ok 69 ms
test error ... ok 39 ms
test rows ... ok 97 ms
test tags ... ok 46 ms
test user ... ok 90 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".
(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_stat_monitor ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 49 ms
test int2 ... ok 24 ms
test int4 ... ok 38 ms
test int8 ... ok 50 ms
test float4 ... ok 53 ms
test float8 ... ok 57 ms
test cash ... ok 48 ms
test oid ... ok 43 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 49 ms
test time ... ok 45 ms
test timetz ... ok 182 ms
test date ... ok 51 ms
test interval ... ok 58 ms
test macaddr ... ok 51 ms
test macaddr8 ... ok 51 ms
test inet ... ok 89 ms
test cidr ... ok 55 ms
test text ... ok 78 ms
test varchar ... ok 31 ms
test char ... ok 58 ms
test bytea ... ok 50 ms
test bit ... ok 36 ms
test varbit ... ok 46 ms
test numeric ... ok 89 ms
test uuid ... ok 20 ms
test not_equal ... ok 66 ms
test enum ... ok 34 ms
test bool ... ok 27 ms
======================
All 29 tests passed.
======================
waiting for server to shut down.... done
server stopped
pg_tle
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_tle ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 49 ms
test int2 ... ok 31 ms
test int4 ... ok 30 ms
test int8 ... ok 39 ms
test float4 ... ok 54 ms
test float8 ... ok 51 ms
test cash ... ok 56 ms
test oid ... ok 48 ms
test timestamp ... ok 50 ms
test timestamptz ... ok 58 ms
test time ... ok 31 ms
test timetz ... ok 167 ms
test date ... ok 51 ms
test interval ... ok 54 ms
test macaddr ... ok 50 ms
test macaddr8 ... ok 50 ms
test inet ... ok 90 ms
test cidr ... ok 56 ms
test text ... ok 79 ms
test varchar ... ok 37 ms
test char ... ok 41 ms
test bytea ... ok 56 ms
test bit ... ok 36 ms
test varbit ... ok 55 ms
test numeric ... ok 100 ms
test uuid ... ok 24 ms
test not_equal ... ok 96 ms
test enum ... ok 56 ms
test bool ... ok 43 ms
======================
All 29 tests passed.
======================
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_tle_api ... ok 439 ms
test pg_tle_management ... FAILED 370 ms
test pg_tle_injection ... FAILED 104 ms
test pg_tle_perms ... FAILED 219 ms
test pg_tle_requires ... ok 82 ms
======================
3 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_tle-1.0.4/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_tle-1.0.4/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 "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test init ... ok 48 ms
test int2 ... ok 34 ms
test int4 ... ok 50 ms
test int8 ... ok 49 ms
test float4 ... ok 51 ms
test float8 ... ok 52 ms
test cash ... ok 49 ms
test oid ... ok 45 ms
test timestamp ... ok 52 ms
test timestamptz ... ok 64 ms
test time ... ok 36 ms
test timetz ... ok 174 ms
test date ... ok 54 ms
test interval ... ok 53 ms
test macaddr ... ok 50 ms
test macaddr8 ... ok 53 ms
test inet ... ok 83 ms
test cidr ... ok 55 ms
test text ... ok 81 ms
test varchar ... ok 39 ms
test char ... ok 41 ms
test bytea ... ok 67 ms
test bit ... ok 56 ms
test varbit ... ok 65 ms
test numeric ... ok 96 ms
test uuid ... ok 39 ms
test not_equal ... ok 113 ms
test enum ... ok 43 ms
test bool ... ok 36 ms
======================
All 29 tests passed.
======================
(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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 55 ms
test pgextwlist ... FAILED 90 ms
test errors ... FAILED 19 ms
test crossuser ... ok 47 ms
test hooks ... ok 24 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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 29 ms
test pgextwlist ... FAILED 69 ms
test errors ... FAILED 7 ms
test crossuser ... ok 16 ms
test hooks ... ok 8 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
(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
============== running regression test queries ==============
test init ... ok 41 ms
test int2 ... ok 12 ms
test int4 ... ok 12 ms
test int8 ... ok 12 ms
test float4 ... ok 12 ms
test float8 ... ok 13 ms
test cash ... ok 13 ms
test oid ... ok 12 ms
test timestamp ... ok 14 ms
test timestamptz ... ok 20 ms
test time ... ok 15 ms
test timetz ... ok 53 ms
test date ... ok 43 ms
test interval ... ok 45 ms
test macaddr ... ok 41 ms
test macaddr8 ... ok 19 ms
test inet ... ok 43 ms
test cidr ... ok 46 ms
test text ... ok 53 ms
test varchar ... ok 17 ms
test char ... ok 18 ms
test bytea ... ok 23 ms
test bit ... ok 15 ms
test varbit ... ok 19 ms
test numeric ... ok 33 ms
test uuid ... ok 14 ms
test not_equal ... ok 96 ms
test enum ... ok 45 ms
test bool ... ok 34 ms
======================
All 29 tests passed.
======================
waiting for server to shut down.... done
server stopped
pgsentinel
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 btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgsentinel-test ... ok 9064 ms
=====================
All 1 tests passed.
=====================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
ERROR: database "contrib_regression" is being accessed by other users
DETAIL: There is 1 other session using the database.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
waiting for server to shut down.... done
server stopped
prefix
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 prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 33 ms
test int2 ... ok 13 ms
test int4 ... ok 18 ms
test int8 ... ok 41 ms
test float4 ... ok 20 ms
test float8 ... ok 19 ms
test cash ... ok 18 ms
test oid ... ok 17 ms
test timestamp ... ok 19 ms
test timestamptz ... ok 25 ms
test time ... ok 18 ms
test timetz ... ok 72 ms
test date ... ok 42 ms
test interval ... ok 46 ms
test macaddr ... ok 29 ms
test macaddr8 ... ok 28 ms
test inet ... ok 43 ms
test cidr ... ok 21 ms
test text ... ok 31 ms
test varchar ... ok 39 ms
test char ... ok 27 ms
test bytea ... ok 51 ms
test bit ... ok 24 ms
test varbit ... ok 28 ms
test numeric ... ok 51 ms
test uuid ... ok 22 ms
test not_equal ... ok 49 ms
test enum ... ok 45 ms
test bool ... ok 34 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/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 prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 49 ms
test int2 ... ok 26 ms
test int4 ... ok 26 ms
test int8 ... ok 30 ms
test float4 ... ok 56 ms
test float8 ... ok 53 ms
test cash ... ok 29 ms
test oid ... ok 20 ms
test timestamp ... ok 22 ms
test timestamptz ... ok 43 ms
test time ... ok 33 ms
test timetz ... ok 173 ms
test date ... ok 51 ms
test interval ... ok 53 ms
test macaddr ... ok 51 ms
test macaddr8 ... ok 49 ms
test inet ... ok 83 ms
test cidr ... ok 56 ms
test text ... ok 80 ms
test varchar ... ok 40 ms
test char ... ok 59 ms
test bytea ... ok 49 ms
test bit ... ok 32 ms
test varbit ... ok 42 ms
test numeric ... ok 90 ms
test uuid ... ok 25 ms
test not_equal ... ok 78 ms
test enum ... ok 36 ms
test bool ... ok 31 ms
=======================
1 of 29 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/btree_gist/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/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
tds_fdw
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 tds_fdw ==============
ERROR: extension "tds_fdw" is not available
DETAIL: Could not open extension control file "/home/abigalek/pgext-cli-python/pg-15-dist/share/postgresql/extension/tds_fdw.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"tds_fdw\"" "contrib_regression"
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
(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 timescaledb ==============
WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.11.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: Please enable telemetry to help us improve our product by running: ALTER DATABASE "contrib_regression" SET timescaledb.telemetry_level = 'basic';
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 35 ms
test int2 ... ok 20 ms
test int4 ... ok 20 ms
test int8 ... ok 20 ms
test float4 ... FAILED 22 ms
test float8 ... FAILED 21 ms
test cash ... ok 22 ms
test oid ... ok 20 ms
test timestamp ... ok 21 ms
test timestamptz ... ok 24 ms
test time ... ok 21 ms
test timetz ... ok 123 ms
test date ... ok 20 ms
test interval ... ok 21 ms
test macaddr ... ok 20 ms
test macaddr8 ... ok 21 ms
test inet ... ok 42 ms
test cidr ... ok 25 ms
test text ... ok 40 ms
test varchar ... ok 23 ms
test char ... ok 25 ms
test bytea ... ok 34 ms
test bit ... ok 21 ms
test varbit ... ok 31 ms
test numeric ... ok 45 ms
test uuid ... ok 24 ms
test not_equal ... ok 64 ms
test enum ... FAILED 28 ms
test bool ... ok 22 ms
=======================
3 of 29 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/postgresql-15.3/contrib/btree_gist/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/postgresql-15.3/contrib/btree_gist/regression.out".
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 2627 ms
test alternate_users ... ok 1685 ms
test chunk_utils ... ok 1891 ms
test index ... ok 2200 ms
test pg_dump_unprivileged ... ok 1518 ms
test tablespace ... ok 1513 ms
parallel group (21 tests): agg_bookends-15 baserel_cache create_table cluster-15 create_hypertable ddl-15 chunks drop_hypertable broken_tables chunk_adaptive create_chunks cursor-15 custom_type ddl_errors delete-15 drop_extension ddl_extra copy-15 append-15 constraint-15 drop_owned
agg_bookends-15 ... ok 11644 ms
append-15 ... ok 11689 ms
baserel_cache ... ok 11646 ms
broken_tables ... ok 11656 ms
chunk_adaptive ... ok 11655 ms
chunks ... ok 11649 ms
cluster-15 ... ok 11647 ms
constraint-15 ... ok 11855 ms
copy-15 ... ok 11676 ms
create_chunks ... ok 11655 ms
create_hypertable ... ok 11646 ms
create_table ... ok 11645 ms
cursor-15 ... ok 11655 ms
custom_type ... ok 11655 ms
ddl-15 ... ok 11647 ms
ddl_errors ... ok 11654 ms
ddl_extra ... ok 11654 ms
delete-15 ... ok 11654 ms
drop_extension ... FAILED 11654 ms
drop_hypertable ... ok 11647 ms
drop_owned ... ok 11915 ms
parallel group (21 tests): hash merge grant_hypertable histogram_test insert_returning license dump_meta drop_rename_hypertable null_exclusion insert_single information_views lateral misc partition generated_as_identity extension_scripts parallel-15 drop_schema partitioning insert-15 insert_many
drop_rename_hypertable ... ok 15582 ms
drop_schema ... ok 15634 ms
dump_meta ... ok 15582 ms
extension_scripts ... ok 15589 ms
generated_as_identity ... ok 15588 ms
grant_hypertable ... ok 15566 ms
hash ... ok 11824 ms
histogram_test ... ok 15581 ms
information_views ... ok 15587 ms
insert-15 ... ok 16114 ms
insert_many ... ok 18207 ms
insert_returning ... ok 15581 ms
insert_single ... ok 15581 ms
lateral ... ok 15587 ms
license ... ok 15581 ms
merge ... ok 15548 ms
misc ... ok 15587 ms
null_exclusion ... ok 15581 ms
parallel-15 ... ok 15587 ms
partition ... ok 15587 ms
partitioning ... ok 15632 ms
parallel group (21 tests): tableam query-15 partitionwise-15 sql_query reloptions sort_optimization upsert plan_hypertable_inline-15 timestamp triggers plain update-15 size_utils rowsecurity-15 plan_ordered_append plan_expand_hypertable-15 plan_hashagg-15 pg_join truncate trusted_extension relocate_extension
partitionwise-15 ... ok 19774 ms
pg_join ... ok 20434 ms
plain ... FAILED 19778 ms
plan_expand_hypertable-15 ... ok 19804 ms
plan_hashagg-15 ... ok 19805 ms
plan_hypertable_inline-15 ... ok 19775 ms
plan_ordered_append ... ok 19804 ms
query-15 ... ok 19768 ms
relocate_extension ... ok 21084 ms
reloptions ... ok 19773 ms
rowsecurity-15 ... ok 19803 ms
size_utils ... ok 19803 ms
sort_optimization ... ok 19773 ms
sql_query ... ok 19773 ms
tableam ... ok 19082 ms
timestamp ... ok 19776 ms
triggers ... ok 19776 ms
truncate ... ok 20541 ms
trusted_extension ... ok 20541 ms
update-15 ... ok 19800 ms
upsert ... ok 19773 ms
parallel group (4 tests): version util vacuum_parallel vacuum
util ... ok 1758 ms
vacuum ... ok 1761 ms
vacuum_parallel ... ok 1761 ms
version ... ok 1732 ms
=======================
2 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
(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 timescaledb ==============
WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.11.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: Please enable telemetry to help us improve our product by running: ALTER DATABASE "contrib_regression" SET timescaledb.telemetry_level = 'basic';
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 35 ms
test int2 ... ok 21 ms
test int4 ... ok 21 ms
test int8 ... ok 22 ms
test float4 ... FAILED 21 ms
test float8 ... FAILED 21 ms
test cash ... ok 22 ms
test oid ... ok 21 ms
test timestamp ... ok 23 ms
test timestamptz ... ok 24 ms
test time ... ok 22 ms
test timetz ... ok 124 ms
test date ... ok 21 ms
test interval ... ok 21 ms
test macaddr ... ok 21 ms
test macaddr8 ... ok 21 ms
test inet ... ok 39 ms
test cidr ... ok 23 ms
test text ... ok 34 ms
test varchar ... ok 24 ms
test char ... ok 30 ms
test bytea ... ok 34 ms
test bit ... ok 20 ms
test varbit ... ok 28 ms
test numeric ... ok 51 ms
test uuid ... ok 21 ms
test not_equal ... ok 63 ms
test enum ... FAILED 25 ms
test bool ... ok 19 ms
=======================
3 of 29 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/postgresql-15.3/contrib/btree_gist/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/postgresql-15.3/contrib/btree_gist/regression.out".
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 1965 ms
test alternate_users ... ok 1395 ms
test chunk_utils ... ok 1540 ms
test index ... ok 1889 ms
test pg_dump_unprivileged ... ok 1233 ms
test tablespace ... ok 1294 ms
parallel group (21 tests): chunks create_table broken_tables delete-15 cluster-15 ddl_extra ddl_errors ddl-15 drop_hypertable create_hypertable cursor-15 baserel_cache create_chunks drop_extension agg_bookends-15 custom_type chunk_adaptive copy-15 append-15 constraint-15 drop_owned
agg_bookends-15 ... ok 9819 ms
append-15 ... ok 9837 ms
baserel_cache ... ok 9816 ms
broken_tables ... ok 9805 ms
chunk_adaptive ... ok 9835 ms
chunks ... ok 9803 ms
cluster-15 ... ok 9805 ms
constraint-15 ... ok 9998 ms
copy-15 ... ok 9836 ms
create_chunks ... ok 9817 ms
create_hypertable ... ok 9812 ms
create_table ... ok 9803 ms
cursor-15 ... ok 9812 ms
custom_type ... ok 9818 ms
ddl-15 ... ok 9808 ms
ddl_errors ... ok 9806 ms
ddl_extra ... ok 9806 ms
delete-15 ... ok 9804 ms
drop_extension ... FAILED 9816 ms
drop_hypertable ... ok 9809 ms
drop_owned ... ok 10014 ms
parallel group (21 tests): partitioning license misc extension_scripts histogram_test information_views merge grant_hypertable null_exclusion lateral drop_rename_hypertable drop_schema hash parallel-15 insert_single partition insert_returning dump_meta generated_as_identity insert-15 insert_many
drop_rename_hypertable ... ok 12641 ms
drop_schema ... ok 12641 ms
dump_meta ... ok 12660 ms
extension_scripts ... ok 12584 ms
generated_as_identity ... ok 12660 ms
grant_hypertable ... ok 12584 ms
hash ... ok 12641 ms
histogram_test ... ok 12584 ms
information_views ... ok 12584 ms
insert-15 ... ok 13004 ms
insert_many ... ok 14876 ms
insert_returning ... ok 12649 ms
insert_single ... ok 12642 ms
lateral ... ok 12640 ms
license ... ok 12557 ms
merge ... ok 12583 ms
misc ... ok 12574 ms
null_exclusion ... ok 12635 ms
parallel-15 ... ok 12640 ms
partition ... ok 12642 ms
partitioning ... ok 10116 ms
parallel group (21 tests): plain sort_optimization sql_query plan_hypertable_inline-15 upsert update-15 tableam timestamp partitionwise-15 reloptions query-15 triggers size_utils plan_ordered_append plan_expand_hypertable-15 rowsecurity-15 plan_hashagg-15 trusted_extension truncate pg_join relocate_extension
partitionwise-15 ... ok 17150 ms
pg_join ... ok 18224 ms
plain ... FAILED 16073 ms
plan_expand_hypertable-15 ... ok 17160 ms
plan_hashagg-15 ... ok 17183 ms
plan_hypertable_inline-15 ... ok 17145 ms
plan_ordered_append ... ok 17151 ms
query-15 ... ok 17150 ms
relocate_extension ... ok 18511 ms
reloptions ... ok 17149 ms
rowsecurity-15 ... ok 17159 ms
size_utils ... ok 17151 ms
sort_optimization ... ok 17136 ms
sql_query ... ok 17139 ms
tableam ... ok 17146 ms
timestamp ... ok 17148 ms
triggers ... ok 17149 ms
truncate ... ok 18042 ms
trusted_extension ... ok 17861 ms
update-15 ... ok 17146 ms
upsert ... ok 17145 ms
parallel group (4 tests): util version vacuum_parallel vacuum
util ... ok 1448 ms
vacuum ... ok 1486 ms
vacuum_parallel ... ok 1485 ms
version ... ok 1479 ms
=======================
2 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".