imcs
Repository:
https://github.com/knizhnik/imcs
Interleaved multi-column sorting allows for efficient indexing and querying of tables based on multiple columns, leveraging B-tree indexing to improve performance in certain query scenarios.
Information Analysis
| Extensibility Types: | Functions, Types, Query Processing |
| System Components: | Memory Allocation, Custom Configuration Variables |
Duplicate Code Analysis
| Total Lines of Code: ? | 15324 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 15324 |
| Lines of Encapsulated Versioning Code: ? | 64 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0.42% |
| PostgreSQL Versions Cased On: ? | 9 |
Compatibility Analysis
| Number of Failed Extensions: | 13 |
| Failure Rate: | 11.6% |
Failed Extensions
btree_gist
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
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
cube
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 cube ==============
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 134 ms
test span ... ok 10 ms
test operators ... ok 17 ms
test math ... ok 9 ms
test datetime ... ok 10 ms
test transform ... ok 25 ms
test scalarop ... ok 24 ms
test grandagg ... ok 36 ms
test groupbyagg ... ok 13 ms
test gridagg ... ok 9 ms
test windowagg ... ok 12 ms
test hashagg ... ok 23 ms
test cumagg ... ok 25 ms
test sort ... ok 34 ms
test spec ... ok 26 ms
test drop ... ok 36 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 cube ... FAILED 97 ms
test cube_sci ... FAILED 5 ms
======================
2 of 2 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/cube/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/cube/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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test cube ... FAILED 75 ms
test cube_sci ... FAILED 4 ms
======================
2 of 2 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/cube/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/cube/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 cube ==============
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 73 ms
test span ... ok 12 ms
test operators ... ok 20 ms
test math ... ok 10 ms
test datetime ... ok 11 ms
test transform ... ok 16 ms
test scalarop ... ok 8 ms
test grandagg ... ok 13 ms
test groupbyagg ... ok 11 ms
test gridagg ... ok 8 ms
test windowagg ... ok 10 ms
test hashagg ... ok 13 ms
test cumagg ... ok 8 ms
test sort ... ok 11 ms
test spec ... ok 12 ms
test drop ... ok 15 ms
======================
All 16 tests passed.
======================
waiting for server to shut down.... done
server stopped
earthdistance
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube ==============
CREATE EXTENSION
============== installing earthdistance ==============
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 137 ms
test span ... ok 10 ms
test operators ... ok 16 ms
test math ... ok 8 ms
test datetime ... ok 10 ms
test transform ... ok 18 ms
test scalarop ... ok 7 ms
test grandagg ... ok 12 ms
test groupbyagg ... ok 10 ms
test gridagg ... ok 8 ms
test windowagg ... ok 9 ms
test hashagg ... ok 16 ms
test cumagg ... ok 9 ms
test sort ... ok 16 ms
test spec ... ok 18 ms
test drop ... ok 29 ms
======================
All 16 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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 209 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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 171 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 "regression" ==============
SET
DROP DATABASE
============== creating database "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 create ... ok 102 ms
test span ... ok 11 ms
test operators ... ok 19 ms
test math ... ok 9 ms
test datetime ... ok 10 ms
test transform ... ok 15 ms
test scalarop ... ok 7 ms
test grandagg ... ok 12 ms
test groupbyagg ... ok 10 ms
test gridagg ... ok 7 ms
test windowagg ... ok 10 ms
test hashagg ... ok 11 ms
test cumagg ... ok 8 ms
test sort ... ok 10 ms
test spec ... ok 11 ms
test drop ... ok 14 ms
======================
All 16 tests passed.
======================
waiting for server to shut down.... done
server stopped
pg_cron
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_cron ==============
ERROR: can only create extension in database postgres
DETAIL: Jobs must be scheduled from the database configured in cron.database_name, since the pg_cron background worker reads job descriptions from this database.
HINT: Add cron.database_name = 'regression' in postgresql.conf to use the current database.
CONTEXT: PL/pgSQL function inline_code_block line 4 at RAISE
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pg_cron\"" "regression"
(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 pg_cron-test ... ok 883 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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_cron-test ... ok 462 ms
=====================
All 1 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 pg_cron ==============
ERROR: can only create extension in database postgres
DETAIL: Jobs must be scheduled from the database configured in cron.database_name, since the pg_cron background worker reads job descriptions from this database.
HINT: Add cron.database_name = 'regression' in postgresql.conf to use the current database.
CONTEXT: PL/pgSQL function inline_code_block line 4 at RAISE
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pg_cron\"" "regression"
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 "regression" ==============
SET
DROP DATABASE
============== creating database "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 create ... ok 157 ms
test span ... ok 16 ms
test operators ... ok 20 ms
test math ... ok 10 ms
test datetime ... ok 13 ms
test transform ... ok 21 ms
test scalarop ... ok 9 ms
test grandagg ... ok 15 ms
test groupbyagg ... ok 13 ms
test gridagg ... ok 9 ms
test windowagg ... ok 11 ms
test hashagg ... ok 17 ms
test cumagg ... ok 8 ms
test sort ... ok 11 ms
test spec ... ok 12 ms
test drop ... ok 20 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 test0 ... ok 13 ms
test test1 ... ok 18 ms
test test2 ... ok 26 ms
test test3 ... ok 83 ms
test test4 ... ok 304 ms
test test5 ... ok 27 ms
test test6 ... ok 70 ms
test test7 ... FAILED 22 ms
test test8 ... ok 37 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 "regression" ==============
SET
DROP DATABASE
============== creating database "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 create ... ok 152 ms
test span ... FAILED 15 ms
test operators ... ok 21 ms
test math ... ok 10 ms
test datetime ... ok 12 ms
test transform ... ok 20 ms
test scalarop ... ok 8 ms
test grandagg ... FAILED 12 ms
test groupbyagg ... ok 12 ms
test gridagg ... ok 8 ms
test windowagg ... ok 11 ms
test hashagg ... ok 16 ms
test cumagg ... ok 9 ms
test sort ... ok 12 ms
test spec ... ok 13 ms
test drop ... ok 20 ms
=======================
2 of 16 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/imcs/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/imcs/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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 66 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 "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_kcache
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_monitor
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "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 create ... ok 135 ms
test span ... ok 10 ms
test operators ... ok 18 ms
test math ... ok 9 ms
test datetime ... ok 10 ms
test transform ... ok 17 ms
test scalarop ... ok 7 ms
test grandagg ... ok 12 ms
test groupbyagg ... ok 10 ms
test gridagg ... ok 8 ms
test windowagg ... ok 9 ms
test hashagg ... ok 16 ms
test cumagg ... ok 8 ms
test sort ... ok 11 ms
test spec ... ok 13 ms
test drop ... ok 21 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 basic ... ok 19 ms
test version ... ok 18 ms
test guc ... ok 20 ms
test pgsm_query_id ... ok 698 ms
test functions ... FAILED 96 ms
test counters ... ok 68 ms
test relations ... ok 186 ms
test database ... ok 444 ms
test error_insert ... ok 59 ms
test application_name ... ok 49 ms
test application_name_unique ... ok 39 ms
test top_query ... ok 51 ms
test cmd_type ... ok 66 ms
test error ... ok 32 ms
test rows ... ok 73 ms
test tags ... ok 30 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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 15 ms
test version ... ok 13 ms
test guc ... ok 14 ms
test pgsm_query_id ... ok 338 ms
test functions ... FAILED 42 ms
test counters ... ok 46 ms
test relations ... ok 109 ms
test database ... ok 341 ms
test error_insert ... ok 44 ms
test application_name ... ok 42 ms
test application_name_unique ... ok 17 ms
test top_query ... ok 16 ms
test cmd_type ... ok 38 ms
test error ... ok 48 ms
test rows ... ok 37 ms
test tags ... ok 13 ms
test user ... ok 28 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 "regression" ==============
SET
DROP DATABASE
============== creating database "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 create ... ok 83 ms
test span ... ok 11 ms
test operators ... ok 17 ms
test math ... ok 7 ms
test datetime ... ok 8 ms
test transform ... ok 15 ms
test scalarop ... ok 6 ms
test grandagg ... ok 10 ms
test groupbyagg ... ok 8 ms
test gridagg ... ok 6 ms
test windowagg ... ok 7 ms
test hashagg ... ok 10 ms
test cumagg ... ok 6 ms
test sort ... ok 8 ms
test spec ... ok 9 ms
test drop ... ok 12 ms
======================
All 16 tests passed.
======================
waiting for server to shut down.... done
server stopped
pgextwlist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test create ... ok 143 ms
test span ... ok 18 ms
test operators ... ok 30 ms
test math ... ok 15 ms
test datetime ... ok 18 ms
test transform ... ok 28 ms
test scalarop ... ok 12 ms
test grandagg ... ok 19 ms
test groupbyagg ... ok 14 ms
test gridagg ... ok 9 ms
test windowagg ... ok 12 ms
test hashagg ... ok 18 ms
test cumagg ... ok 10 ms
test sort ... ok 13 ms
test spec ... ok 14 ms
test drop ... ok 23 ms
======================
All 16 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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 63 ms
test pgextwlist ... FAILED 85 ms
test errors ... FAILED 8 ms
test crossuser ... ok 50 ms
test hooks ... ok 33 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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 39 ms
test pgextwlist ... FAILED 70 ms
test errors ... FAILED 8 ms
test crossuser ... ok 17 ms
test hooks ... ok 29 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 "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test create ... ok 96 ms
test span ... ok 11 ms
test operators ... ok 17 ms
test math ... ok 8 ms
test datetime ... ok 10 ms
test transform ... ok 15 ms
test scalarop ... ok 7 ms
test grandagg ... ok 12 ms
test groupbyagg ... ok 9 ms
test gridagg ... ok 7 ms
test windowagg ... ok 9 ms
test hashagg ... ok 12 ms
test cumagg ... ok 8 ms
test sort ... ok 11 ms
test spec ... ok 14 ms
test drop ... ok 17 ms
======================
All 16 tests passed.
======================
waiting for server to shut down.... done
server stopped
plprofiler
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
seg
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 seg ==============
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 112 ms
test span ... ok 18 ms
test operators ... ok 30 ms
test math ... ok 15 ms
test datetime ... ok 17 ms
test transform ... ok 25 ms
test scalarop ... ok 12 ms
test grandagg ... ok 19 ms
test groupbyagg ... ok 17 ms
test gridagg ... ok 12 ms
test windowagg ... ok 16 ms
test hashagg ... ok 19 ms
test cumagg ... ok 12 ms
test sort ... ok 17 ms
test spec ... ok 19 ms
test drop ... ok 22 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 security ... ok 26 ms
test seg ... FAILED 67 ms
======================
1 of 2 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/seg/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/seg/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 imcs ==============
CREATE EXTENSION
============== running regression test queries ==============
test security ... ok 33 ms
test seg ... FAILED 70 ms
======================
1 of 2 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/seg/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/seg/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 seg ==============
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 67 ms
test span ... ok 8 ms
test operators ... ok 14 ms
test math ... ok 7 ms
test datetime ... ok 9 ms
test transform ... ok 13 ms
test scalarop ... ok 6 ms
test grandagg ... ok 11 ms
test groupbyagg ... ok 9 ms
test gridagg ... ok 6 ms
test windowagg ... ok 8 ms
test hashagg ... ok 10 ms
test cumagg ... ok 7 ms
test sort ... ok 8 ms
test spec ... ok 10 ms
test drop ... ok 12 ms
======================
All 16 tests passed.
======================
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 "regression" ==============
SET
DROP DATABASE
============== creating database "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\"" "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 "regression" ==============
SET
DROP DATABASE
============== creating database "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 "regression" SET timescaledb.telemetry_level = 'basic';
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 102 ms
test span ... ok 9 ms
test operators ... ok 14 ms
test math ... ok 9 ms
test datetime ... ok 10 ms
test transform ... ok 16 ms
test scalarop ... ok 8 ms
test grandagg ... ok 11 ms
test groupbyagg ... ok 9 ms
test gridagg ... ok 8 ms
test windowagg ... ok 9 ms
test hashagg ... ok 13 ms
test cumagg ... ok 8 ms
test sort ... ok 10 ms
test spec ... ok 10 ms
test drop ... ok 18 ms
======================
All 16 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 2463 ms
test alternate_users ... ok 1695 ms
test chunk_utils ... ok 1860 ms
test index ... ok 2201 ms
test pg_dump_unprivileged ... ok 1493 ms
test tablespace ... ok 1538 ms
parallel group (21 tests): chunks ddl_extra broken_tables drop_extension create_chunks ddl_errors baserel_cache delete-15 custom_type drop_hypertable create_table chunk_adaptive cluster-15 copy-15 create_hypertable cursor-15 ddl-15 agg_bookends-15 append-15 constraint-15 drop_owned
agg_bookends-15 ... ok 11852 ms
append-15 ... ok 11853 ms
baserel_cache ... ok 11826 ms
broken_tables ... ok 11818 ms
chunk_adaptive ... ok 11826 ms
chunks ... ok 11808 ms
cluster-15 ... ok 11826 ms
constraint-15 ... ok 12051 ms
copy-15 ... ok 11827 ms
create_chunks ... ok 11820 ms
create_hypertable ... ok 11828 ms
create_table ... ok 11826 ms
cursor-15 ... ok 11848 ms
custom_type ... ok 11825 ms
ddl-15 ... ok 11851 ms
ddl_errors ... ok 11825 ms
ddl_extra ... ok 11815 ms
delete-15 ... ok 11825 ms
drop_extension ... FAILED 11819 ms
drop_hypertable ... ok 11825 ms
drop_owned ... ok 12076 ms
parallel group (21 tests): null_exclusion lateral drop_schema insert_returning misc grant_hypertable information_views partition parallel-15 merge generated_as_identity hash dump_meta insert_single partitioning drop_rename_hypertable histogram_test extension_scripts license insert-15 insert_many
drop_rename_hypertable ... ok 15721 ms
drop_schema ... ok 15698 ms
dump_meta ... ok 15719 ms
extension_scripts ... ok 15721 ms
generated_as_identity ... ok 15718 ms
grant_hypertable ... ok 15714 ms
hash ... ok 15718 ms
histogram_test ... ok 15720 ms
information_views ... ok 15714 ms
insert-15 ... ok 16285 ms
insert_many ... ok 18435 ms
insert_returning ... ok 15697 ms
insert_single ... ok 15718 ms
lateral ... FAILED 15677 ms
license ... ok 15720 ms
merge ... ok 15715 ms
misc ... ok 15697 ms
null_exclusion ... ok 11340 ms
parallel-15 ... ok 15714 ms
partition ... ok 15714 ms
partitioning ... ok 15717 ms
parallel group (21 tests): reloptions update-15 timestamp tableam triggers query-15 sort_optimization upsert size_utils plan_hypertable_inline-15 sql_query partitionwise-15 plain rowsecurity-15 plan_expand_hypertable-15 plan_hashagg-15 plan_ordered_append trusted_extension truncate pg_join relocate_extension
partitionwise-15 ... ok 19456 ms
pg_join ... ok 20302 ms
plain ... FAILED 19456 ms
plan_expand_hypertable-15 ... ok 19479 ms
plan_hashagg-15 ... ok 19489 ms
plan_hypertable_inline-15 ... ok 19449 ms
plan_ordered_append ... ok 19489 ms
query-15 ... ok 19447 ms
relocate_extension ... ok 20749 ms
reloptions ... ok 18244 ms
rowsecurity-15 ... ok 19455 ms
size_utils ... ok 19448 ms
sort_optimization ... ok 19446 ms
sql_query ... ok 19449 ms
tableam ... ok 19441 ms
timestamp ... ok 19440 ms
triggers ... ok 19441 ms
truncate ... ok 20284 ms
trusted_extension ... ok 20147 ms
update-15 ... ok 19437 ms
upsert ... ok 19445 ms
parallel group (4 tests): util version vacuum_parallel vacuum
util ... ok 1666 ms
vacuum ... ok 1694 ms
vacuum_parallel ... ok 1694 ms
version ... ok 1691 ms
=======================
3 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 "regression" ==============
SET
DROP DATABASE
============== creating database "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 "regression" SET timescaledb.telemetry_level = 'basic';
CREATE EXTENSION
============== running regression test queries ==============
test create ... ok 69 ms
test span ... ok 10 ms
test operators ... ok 15 ms
test math ... ok 9 ms
test datetime ... ok 10 ms
test transform ... ok 14 ms
test scalarop ... ok 8 ms
test grandagg ... ok 11 ms
test groupbyagg ... ok 9 ms
test gridagg ... ok 8 ms
test windowagg ... ok 9 ms
test hashagg ... ok 13 ms
test cumagg ... ok 8 ms
test sort ... ok 10 ms
test spec ... ok 11 ms
test drop ... ok 14 ms
======================
All 16 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 1129 ms
test alternate_users ... ok 786 ms
test chunk_utils ... ok 885 ms
test index ... ok 1012 ms
test pg_dump_unprivileged ... ok 777 ms
test tablespace ... ok 741 ms
parallel group (21 tests): create_chunks cursor-15 ddl_errors baserel_cache create_table cluster-15 drop_hypertable custom_type broken_tables ddl_extra drop_extension chunks delete-15 chunk_adaptive create_hypertable ddl-15 agg_bookends-15 copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 4826 ms
append-15 ... ok 6523 ms
baserel_cache ... ok 4807 ms
broken_tables ... ok 4821 ms
chunk_adaptive ... ok 4825 ms
chunks ... ok 4821 ms
cluster-15 ... ok 4818 ms
constraint-15 ... ok 4929 ms
copy-15 ... ok 4843 ms
create_chunks ... ok 4803 ms
create_hypertable ... ok 4824 ms
create_table ... ok 4815 ms
cursor-15 ... ok 4803 ms
custom_type ... ok 4819 ms
ddl-15 ... ok 4824 ms
ddl_errors ... ok 4806 ms
ddl_extra ... ok 4820 ms
delete-15 ... ok 4820 ms
drop_extension ... FAILED 4820 ms
drop_hypertable ... ok 4817 ms
drop_owned ... ok 4937 ms
parallel group (21 tests): generated_as_identity misc null_exclusion hash information_views license merge grant_hypertable dump_meta partition partitioning insert_single extension_scripts lateral histogram_test drop_schema parallel-15 drop_rename_hypertable insert_returning insert-15 insert_many
drop_rename_hypertable ... ok 6223 ms
drop_schema ... ok 6222 ms
dump_meta ... ok 6168 ms
extension_scripts ... ok 6181 ms
generated_as_identity ... ok 4818 ms
grant_hypertable ... ok 6166 ms
hash ... ok 6158 ms
histogram_test ... ok 6222 ms
information_views ... ok 6158 ms
insert-15 ... ok 6393 ms
insert_many ... ok 7480 ms
insert_returning ... ok 6222 ms
insert_single ... ok 6169 ms
lateral ... FAILED 6219 ms
license ... ok 6157 ms
merge ... ok 6158 ms
misc ... ok 6153 ms
null_exclusion ... ok 6157 ms
parallel-15 ... ok 6221 ms
partition ... ok 6168 ms
partitioning ... ok 6168 ms
parallel group (21 tests): sort_optimization timestamp reloptions triggers rowsecurity-15 plan_hypertable_inline-15 size_utils sql_query tableam partitionwise-15 update-15 plain query-15 plan_expand_hypertable-15 plan_ordered_append upsert plan_hashagg-15 trusted_extension truncate relocate_extension pg_join
partitionwise-15 ... ok 9270 ms
pg_join ... ok 11101 ms
plain ... FAILED 9270 ms
plan_expand_hypertable-15 ... ok 9299 ms
plan_hashagg-15 ... ok 9436 ms
plan_hypertable_inline-15 ... ok 9262 ms
plan_ordered_append ... ok 9298 ms
query-15 ... ok 9290 ms
relocate_extension ... ok 10259 ms
reloptions ... ok 9205 ms
rowsecurity-15 ... ok 9218 ms
size_utils ... ok 9262 ms
sort_optimization ... ok 8405 ms
sql_query ... ok 9262 ms
tableam ... ok 9265 ms
timestamp ... ok 9203 ms
triggers ... ok 9204 ms
truncate ... ok 9844 ms
trusted_extension ... ok 9841 ms
update-15 ... ok 9268 ms
upsert ... ok 9297 ms
parallel group (4 tests): version util vacuum_parallel vacuum
util ... ok 956 ms
vacuum ... ok 959 ms
vacuum_parallel ... ok 958 ms
version ... ok 939 ms
=======================
3 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".