pgtt
Repository:
https://github.com/darold/pgtt
Temporary table data can be persisted across sessions and transactions using a mechanism that automatically manages storage and cleanup of temporary tables, allowing them to behave like regular tables for querying and indexing purposes.
Information Analysis
| Extensibility Types: | Query Processing, Utility Commands |
| System Components: | Custom Configuration Variables |
Duplicate Code Analysis
| Total Lines of Code: ? | 2031 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 2031 |
| Lines of Encapsulated Versioning Code: ? | 248 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 12.21% |
| PostgreSQL Versions Cased On: ? | 9,10,11,12,13,14,15 |
Compatibility Analysis
| Number of Failed Extensions: | 14 |
| Failure Rate: | 10.0% |
Failed Extensions
amcheck
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 amcheck ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 76 ms
test 01_oncommitdelete ... ok 89 ms
test 02_oncommitpreserve ... ok 87 ms
test 03_createontruncate ... ok 103 ms
test 04_rename ... ok 139 ms
test 05_useindex ... ok 191 ms
test 06_createas ... ok 78 ms
test 07_createlike ... ok 126 ms
test 08_plplgsql ... FAILED 93 ms
test 09_transaction ... ok 79 ms
test 10_foreignkey ... ok 36 ms
test 11_after_error ... ok 86 ms
test 12_droptable ... ok 67 ms
=======================
1 of 13 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test check ... ok 11 ms
test check_btree ... ok 1991 ms
test check_heap ... ok 175 ms
=====================
All 3 tests passed.
=====================
waiting for server to shut down.... done
server stopped
dict_xsyn
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 dict_xsyn ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 86 ms
test 01_oncommitdelete ... ok 104 ms
test 02_oncommitpreserve ... ok 88 ms
test 03_createontruncate ... ok 106 ms
test 04_rename ... ok 146 ms
test 05_useindex ... ok 187 ms
test 06_createas ... ok 81 ms
test 07_createlike ... ok 128 ms
test 08_plplgsql ... FAILED 89 ms
test 09_transaction ... ok 89 ms
test 10_foreignkey ... ok 38 ms
test 11_after_error ... ok 89 ms
test 12_droptable ... ok 72 ms
=======================
1 of 13 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test dict_xsyn ... ok 47 ms
=====================
All 1 tests passed.
=====================
waiting for server to shut down.... done
server stopped
hll
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 hll ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 79 ms
test 01_oncommitdelete ... ok 102 ms
test 02_oncommitpreserve ... ok 65 ms
test 03_createontruncate ... ok 106 ms
test 04_rename ... ok 146 ms
test 05_useindex ... ok 201 ms
test 06_createas ... ok 79 ms
test 07_createlike ... ok 125 ms
test 08_plplgsql ... FAILED 76 ms
test 09_transaction ... ok 107 ms
test 10_foreignkey ... ok 39 ms
test 11_after_error ... ok 96 ms
test 12_droptable ... ok 71 ms
=======================
1 of 13 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 58 ms
test add_agg ... ok 48 ms
test agg_oob ... ok 83 ms
test auto_sparse ... ok 16 ms
test card_op ... ok 6 ms
test cast_shape ... ok 7 ms
test copy_binary ... ok 39 ms
test cumulative_add_cardinality_correction ... ok 553 ms
test cumulative_add_comprehensive_promotion ... ok 753 ms
test cumulative_add_sparse_edge ... ok 70 ms
test cumulative_add_sparse_random ... ok 77 ms
test cumulative_add_sparse_step ... ok 64 ms
test cumulative_union_comprehensive ... ok 2220 ms
test cumulative_union_explicit_explicit ... ok 87 ms
test cumulative_union_explicit_promotion ... ok 475 ms
test cumulative_union_probabilistic_probabilistic ... ok 6187 ms
test cumulative_union_sparse_full_representation ... ok 14 ms
test cumulative_union_sparse_promotion ... ok 5498 ms
test cumulative_union_sparse_sparse ... ok 654 ms
test disable_hashagg ... ok 43 ms
test equal ... ok 20 ms
test explicit_thresh ... ok 23 ms
test hash ... ok 25 ms
test hash_any ... ok 20 ms
test meta_func ... ok 22 ms
test murmur_bigint ... ok 25 ms
test murmur_bytea ... ok 41 ms
test nosparse ... ok 15 ms
test notequal ... ok 20 ms
test scalar_oob ... ok 20 ms
test storedproc ... ok 17 ms
test transaction ... ok 15 ms
test typmod ... ok 176 ms
test typmod_insert ... ok 23 ms
test union_op ... ok 14 ms
======================
All 35 tests passed.
======================
waiting for server to shut down.... done
server stopped
pageinspect
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 pageinspect ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 37 ms
test 01_oncommitdelete ... ok 78 ms
test 02_oncommitpreserve ... ok 65 ms
test 03_createontruncate ... ok 78 ms
test 04_rename ... ok 97 ms
test 05_useindex ... ok 123 ms
test 06_createas ... ok 69 ms
test 07_createlike ... ok 87 ms
test 08_plplgsql ... FAILED 59 ms
test 09_transaction ... ok 68 ms
test 10_foreignkey ... ok 34 ms
test 11_after_error ... ok 75 ms
test 12_droptable ... ok 51 ms
=======================
1 of 13 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test page ... ok 40 ms
test btree ... ok 59 ms
test brin ... ok 52 ms
test gin ... ok 178 ms
test gist ... ok 39 ms
test hash ... ok 65 ms
test checksum ... ok 20 ms
test oldextversions ... ok 68 ms
=====================
All 8 tests passed.
=====================
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 "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_bigm ... ok 134 ms
test pg_bigm_ja ... ok 33 ms
=====================
All 2 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_bigm ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 60 ms
test 01_oncommitdelete ... ok 66 ms
test 02_oncommitpreserve ... ok 51 ms
test 03_createontruncate ... ok 74 ms
test 04_rename ... ok 110 ms
test 05_useindex ... ok 102 ms
test 06_createas ... ok 45 ms
test 07_createlike ... ok 81 ms
test 08_plplgsql ... FAILED 65 ms
test 09_transaction ... ok 69 ms
test 10_foreignkey ... ok 33 ms
test 11_after_error ... ok 65 ms
test 12_droptable ... ok 37 ms
=======================
1 of 13 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.out".
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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_cron-test ... ok 441 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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_cron-test ... ok 459 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 00_init ... ok 72 ms
test 01_oncommitdelete ... ok 101 ms
test 02_oncommitpreserve ... ok 79 ms
test 03_createontruncate ... ok 99 ms
test 04_rename ... ok 121 ms
test 05_useindex ... ok 171 ms
test 06_createas ... ok 77 ms
test 07_createlike ... ok 105 ms
test 08_plplgsql ... ok 96 ms
test 09_transaction ... ok 95 ms
test 10_foreignkey ... ok 39 ms
test 11_after_error ... ok 85 ms
test 12_droptable ... ok 62 ms
======================
All 13 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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 27 ms
test test1 ... ok 40 ms
test test2 ... ok 47 ms
test test3 ... ok 89 ms
test test4 ... ok 294 ms
test test5 ... ok 46 ms
test test6 ... ok 76 ms
test test7 ... FAILED 23 ms
test test8 ... ok 39 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_repack
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(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_repack ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 70 ms
test 01_oncommitdelete ... ok 95 ms
test 02_oncommitpreserve ... ok 79 ms
test 03_createontruncate ... ok 92 ms
test 04_rename ... ok 133 ms
test 05_useindex ... ok 169 ms
test 06_createas ... ok 73 ms
test 07_createlike ... ok 110 ms
test 08_plplgsql ... ok 88 ms
test 09_transaction ... ok 86 ms
test 10_foreignkey ... ok 36 ms
test 11_after_error ... ok 84 ms
test 12_droptable ... ok 62 ms
======================
All 13 tests passed.
======================
CREATE TABLESPACE
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test init-extension ... ok 46 ms
test repack-setup ... ok 415 ms
test repack-run ... FAILED 1266 ms
test error-on-invalid-idx ... FAILED 952 ms
test after-schema ... ok 60 ms
test repack-check ... ok 3302 ms
test nosuper ... ok 204 ms
test tablespace ... ok 1652 ms
test get_order_by ... ok 802 ms
======================
2 of 9 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.out".
ERROR: tablespace "testts" is not empty
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
CREATE TABLESPACE
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test init-extension ... ok 30 ms
test repack-setup ... ok 263 ms
test repack-run ... FAILED 866 ms
test error-on-invalid-idx ... FAILED 785 ms
test after-schema ... ok 33 ms
test repack-check ... ok 2561 ms
test nosuper ... ok 169 ms
test tablespace ... ok 1152 ms
test get_order_by ... ok 579 ms
======================
2 of 9 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_repack/regression.out".
ERROR: tablespace "testts" is not empty
(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_repack ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 40 ms
test 01_oncommitdelete ... ok 75 ms
test 02_oncommitpreserve ... ok 66 ms
test 03_createontruncate ... ok 76 ms
test 04_rename ... ok 92 ms
test 05_useindex ... ok 136 ms
test 06_createas ... ok 62 ms
test 07_createlike ... ok 82 ms
test 08_plplgsql ... ok 90 ms
test 09_transaction ... ok 73 ms
test 10_foreignkey ... ok 33 ms
test 11_after_error ... ok 70 ms
test 12_droptable ... ok 49 ms
======================
All 13 tests passed.
======================
waiting for server to shut down.... done
server stopped
pg_show_plans
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?
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 00_init ... ok 80 ms
test 01_oncommitdelete ... ok 100 ms
test 02_oncommitpreserve ... ok 88 ms
test 03_createontruncate ... ok 102 ms
test 04_rename ... ok 154 ms
test 05_useindex ... ok 198 ms
test 06_createas ... ok 82 ms
test 07_createlike ... ok 132 ms
test 08_plplgsql ... ok 117 ms
test 09_transaction ... ok 112 ms
test 10_foreignkey ... ok 37 ms
test 11_after_error ... ok 93 ms
test 12_droptable ... ok 72 ms
======================
All 13 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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 62 ms
test pgextwlist ... FAILED 83 ms
test errors ... FAILED 8 ms
test crossuser ... ok 47 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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 26 ms
test pgextwlist ... FAILED 40 ms
test errors ... FAILED 20 ms
test crossuser ... ok 35 ms
test hooks ... ok 18 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 00_init ... ok 48 ms
test 01_oncommitdelete ... ok 79 ms
test 02_oncommitpreserve ... ok 66 ms
test 03_createontruncate ... ok 76 ms
test 04_rename ... ok 98 ms
test 05_useindex ... ok 106 ms
test 06_createas ... ok 52 ms
test 07_createlike ... ok 85 ms
test 08_plplgsql ... ok 56 ms
test 09_transaction ... ok 59 ms
test 10_foreignkey ... ok 34 ms
test 11_after_error ... ok 76 ms
test 12_droptable ... ok 49 ms
======================
All 13 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 "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 pgsentinel ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 85 ms
test 01_oncommitdelete ... ok 102 ms
test 02_oncommitpreserve ... ok 89 ms
test 03_createontruncate ... ok 98 ms
test 04_rename ... ok 145 ms
test 05_useindex ... ok 198 ms
test 06_createas ... ok 78 ms
test 07_createlike ... ok 115 ms
test 08_plplgsql ... FAILED 99 ms
test 09_transaction ... ok 88 ms
test 10_foreignkey ... ok 41 ms
test 11_after_error ... ok 91 ms
test 12_droptable ... ok 74 ms
=======================
1 of 13 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgsentinel-test ... ok 9084 ms
=====================
All 1 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
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 00_init ... ok 37 ms
test 01_oncommitdelete ... ok 32 ms
test 02_oncommitpreserve ... ok 28 ms
test 03_createontruncate ... ok 36 ms
test 04_rename ... ok 48 ms
test 05_useindex ... ok 67 ms
test 06_createas ... ok 27 ms
test 07_createlike ... ok 43 ms
test 08_plplgsql ... ok 41 ms
test 09_transaction ... ok 37 ms
test 10_foreignkey ... ok 12 ms
test 11_after_error ... ok 29 ms
test 12_droptable ... ok 22 ms
======================
All 13 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 1143 ms
test alternate_users ... ok 809 ms
test chunk_utils ... ok 882 ms
test index ... ok 1031 ms
test pg_dump_unprivileged ... ok 768 ms
test tablespace ... ok 751 ms
parallel group (21 tests): chunks drop_hypertable ddl-15 ddl_extra custom_type create_table create_chunks delete-15 broken_tables baserel_cache cluster-15 ddl_errors drop_extension cursor-15 create_hypertable agg_bookends-15 chunk_adaptive copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5110 ms
append-15 ... ok 6593 ms
baserel_cache ... ok 5096 ms
broken_tables ... ok 5095 ms
chunk_adaptive ... ok 5116 ms
chunks ... ok 5083 ms
cluster-15 ... ok 5097 ms
constraint-15 ... ok 5195 ms
copy-15 ... ok 5125 ms
create_chunks ... ok 5093 ms
create_hypertable ... ok 5107 ms
create_table ... ok 5088 ms
cursor-15 ... ok 5106 ms
custom_type ... ok 5087 ms
ddl-15 ... ok 5086 ms
ddl_errors ... ok 5096 ms
ddl_extra ... ok 5086 ms
delete-15 ... ok 5093 ms
drop_extension ... FAILED 5098 ms
drop_hypertable ... ok 5083 ms
drop_owned ... ok 5213 ms
parallel group (21 tests): misc null_exclusion partitioning drop_schema hash extension_scripts merge partition parallel-15 license histogram_test dump_meta generated_as_identity drop_rename_hypertable information_views insert_single grant_hypertable lateral insert_returning insert-15 insert_many
drop_rename_hypertable ... ok 6276 ms
drop_schema ... ok 6266 ms
dump_meta ... ok 6276 ms
extension_scripts ... ok 6267 ms
generated_as_identity ... ok 6276 ms
grant_hypertable ... ok 6279 ms
hash ... ok 6266 ms
histogram_test ... ok 6272 ms
information_views ... ok 6275 ms
insert-15 ... ok 6456 ms
insert_many ... ok 7505 ms
insert_returning ... ok 6303 ms
insert_single ... ok 6275 ms
lateral ... ok 6302 ms
license ... ok 6269 ms
merge ... ok 6269 ms
misc ... ok 4917 ms
null_exclusion ... ok 6243 ms
parallel-15 ... ok 6269 ms
partition ... ok 6269 ms
partitioning ... ok 6248 ms
parallel group (21 tests): tableam triggers reloptions rowsecurity-15 upsert update-15 plan_hypertable_inline-15 plain sort_optimization timestamp query-15 sql_query partitionwise-15 size_utils plan_expand_hypertable-15 plan_ordered_append trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7611 ms
pg_join ... ok 9895 ms
plain ... ok 7596 ms
plan_expand_hypertable-15 ... ok 7614 ms
plan_hashagg-15 ... ok 8856 ms
plan_hypertable_inline-15 ... ok 7594 ms
plan_ordered_append ... ok 7717 ms
query-15 ... ok 7610 ms
relocate_extension ... ok 8279 ms
reloptions ... ok 7533 ms
rowsecurity-15 ... ok 7548 ms
size_utils ... ok 7610 ms
sort_optimization ... ok 7595 ms
sql_query ... ok 7610 ms
tableam ... ok 6905 ms
timestamp ... ok 7607 ms
triggers ... ok 7531 ms
truncate ... ok 8004 ms
trusted_extension ... ok 8000 ms
update-15 ... ok 7592 ms
upsert ... ok 7588 ms
parallel group (4 tests): version util vacuum vacuum_parallel
util ... ok 697 ms
vacuum ... ok 699 ms
vacuum_parallel ... ok 700 ms
version ... ok 690 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 "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 00_init ... ok 34 ms
test 01_oncommitdelete ... ok 34 ms
test 02_oncommitpreserve ... ok 29 ms
test 03_createontruncate ... ok 41 ms
test 04_rename ... ok 54 ms
test 05_useindex ... ok 82 ms
test 06_createas ... ok 32 ms
test 07_createlike ... ok 44 ms
test 08_plplgsql ... ok 45 ms
test 09_transaction ... ok 43 ms
test 10_foreignkey ... ok 13 ms
test 11_after_error ... ok 29 ms
test 12_droptable ... ok 23 ms
======================
All 13 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 1107 ms
test alternate_users ... ok 829 ms
test chunk_utils ... ok 884 ms
test index ... ok 1057 ms
test pg_dump_unprivileged ... ok 767 ms
test tablespace ... ok 745 ms
parallel group (21 tests): chunks broken_tables drop_extension create_table ddl_extra create_chunks custom_type ddl-15 cursor-15 agg_bookends-15 drop_hypertable delete-15 ddl_errors chunk_adaptive cluster-15 baserel_cache create_hypertable copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5325 ms
append-15 ... ok 6812 ms
baserel_cache ... ok 5341 ms
broken_tables ... ok 5309 ms
chunk_adaptive ... ok 5338 ms
chunks ... ok 5301 ms
cluster-15 ... ok 5339 ms
constraint-15 ... ok 5415 ms
copy-15 ... ok 5348 ms
create_chunks ... ok 5319 ms
create_hypertable ... ok 5345 ms
create_table ... ok 5317 ms
cursor-15 ... ok 5322 ms
custom_type ... ok 5322 ms
ddl-15 ... ok 5321 ms
ddl_errors ... ok 5332 ms
ddl_extra ... ok 5316 ms
delete-15 ... ok 5329 ms
drop_extension ... FAILED 5314 ms
drop_hypertable ... ok 5323 ms
drop_owned ... ok 5439 ms
parallel group (21 tests): misc license lateral partitioning insert_returning grant_hypertable information_views partition extension_scripts drop_schema drop_rename_hypertable histogram_test dump_meta insert_single hash merge parallel-15 generated_as_identity null_exclusion insert-15 insert_many
drop_rename_hypertable ... ok 6058 ms
drop_schema ... ok 6056 ms
dump_meta ... ok 6065 ms
extension_scripts ... ok 6052 ms
generated_as_identity ... ok 6097 ms
grant_hypertable ... ok 6049 ms
hash ... ok 6091 ms
histogram_test ... ok 6058 ms
information_views ... ok 6049 ms
insert-15 ... ok 6249 ms
insert_many ... ok 7415 ms
insert_returning ... ok 6042 ms
insert_single ... ok 6066 ms
lateral ... ok 6037 ms
license ... ok 6032 ms
merge ... ok 6096 ms
misc ... ok 4917 ms
null_exclusion ... ok 6096 ms
parallel-15 ... ok 6096 ms
partition ... ok 6048 ms
partitioning ... ok 6038 ms
parallel group (21 tests): tableam sort_optimization partitionwise-15 timestamp upsert query-15 reloptions sql_query triggers update-15 size_utils plain plan_ordered_append plan_expand_hypertable-15 plan_hypertable_inline-15 rowsecurity-15 trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 8317 ms
pg_join ... ok 10443 ms
plain ... ok 8352 ms
plan_expand_hypertable-15 ... ok 8352 ms
plan_hashagg-15 ... ok 9165 ms
plan_hypertable_inline-15 ... ok 8361 ms
plan_ordered_append ... ok 8351 ms
query-15 ... ok 8322 ms
relocate_extension ... ok 9061 ms
reloptions ... ok 8340 ms
rowsecurity-15 ... ok 8360 ms
size_utils ... ok 8348 ms
sort_optimization ... ok 8299 ms
sql_query ... ok 8342 ms
tableam ... ok 7602 ms
timestamp ... ok 8317 ms
triggers ... ok 8345 ms
truncate ... ok 8791 ms
trusted_extension ... ok 8672 ms
update-15 ... ok 8344 ms
upsert ... ok 8317 ms
parallel group (4 tests): util version vacuum_parallel vacuum
util ... ok 739 ms
vacuum ... ok 752 ms
vacuum_parallel ... ok 751 ms
version ... ok 749 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".
tsm_system_rows
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 tsm_system_rows ==============
CREATE EXTENSION
============== running regression test queries ==============
test 00_init ... ok 57 ms
test 01_oncommitdelete ... ok 96 ms
test 02_oncommitpreserve ... ok 85 ms
test 03_createontruncate ... ok 96 ms
test 04_rename ... ok 144 ms
test 05_useindex ... ok 185 ms
test 06_createas ... ok 61 ms
test 07_createlike ... ok 120 ms
test 08_plplgsql ... FAILED 122 ms
test 09_transaction ... ok 98 ms
test 10_foreignkey ... ok 36 ms
test 11_after_error ... ok 73 ms
test 12_droptable ... ok 66 ms
=======================
1 of 13 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/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 pgtt ==============
CREATE EXTENSION
============== running regression test queries ==============
test tsm_system_rows ... ok 36 ms
=====================
All 1 tests passed.
=====================
waiting for server to shut down.... done
server stopped