btree_gin
The Generalized Inverted Index (GIN) support for B-tree operator classes allows for efficient indexing and querying of data using standard B-tree operators, enabling fast lookup, insertion, and deletion operations on indexed columns.
Information Analysis
| Extensibility Types: | Functions, Index Access Methods |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 513 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 513 |
| Lines of Encapsulated Versioning Code: ? | 0 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0% |
Compatibility Analysis
| Number of Failed Extensions: | 15 |
| Failure Rate: | 13.2% |
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 install_btree_gin ... ok 25 ms
test int2 ... ok 16 ms
test int4 ... ok 17 ms
test int8 ... ok 18 ms
test float4 ... ok 18 ms
test float8 ... ok 24 ms
test money ... ok 37 ms
test oid ... ok 39 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 37 ms
test time ... ok 37 ms
test timetz ... ok 37 ms
test date ... ok 40 ms
test interval ... ok 36 ms
test macaddr ... ok 36 ms
test macaddr8 ... ok 36 ms
test inet ... ok 47 ms
test cidr ... ok 48 ms
test text ... ok 47 ms
test varchar ... ok 46 ms
test char ... ok 37 ms
test bytea ... ok 44 ms
test bit ... ok 36 ms
test varbit ... ok 47 ms
test numeric ... ok 46 ms
test enum ... ok 198 ms
test uuid ... ok 18 ms
test name ... ok 16 ms
test bool ... ok 30 ms
test bpchar ... ok 38 ms
======================
All 30 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 177 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 177 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 install_btree_gin ... ok 26 ms
test int2 ... ok 17 ms
test int4 ... ok 17 ms
test int8 ... ok 19 ms
test float4 ... ok 26 ms
test float8 ... ok 28 ms
test money ... ok 28 ms
test oid ... ok 31 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 37 ms
test time ... ok 37 ms
test timetz ... ok 37 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 37 ms
test inet ... ok 45 ms
test cidr ... ok 48 ms
test text ... ok 46 ms
test varchar ... ok 47 ms
test char ... ok 36 ms
test bytea ... ok 46 ms
test bit ... ok 37 ms
test varbit ... ok 45 ms
test numeric ... ok 46 ms
test enum ... ok 308 ms
test uuid ... ok 18 ms
test name ... ok 18 ms
test bool ... ok 20 ms
test bpchar ... ok 30 ms
======================
All 30 tests passed.
======================
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 install_btree_gin ... FAILED 26 ms
test int2 ... ok 23 ms
test int4 ... ok 35 ms
test int8 ... ok 37 ms
test float4 ... ok 36 ms
test float8 ... ok 37 ms
test money ... ok 36 ms
test oid ... ok 35 ms
test timestamp ... ok 36 ms
test timestamptz ... ok 37 ms
test time ... ok 37 ms
test timetz ... ok 37 ms
test date ... ok 36 ms
test interval ... ok 36 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 36 ms
test inet ... ok 49 ms
test cidr ... ok 49 ms
test text ... ok 47 ms
test varchar ... ok 49 ms
test char ... ok 37 ms
test bytea ... ok 47 ms
test bit ... ok 37 ms
test varbit ... ok 49 ms
test numeric ... ok 46 ms
test enum ... ok 338 ms
test uuid ... ok 18 ms
test name ... ok 22 ms
test bool ... ok 27 ms
test bpchar ... ok 36 ms
=======================
1 of 30 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_gin/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_gin/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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test isn ... ok 73 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test isn ... ok 81 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 install_btree_gin ... FAILED 33 ms
test int2 ... ok 36 ms
test int4 ... ok 37 ms
test int8 ... ok 32 ms
test float4 ... ok 37 ms
test float8 ... ok 37 ms
test money ... ok 36 ms
test oid ... ok 36 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 37 ms
test time ... ok 37 ms
test timetz ... ok 37 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 37 ms
test inet ... ok 46 ms
test cidr ... ok 51 ms
test text ... ok 47 ms
test varchar ... ok 52 ms
test char ... ok 36 ms
test bytea ... ok 50 ms
test bit ... ok 37 ms
test varbit ... ok 52 ms
test numeric ... ok 48 ms
test enum ... ok 317 ms
test uuid ... ok 17 ms
test name ... ok 19 ms
test bool ... ok 23 ms
test bpchar ... ok 25 ms
=======================
1 of 30 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_gin/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_gin/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 install_btree_gin ... FAILED 19 ms
test int2 ... ok 9 ms
test int4 ... ok 9 ms
test int8 ... ok 13 ms
test float4 ... ok 29 ms
test float8 ... ok 29 ms
test money ... ok 29 ms
test oid ... ok 29 ms
test timestamp ... ok 29 ms
test timestamptz ... ok 20 ms
test time ... ok 20 ms
test timetz ... ok 20 ms
test date ... ok 20 ms
test interval ... ok 20 ms
test macaddr ... ok 21 ms
test macaddr8 ... ok 20 ms
test inet ... ok 28 ms
test cidr ... ok 36 ms
test text ... ok 35 ms
test varchar ... ok 36 ms
test char ... ok 29 ms
test bytea ... ok 28 ms
test bit ... ok 29 ms
test varbit ... ok 34 ms
test numeric ... ok 34 ms
test enum ... ok 144 ms
test uuid ... ok 16 ms
test name ... ok 22 ms
test bool ... ok 23 ms
test bpchar ... ok 22 ms
=======================
1 of 30 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_gin/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_gin/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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test test ... ok 11202 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test test ... ok 11346 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 install_btree_gin ... FAILED 20 ms
test int2 ... ok 9 ms
test int4 ... ok 9 ms
test int8 ... ok 9 ms
test float4 ... ok 9 ms
test float8 ... ok 12 ms
test money ... ok 9 ms
test oid ... ok 20 ms
test timestamp ... ok 28 ms
test timestamptz ... ok 29 ms
test time ... ok 29 ms
test timetz ... ok 36 ms
test date ... ok 29 ms
test interval ... ok 28 ms
test macaddr ... ok 29 ms
test macaddr8 ... ok 28 ms
test inet ... ok 33 ms
test cidr ... ok 36 ms
test text ... ok 34 ms
test varchar ... ok 31 ms
test char ... ok 22 ms
test bytea ... ok 33 ms
test bit ... ok 29 ms
test varbit ... ok 34 ms
test numeric ... ok 34 ms
test enum ... ok 200 ms
test uuid ... ok 9 ms
test name ... ok 9 ms
test bool ... ok 19 ms
test bpchar ... ok 32 ms
=======================
1 of 30 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_gin/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_gin/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 install_btree_gin ... FAILED 24 ms
test int2 ... ok 10 ms
test int4 ... ok 23 ms
test int8 ... ok 33 ms
test float4 ... ok 33 ms
test float8 ... ok 32 ms
test money ... ok 32 ms
test oid ... ok 34 ms
test timestamp ... ok 31 ms
test timestamptz ... ok 34 ms
test time ... ok 31 ms
test timetz ... ok 34 ms
test date ... ok 31 ms
test interval ... ok 33 ms
test macaddr ... ok 32 ms
test macaddr8 ... ok 33 ms
test inet ... ok 44 ms
test cidr ... ok 42 ms
test text ... ok 41 ms
test varchar ... ok 43 ms
test char ... ok 31 ms
test bytea ... ok 39 ms
test bit ... ok 36 ms
test varbit ... ok 43 ms
test numeric ... ok 42 ms
test enum ... ok 204 ms
test uuid ... ok 22 ms
test name ... ok 36 ms
test bool ... ok 39 ms
test bpchar ... ok 36 ms
=======================
1 of 30 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_gin/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_gin/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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_bigm ... ok 138 ms
test pg_bigm_ja ... ok 38 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_bigm ... ok 169 ms
test pg_bigm_ja ... ok 43 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 install_btree_gin ... FAILED 42 ms
test int2 ... ok 29 ms
test int4 ... ok 35 ms
test int8 ... ok 37 ms
test float4 ... ok 36 ms
test float8 ... ok 36 ms
test money ... ok 36 ms
test oid ... ok 36 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 36 ms
test time ... ok 37 ms
test timetz ... ok 36 ms
test date ... ok 37 ms
test interval ... ok 36 ms
test macaddr ... ok 36 ms
test macaddr8 ... ok 36 ms
test inet ... ok 46 ms
test cidr ... ok 47 ms
test text ... ok 46 ms
test varchar ... ok 51 ms
test char ... ok 35 ms
test bytea ... ok 48 ms
test bit ... ok 40 ms
test varbit ... ok 50 ms
test numeric ... ok 46 ms
test enum ... ok 302 ms
test uuid ... ok 25 ms
test name ... ok 33 ms
test bool ... ok 42 ms
test bpchar ... ok 40 ms
=======================
1 of 30 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_gin/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_gin/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 install_btree_gin ... ok 34 ms
test int2 ... ok 21 ms
test int4 ... ok 21 ms
test int8 ... ok 29 ms
test float4 ... ok 33 ms
test float8 ... ok 29 ms
test money ... ok 28 ms
test oid ... ok 32 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 38 ms
test time ... ok 38 ms
test timetz ... ok 37 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 38 ms
test macaddr8 ... ok 36 ms
test inet ... ok 48 ms
test cidr ... ok 48 ms
test text ... ok 47 ms
test varchar ... ok 49 ms
test char ... ok 37 ms
test bytea ... ok 48 ms
test bit ... ok 38 ms
test varbit ... ok 45 ms
test numeric ... ok 47 ms
test enum ... ok 207 ms
test uuid ... ok 18 ms
test name ... ok 18 ms
test bool ... ok 18 ms
test bpchar ... ok 19 ms
======================
All 30 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2584 ms
test base_plan ... ok 20 ms
test pg_hint_plan ... ok 7568 ms
test ut-init ... FAILED 778 ms
test ut-A ... ok 453 ms
test ut-S ... ok 192 ms
test ut-J ... ok 87 ms
test ut-L ... ok 95 ms
test ut-G ... ok 31 ms
test ut-R ... ok 447 ms
test ut-fdw ... ok 77 ms
test ut-W ... ok 126 ms
test ut-T ... ok 49 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 81 ms
test oldextversions ... ok 149 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1341 ms
test base_plan ... ok 12 ms
test pg_hint_plan ... ok 7409 ms
test ut-init ... FAILED 833 ms
test ut-A ... ok 442 ms
test ut-S ... ok 190 ms
test ut-J ... ok 85 ms
test ut-L ... ok 96 ms
test ut-G ... ok 44 ms
test ut-R ... ok 1064 ms
test ut-fdw ... ok 36 ms
test ut-W ... ok 113 ms
test ut-T ... ok 48 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 137 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 install_btree_gin ... ok 22 ms
test int2 ... ok 10 ms
test int4 ... ok 9 ms
test int8 ... ok 10 ms
test float4 ... ok 12 ms
test float8 ... ok 13 ms
test money ... ok 13 ms
test oid ... ok 12 ms
test timestamp ... ok 18 ms
test timestamptz ... ok 26 ms
test time ... ok 27 ms
test timetz ... ok 27 ms
test date ... ok 27 ms
test interval ... ok 26 ms
test macaddr ... ok 26 ms
test macaddr8 ... ok 26 ms
test inet ... ok 33 ms
test cidr ... ok 35 ms
test text ... ok 35 ms
test varchar ... ok 37 ms
test char ... ok 29 ms
test bytea ... ok 35 ms
test bit ... ok 30 ms
test varbit ... ok 31 ms
test numeric ... ok 33 ms
test enum ... ok 167 ms
test uuid ... ok 25 ms
test name ... ok 21 ms
test bool ... ok 18 ms
test bpchar ... ok 17 ms
======================
All 30 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 install_btree_gin ... ok 24 ms
test int2 ... ok 23 ms
test int4 ... ok 36 ms
test int8 ... ok 37 ms
test float4 ... ok 36 ms
test float8 ... ok 37 ms
test money ... ok 36 ms
test oid ... ok 37 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 35 ms
test time ... ok 37 ms
test timetz ... ok 41 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 38 ms
test inet ... ok 46 ms
test cidr ... ok 46 ms
test text ... ok 47 ms
test varchar ... ok 49 ms
test char ... ok 37 ms
test bytea ... ok 47 ms
test bit ... ok 38 ms
test varbit ... ok 45 ms
test numeric ... ok 46 ms
test enum ... ok 211 ms
test uuid ... ok 18 ms
test name ... ok 19 ms
test bool ... ok 30 ms
test bpchar ... ok 41 ms
======================
All 30 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 13 ms
test test1 ... ok 28 ms
test test2 ... ok 52 ms
test test3 ... ok 90 ms
test test4 ... ok 149 ms
test test5 ... ok 26 ms
test test6 ... ok 77 ms
test test7 ... FAILED 24 ms
test test8 ... ok 40 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 install_btree_gin ... ok 34 ms
test int2 ... ok 22 ms
test int4 ... ok 36 ms
test int8 ... ok 37 ms
test float4 ... ok 36 ms
test float8 ... ok 37 ms
test money ... ok 37 ms
test oid ... ok 38 ms
test timestamp ... ok 38 ms
test timestamptz ... ok 37 ms
test time ... ok 40 ms
test timetz ... ok 38 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 37 ms
test inet ... ok 45 ms
test cidr ... ok 48 ms
test text ... ok 47 ms
test varchar ... ok 48 ms
test char ... ok 37 ms
test bytea ... ok 48 ms
test bit ... ok 41 ms
test varbit ... ok 47 ms
test numeric ... ok 47 ms
test enum ... ok 199 ms
test uuid ... ok 18 ms
test name ... ok 19 ms
test bool ... ok 24 ms
test bpchar ... ok 24 ms
======================
All 30 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 68 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 install_btree_gin ... ok 50 ms
test int2 ... ok 30 ms
test int4 ... ok 37 ms
test int8 ... ok 36 ms
test float4 ... ok 37 ms
test float8 ... ok 36 ms
test money ... ok 37 ms
test oid ... ok 36 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 36 ms
test time ... ok 37 ms
test timetz ... ok 35 ms
test date ... ok 38 ms
test interval ... ok 36 ms
test macaddr ... ok 38 ms
test macaddr8 ... ok 37 ms
test inet ... ok 48 ms
test cidr ... ok 49 ms
test text ... ok 47 ms
test varchar ... ok 45 ms
test char ... ok 37 ms
test bytea ... ok 51 ms
test bit ... ok 37 ms
test varbit ... ok 45 ms
test numeric ... ok 47 ms
test enum ... ok 202 ms
test uuid ... ok 19 ms
test name ... ok 31 ms
test bool ... ok 45 ms
test bpchar ... ok 42 ms
======================
All 30 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 19 ms
test version ... ok 18 ms
test guc ... ok 20 ms
test pgsm_query_id ... ok 568 ms
test functions ... FAILED 75 ms
test counters ... ok 92 ms
test relations ... ok 158 ms
test database ... ok 495 ms
test error_insert ... ok 86 ms
test application_name ... ok 38 ms
test application_name_unique ... ok 42 ms
test top_query ... ok 47 ms
test cmd_type ... ok 71 ms
test error ... ok 49 ms
test rows ... ok 108 ms
test tags ... ok 50 ms
test user ... ok 72 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 19 ms
test version ... ok 17 ms
test guc ... ok 28 ms
test pgsm_query_id ... ok 666 ms
test functions ... FAILED 70 ms
test counters ... ok 74 ms
test relations ... ok 213 ms
test database ... ok 472 ms
test error_insert ... ok 60 ms
test application_name ... ok 23 ms
test application_name_unique ... ok 23 ms
test top_query ... ok 32 ms
test cmd_type ... ok 57 ms
test error ... ok 35 ms
test rows ... ok 65 ms
test tags ... ok 24 ms
test user ... ok 87 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 install_btree_gin ... ok 26 ms
test int2 ... ok 16 ms
test int4 ... ok 17 ms
test int8 ... ok 23 ms
test float4 ... ok 31 ms
test float8 ... ok 32 ms
test money ... ok 31 ms
test oid ... ok 34 ms
test timestamp ... ok 38 ms
test timestamptz ... ok 37 ms
test time ... ok 37 ms
test timetz ... ok 37 ms
test date ... ok 38 ms
test interval ... ok 37 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 37 ms
test inet ... ok 47 ms
test cidr ... ok 49 ms
test text ... ok 47 ms
test varchar ... ok 49 ms
test char ... ok 37 ms
test bytea ... ok 47 ms
test bit ... ok 38 ms
test varbit ... ok 47 ms
test numeric ... ok 46 ms
test enum ... ok 201 ms
test uuid ... ok 33 ms
test name ... ok 39 ms
test bool ... ok 43 ms
test bpchar ... ok 42 ms
======================
All 30 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 install_btree_gin ... ok 38 ms
test int2 ... ok 24 ms
test int4 ... ok 41 ms
test int8 ... ok 37 ms
test float4 ... ok 37 ms
test float8 ... ok 37 ms
test money ... ok 35 ms
test oid ... ok 37 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 37 ms
test time ... ok 36 ms
test timetz ... ok 37 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 37 ms
test macaddr8 ... ok 37 ms
test inet ... ok 47 ms
test cidr ... ok 48 ms
test text ... ok 46 ms
test varchar ... ok 51 ms
test char ... ok 37 ms
test bytea ... ok 44 ms
test bit ... ok 38 ms
test varbit ... ok 47 ms
test numeric ... ok 46 ms
test enum ... ok 207 ms
test uuid ... ok 18 ms
test name ... ok 28 ms
test bool ... ok 43 ms
test bpchar ... ok 41 ms
======================
All 30 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_tle_api ... ok 435 ms
test pg_tle_management ... FAILED 401 ms
test pg_tle_injection ... FAILED 124 ms
test pg_tle_perms ... FAILED 248 ms
test pg_tle_requires ... ok 66 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 install_btree_gin ... ok 49 ms
test int2 ... ok 16 ms
test int4 ... ok 21 ms
test int8 ... ok 37 ms
test float4 ... ok 36 ms
test float8 ... ok 37 ms
test money ... ok 37 ms
test oid ... ok 37 ms
test timestamp ... ok 36 ms
test timestamptz ... ok 37 ms
test time ... ok 37 ms
test timetz ... ok 37 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 36 ms
test macaddr8 ... ok 37 ms
test inet ... ok 46 ms
test cidr ... ok 47 ms
test text ... ok 46 ms
test varchar ... ok 48 ms
test char ... ok 36 ms
test bytea ... ok 44 ms
test bit ... ok 37 ms
test varbit ... ok 45 ms
test numeric ... ok 45 ms
test enum ... ok 201 ms
test uuid ... ok 17 ms
test name ... ok 18 ms
test bool ... ok 31 ms
test bpchar ... ok 41 ms
======================
All 30 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 54 ms
test pgextwlist ... FAILED 83 ms
test errors ... FAILED 8 ms
test crossuser ... ok 33 ms
test hooks ... ok 23 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_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 50 ms
test pgextwlist ... FAILED 83 ms
test errors ... FAILED 8 ms
test crossuser ... ok 50 ms
test hooks ... ok 32 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 install_btree_gin ... ok 26 ms
test int2 ... ok 21 ms
test int4 ... ok 35 ms
test int8 ... ok 38 ms
test float4 ... ok 37 ms
test float8 ... ok 36 ms
test money ... ok 36 ms
test oid ... ok 37 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 37 ms
test time ... ok 37 ms
test timetz ... ok 37 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 38 ms
test macaddr8 ... ok 38 ms
test inet ... ok 46 ms
test cidr ... ok 45 ms
test text ... ok 47 ms
test varchar ... ok 48 ms
test char ... ok 36 ms
test bytea ... ok 43 ms
test bit ... ok 37 ms
test varbit ... ok 31 ms
test numeric ... ok 30 ms
test enum ... ok 316 ms
test uuid ... ok 18 ms
test name ... ok 24 ms
test bool ... ok 26 ms
test bpchar ... ok 20 ms
======================
All 30 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_gin ==============
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 install_btree_gin ... FAILED 21 ms
test int2 ... ok 10 ms
test int4 ... ok 9 ms
test int8 ... ok 10 ms
test float4 ... ok 13 ms
test float8 ... ok 9 ms
test money ... ok 9 ms
test oid ... ok 13 ms
test timestamp ... ok 10 ms
test timestamptz ... ok 10 ms
test time ... ok 10 ms
test timetz ... ok 10 ms
test date ... ok 10 ms
test interval ... ok 14 ms
test macaddr ... ok 16 ms
test macaddr8 ... ok 21 ms
test inet ... ok 38 ms
test cidr ... ok 36 ms
test text ... ok 34 ms
test varchar ... ok 36 ms
test char ... ok 29 ms
test bytea ... ok 35 ms
test bit ... ok 29 ms
test varbit ... ok 35 ms
test numeric ... ok 35 ms
test enum ... ok 153 ms
test uuid ... ok 17 ms
test name ... ok 22 ms
test bool ... ok 23 ms
test bpchar ... ok 27 ms
=======================
1 of 30 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_gin/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_gin/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 install_btree_gin ... FAILED 32 ms
test int2 ... ok 26 ms
test int4 ... ok 37 ms
test int8 ... ok 37 ms
test float4 ... ok 37 ms
test float8 ... ok 37 ms
test money ... ok 38 ms
test oid ... ok 37 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 38 ms
test time ... ok 38 ms
test timetz ... ok 37 ms
test date ... ok 38 ms
test interval ... ok 38 ms
test macaddr ... ok 38 ms
test macaddr8 ... ok 37 ms
test inet ... ok 49 ms
test cidr ... ok 49 ms
test text ... ok 47 ms
test varchar ... ok 49 ms
test char ... ok 36 ms
test bytea ... ok 45 ms
test bit ... ok 38 ms
test varbit ... ok 47 ms
test numeric ... ok 47 ms
test enum ... ok 197 ms
test uuid ... ok 25 ms
test name ... ok 41 ms
test bool ... ok 43 ms
test bpchar ... ok 42 ms
=======================
1 of 30 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_gin/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_gin/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 install_btree_gin ... ok 23 ms
test int2 ... ok 18 ms
test int4 ... ok 17 ms
test int8 ... ok 19 ms
test float4 ... ok 18 ms
test float8 ... ok 19 ms
test money ... ok 19 ms
test oid ... ok 17 ms
test timestamp ... ok 19 ms
test timestamptz ... ok 18 ms
test time ... ok 18 ms
test timetz ... ok 19 ms
test date ... ok 19 ms
test interval ... ok 18 ms
test macaddr ... ok 18 ms
test macaddr8 ... ok 18 ms
test inet ... ok 27 ms
test cidr ... ok 26 ms
test text ... ok 26 ms
test varchar ... ok 29 ms
test char ... ok 18 ms
test bytea ... ok 26 ms
test bit ... ok 19 ms
test varbit ... ok 26 ms
test numeric ... ok 26 ms
test enum ... ok 218 ms
test uuid ... ok 18 ms
test name ... ok 18 ms
test bool ... ok 19 ms
test bpchar ... ok 18 ms
======================
All 30 tests passed.
======================
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 2429 ms
test alternate_users ... ok 1680 ms
test chunk_utils ... ok 1884 ms
test index ... ok 2192 ms
test pg_dump_unprivileged ... ok 1530 ms
test tablespace ... ok 1561 ms
parallel group (21 tests): chunks create_hypertable custom_type cursor-15 drop_hypertable create_chunks baserel_cache ddl-15 delete-15 drop_extension ddl_errors broken_tables agg_bookends-15 ddl_extra chunk_adaptive create_table cluster-15 append-15 copy-15 constraint-15 drop_owned
agg_bookends-15 ... ok 11381 ms
append-15 ... ok 11390 ms
baserel_cache ... ok 11374 ms
broken_tables ... ok 11381 ms
chunk_adaptive ... ok 11384 ms
chunks ... ok 11362 ms
cluster-15 ... ok 11384 ms
constraint-15 ... ok 11608 ms
copy-15 ... ok 11399 ms
create_chunks ... ok 11373 ms
create_hypertable ... ok 11364 ms
create_table ... ok 11384 ms
cursor-15 ... ok 11365 ms
custom_type ... ok 11364 ms
ddl-15 ... ok 11373 ms
ddl_errors ... ok 11374 ms
ddl_extra ... ok 11380 ms
delete-15 ... ok 11373 ms
drop_extension ... FAILED 11372 ms
drop_hypertable ... ok 11364 ms
drop_owned ... ok 11636 ms
parallel group (21 tests): hash partitioning drop_schema insert_returning dump_meta histogram_test parallel-15 lateral partition information_views license null_exclusion merge misc drop_rename_hypertable insert_single grant_hypertable extension_scripts generated_as_identity insert-15 insert_many
drop_rename_hypertable ... ok 15652 ms
drop_schema ... ok 15632 ms
dump_meta ... ok 15644 ms
extension_scripts ... ok 15651 ms
generated_as_identity ... ok 15652 ms
grant_hypertable ... ok 15651 ms
hash ... ok 11245 ms
histogram_test ... ok 15645 ms
information_views ... ok 15648 ms
insert-15 ... ok 16145 ms
insert_many ... ok 18397 ms
insert_returning ... ok 15643 ms
insert_single ... ok 15650 ms
lateral ... ok 15645 ms
license ... ok 15648 ms
merge ... ok 15648 ms
misc ... ok 15650 ms
null_exclusion ... ok 15648 ms
parallel-15 ... ok 15644 ms
partition ... ok 15647 ms
partitioning ... ok 15609 ms
parallel group (21 tests): partitionwise-15 tableam rowsecurity-15 sql_query plan_hashagg-15 plain triggers plan_hypertable_inline-15 timestamp plan_expand_hypertable-15 sort_optimization reloptions update-15 size_utils upsert query-15 plan_ordered_append pg_join trusted_extension relocate_extension truncate
partitionwise-15 ... ok 20135 ms
pg_join ... ok 20592 ms
plain ... ok 20310 ms
plan_expand_hypertable-15 ... ok 20329 ms
plan_hashagg-15 ... ok 20156 ms
plan_hypertable_inline-15 ... ok 20328 ms
plan_ordered_append ... ok 20335 ms
query-15 ... ok 20331 ms
relocate_extension ... ok 20616 ms
reloptions ... ok 20329 ms
rowsecurity-15 ... ok 20147 ms
size_utils ... ok 20329 ms
sort_optimization ... ok 20329 ms
sql_query ... ok 20146 ms
tableam ... ok 20146 ms
timestamp ... ok 20327 ms
triggers ... ok 20327 ms
truncate ... ok 20615 ms
trusted_extension ... ok 20612 ms
update-15 ... ok 20328 ms
upsert ... ok 20328 ms
parallel group (4 tests): version util vacuum vacuum_parallel
util ... ok 1620 ms
vacuum ... ok 1623 ms
vacuum_parallel ... ok 1623 ms
version ... ok 1594 ms
=======================
1 of 73 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
CREATE EXTENSION
(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 install_btree_gin ... ok 24 ms
test int2 ... ok 18 ms
test int4 ... ok 16 ms
test int8 ... ok 15 ms
test float4 ... ok 16 ms
test float8 ... ok 14 ms
test money ... ok 16 ms
test oid ... ok 13 ms
test timestamp ... ok 20 ms
test timestamptz ... ok 15 ms
test time ... ok 16 ms
test timetz ... ok 16 ms
test date ... ok 16 ms
test interval ... ok 18 ms
test macaddr ... ok 18 ms
test macaddr8 ... ok 20 ms
test inet ... ok 22 ms
test cidr ... ok 26 ms
test text ... ok 27 ms
test varchar ... ok 22 ms
test char ... ok 19 ms
test bytea ... ok 23 ms
test bit ... ok 20 ms
test varbit ... ok 22 ms
test numeric ... ok 25 ms
test enum ... ok 135 ms
test uuid ... ok 16 ms
test name ... ok 19 ms
test bool ... ok 20 ms
test bpchar ... ok 19 ms
======================
All 30 tests passed.
======================
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 1117 ms
test alternate_users ... ok 797 ms
test chunk_utils ... ok 905 ms
test index ... ok 1057 ms
test pg_dump_unprivileged ... ok 942 ms
test tablespace ... ok 868 ms
parallel group (21 tests): chunks broken_tables create_hypertable drop_hypertable baserel_cache ddl_errors create_chunks drop_extension custom_type create_table agg_bookends-15 cursor-15 ddl_extra cluster-15 chunk_adaptive ddl-15 delete-15 copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 7035 ms
append-15 ... ok 8468 ms
baserel_cache ... ok 7020 ms
broken_tables ... ok 7017 ms
chunk_adaptive ... ok 7037 ms
chunks ... ok 7012 ms
cluster-15 ... ok 7037 ms
constraint-15 ... ok 7165 ms
copy-15 ... ok 7040 ms
create_chunks ... ok 7025 ms
create_hypertable ... ok 7017 ms
create_table ... ok 7033 ms
cursor-15 ... ok 7034 ms
custom_type ... ok 7029 ms
ddl-15 ... ok 7036 ms
ddl_errors ... ok 7020 ms
ddl_extra ... ok 7036 ms
delete-15 ... ok 7036 ms
drop_extension ... FAILED 7025 ms
drop_hypertable ... ok 7018 ms
drop_owned ... ok 7184 ms
parallel group (21 tests): partitioning hash dump_meta null_exclusion drop_rename_hypertable grant_hypertable lateral parallel-15 license merge histogram_test misc drop_schema insert_returning generated_as_identity information_views extension_scripts partition insert_single insert-15 insert_many
drop_rename_hypertable ... ok 8829 ms
drop_schema ... ok 8849 ms
dump_meta ... ok 8828 ms
extension_scripts ... ok 8850 ms
generated_as_identity ... ok 8849 ms
grant_hypertable ... ok 8829 ms
hash ... ok 8823 ms
histogram_test ... ok 8848 ms
information_views ... ok 8849 ms
insert-15 ... ok 9369 ms
insert_many ... ok 10807 ms
insert_returning ... ok 8849 ms
insert_single ... ok 8849 ms
lateral ... ok 8828 ms
license ... ok 8832 ms
merge ... ok 8845 ms
misc ... ok 8847 ms
null_exclusion ... ok 8827 ms
parallel-15 ... ok 8827 ms
partition ... ok 8849 ms
partitioning ... ok 6485 ms
parallel group (21 tests): timestamp partitionwise-15 triggers sort_optimization tableam upsert reloptions plain plan_hypertable_inline-15 sql_query size_utils update-15 plan_expand_hypertable-15 rowsecurity-15 plan_ordered_append query-15 plan_hashagg-15 relocate_extension trusted_extension truncate pg_join
partitionwise-15 ... ok 15277 ms
pg_join ... ok 16098 ms
plain ... ok 15341 ms
plan_expand_hypertable-15 ... ok 15369 ms
plan_hashagg-15 ... ok 15374 ms
plan_hypertable_inline-15 ... ok 15341 ms
plan_ordered_append ... ok 15373 ms
query-15 ... ok 15373 ms
relocate_extension ... ok 15519 ms
reloptions ... ok 15340 ms
rowsecurity-15 ... ok 15373 ms
size_utils ... ok 15341 ms
sort_optimization ... ok 15328 ms
sql_query ... ok 15340 ms
tableam ... ok 15331 ms
timestamp ... ok 15275 ms
triggers ... ok 15275 ms
truncate ... ok 15547 ms
trusted_extension ... ok 15546 ms
update-15 ... ok 15340 ms
upsert ... ok 15339 ms
parallel group (4 tests): version util vacuum vacuum_parallel
util ... ok 1301 ms
vacuum ... ok 1302 ms
vacuum_parallel ... ok 1305 ms
version ... ok 1275 ms
=======================
1 of 73 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".