pgcrypto
The implementation provides a set of data encryption and decryption functions, including support for symmetric and asymmetric encryption algorithms, hash functions, and random number generation, which can be used to protect and verify data within a database.
Information Analysis
| Extensibility Types: | Functions |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 11668 |
| Lines of Duplicate Code: ? | 36 |
| Percentage of Codebase: ? | 0.31% |
Versioning Analysis
| Total Lines of Code: ? | 11668 |
| Lines of Encapsulated Versioning Code: ? | 0 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0% |
Compatibility Analysis
| Number of Failed Extensions: | 10 |
| Failure Rate: | 8.4% |
Failed Extensions
earthdistance
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube ==============
CREATE EXTENSION
============== installing earthdistance ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 36 ms
test md5 ... ok 24 ms
test sha1 ... ok 24 ms
test hmac-md5 ... ok 24 ms
test hmac-sha1 ... ok 24 ms
test blowfish ... ok 29 ms
test rijndael ... ok 31 ms
test sha2 ... ok 16 ms
test des ... ok 8 ms
test 3des ... ok 7 ms
test cast5 ... ok 7 ms
test crypt-des ... ok 31 ms
test crypt-md5 ... ok 32 ms
test crypt-blowfish ... ok 60 ms
test crypt-xdes ... ok 35 ms
test pgp-armor ... ok 39 ms
test pgp-decrypt ... ok 60 ms
test pgp-encrypt ... ok 396 ms
test pgp-compression ... ok 16 ms
test pgp-pubkey-decrypt ... ok 119 ms
test pgp-pubkey-encrypt ... ok 20 ms
test pgp-info ... ok 8 ms
======================
All 22 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 187 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 192 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube ==============
CREATE EXTENSION
============== installing earthdistance ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 9 ms
test md5 ... ok 7 ms
test sha1 ... ok 6 ms
test hmac-md5 ... ok 7 ms
test hmac-sha1 ... ok 6 ms
test blowfish ... ok 7 ms
test rijndael ... ok 7 ms
test sha2 ... ok 7 ms
test des ... ok 6 ms
test 3des ... ok 6 ms
test cast5 ... ok 6 ms
test crypt-des ... ok 19 ms
test crypt-md5 ... ok 49 ms
test crypt-blowfish ... ok 93 ms
test crypt-xdes ... ok 29 ms
test pgp-armor ... ok 39 ms
test pgp-decrypt ... ok 54 ms
test pgp-encrypt ... ok 405 ms
test pgp-compression ... ok 14 ms
test pgp-pubkey-decrypt ... ok 46 ms
test pgp-pubkey-encrypt ... ok 22 ms
test pgp-info ... ok 7 ms
======================
All 22 tests passed.
======================
waiting for server to shut down.... done
server stopped
jsonb_plpython3u
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 plpython3u ==============
CREATE EXTENSION
============== installing jsonb_plpython3u ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 10 ms
test md5 ... ok 7 ms
test sha1 ... ok 7 ms
test hmac-md5 ... ok 7 ms
test hmac-sha1 ... ok 7 ms
test blowfish ... ok 7 ms
test rijndael ... ok 7 ms
test sha2 ... ok 8 ms
test des ... ok 6 ms
test 3des ... ok 7 ms
test cast5 ... ok 6 ms
test crypt-des ... ok 17 ms
test crypt-md5 ... ok 19 ms
test crypt-blowfish ... ok 52 ms
test crypt-xdes ... ok 22 ms
test pgp-armor ... ok 37 ms
test pgp-decrypt ... FAILED 52 ms
test pgp-encrypt ... ok 395 ms
test pgp-compression ... ok 15 ms
test pgp-pubkey-decrypt ... ok 80 ms
test pgp-pubkey-encrypt ... ok 21 ms
test pgp-info ... ok 8 ms
=======================
1 of 22 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/pgcrypto/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/pgcrypto/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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test jsonb_plpython ... ok 67 ms
=====================
All 1 tests passed.
=====================
waiting for server to shut down.... done
server stopped
pg_query_rewrite
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_query_rewrite ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 18 ms
test md5 ... ok 7 ms
test sha1 ... ok 7 ms
test hmac-md5 ... ok 7 ms
test hmac-sha1 ... ok 7 ms
test blowfish ... ok 7 ms
test rijndael ... ok 8 ms
test sha2 ... ok 8 ms
test des ... ok 6 ms
test 3des ... ok 7 ms
test cast5 ... ok 6 ms
test crypt-des ... ok 20 ms
test crypt-md5 ... ok 50 ms
test crypt-blowfish ... ok 88 ms
test crypt-xdes ... ok 20 ms
test pgp-armor ... ok 14 ms
test pgp-decrypt ... ok 31 ms
test pgp-encrypt ... ok 401 ms
test pgp-compression ... ok 15 ms
test pgp-pubkey-decrypt ... ok 58 ms
test pgp-pubkey-encrypt ... ok 17 ms
test pgp-info ... ok 7 ms
======================
All 22 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 12 ms
test test1 ... ok 18 ms
test test2 ... ok 22 ms
test test3 ... ok 54 ms
test test4 ... ok 161 ms
test test5 ... ok 13 ms
test test6 ... ok 39 ms
test test7 ... FAILED 25 ms
test test8 ... ok 36 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
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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 13 ms
test test1 ... ok 19 ms
test test2 ... ok 33 ms
test test3 ... ok 85 ms
test test4 ... ok 308 ms
test test5 ... ok 50 ms
test test6 ... ok 84 ms
test test7 ... ok 28 ms
test test8 ... ok 34 ms
=====================
All 9 tests passed.
=====================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_query_rewrite ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 12 ms
test md5 ... ok 7 ms
test sha1 ... ok 7 ms
test hmac-md5 ... ok 10 ms
test hmac-sha1 ... ok 11 ms
test blowfish ... ok 11 ms
test rijndael ... ok 13 ms
test sha2 ... ok 13 ms
test des ... ok 11 ms
test 3des ... ok 11 ms
test cast5 ... ok 10 ms
test crypt-des ... ok 39 ms
test crypt-md5 ... ok 65 ms
test crypt-blowfish ... ok 101 ms
test crypt-xdes ... ok 39 ms
test pgp-armor ... ok 40 ms
test pgp-decrypt ... ok 69 ms
test pgp-encrypt ... ok 403 ms
test pgp-compression ... ok 16 ms
test pgp-pubkey-decrypt ... ok 91 ms
test pgp-pubkey-encrypt ... ok 21 ms
test pgp-info ... ok 9 ms
======================
All 22 tests passed.
======================
CREATE EXTENSION
CREATE EXTENSION
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (client-side)...
100000 of 1000000 tuples (10%) done (elapsed 0.07 s, remaining 0.67 s)
200000 of 1000000 tuples (20%) done (elapsed 0.17 s, remaining 0.67 s)
300000 of 1000000 tuples (30%) done (elapsed 0.28 s, remaining 0.64 s)
400000 of 1000000 tuples (40%) done (elapsed 0.35 s, remaining 0.52 s)
500000 of 1000000 tuples (50%) done (elapsed 0.44 s, remaining 0.44 s)
600000 of 1000000 tuples (60%) done (elapsed 0.59 s, remaining 0.39 s)
700000 of 1000000 tuples (70%) done (elapsed 0.65 s, remaining 0.28 s)
800000 of 1000000 tuples (80%) done (elapsed 0.78 s, remaining 0.20 s)
900000 of 1000000 tuples (90%) done (elapsed 0.89 s, remaining 0.10 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.96 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done in 1.46 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 1.02 s, vacuum 0.12 s, primary keys 0.30 s).
CREATE EXTENSION
CREATE EXTENSION
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (client-side)...
100000 of 1000000 tuples (10%) done (elapsed 0.06 s, remaining 0.57 s)
200000 of 1000000 tuples (20%) done (elapsed 0.13 s, remaining 0.51 s)
300000 of 1000000 tuples (30%) done (elapsed 0.22 s, remaining 0.50 s)
400000 of 1000000 tuples (40%) done (elapsed 0.29 s, remaining 0.44 s)
500000 of 1000000 tuples (50%) done (elapsed 0.37 s, remaining 0.37 s)
600000 of 1000000 tuples (60%) done (elapsed 0.43 s, remaining 0.29 s)
700000 of 1000000 tuples (70%) done (elapsed 0.53 s, remaining 0.23 s)
800000 of 1000000 tuples (80%) done (elapsed 0.60 s, remaining 0.15 s)
900000 of 1000000 tuples (90%) done (elapsed 0.67 s, remaining 0.07 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.75 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done in 1.18 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 0.78 s, vacuum 0.11 s, primary keys 0.29 s).
waiting for server to shut down.... done
server stopped
pg_stat_monitor
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_monitor ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 10 ms
test md5 ... ok 7 ms
test sha1 ... ok 8 ms
test hmac-md5 ... ok 9 ms
test hmac-sha1 ... ok 13 ms
test blowfish ... ok 14 ms
test rijndael ... ok 15 ms
test sha2 ... ok 16 ms
test des ... ok 12 ms
test 3des ... ok 13 ms
test cast5 ... ok 12 ms
test crypt-des ... ok 34 ms
test crypt-md5 ... ok 52 ms
test crypt-blowfish ... ok 80 ms
test crypt-xdes ... ok 19 ms
test pgp-armor ... ok 9 ms
test pgp-decrypt ... ok 22 ms
test pgp-encrypt ... ok 399 ms
test pgp-compression ... ok 16 ms
test pgp-pubkey-decrypt ... ok 79 ms
test pgp-pubkey-encrypt ... ok 19 ms
test pgp-info ... ok 8 ms
======================
All 22 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 19 ms
test version ... ok 17 ms
test guc ... ok 19 ms
test pgsm_query_id ... ok 350 ms
test functions ... FAILED 36 ms
test counters ... ok 48 ms
test relations ... ok 124 ms
test database ... ok 321 ms
test error_insert ... ok 39 ms
test application_name ... ok 16 ms
test application_name_unique ... ok 16 ms
test top_query ... ok 22 ms
test cmd_type ... ok 24 ms
test error ... ok 16 ms
test rows ... ok 31 ms
test tags ... ok 15 ms
test user ... ok 34 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 21 ms
test version ... ok 19 ms
test guc ... ok 21 ms
test pgsm_query_id ... ok 638 ms
test functions ... FAILED 72 ms
test counters ... ok 70 ms
test relations ... ok 164 ms
test database ... ok 447 ms
test error_insert ... ok 68 ms
test application_name ... ok 37 ms
test application_name_unique ... ok 30 ms
test top_query ... ok 32 ms
test cmd_type ... ok 59 ms
test error ... ok 48 ms
test rows ... ok 88 ms
test tags ... ok 46 ms
test user ... ok 78 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_monitor ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 14 ms
test md5 ... ok 10 ms
test sha1 ... ok 9 ms
test hmac-md5 ... ok 10 ms
test hmac-sha1 ... ok 10 ms
test blowfish ... ok 11 ms
test rijndael ... ok 11 ms
test sha2 ... ok 11 ms
test des ... ok 10 ms
test 3des ... ok 10 ms
test cast5 ... ok 10 ms
test crypt-des ... ok 35 ms
test crypt-md5 ... ok 54 ms
test crypt-blowfish ... ok 122 ms
test crypt-xdes ... ok 38 ms
test pgp-armor ... ok 42 ms
test pgp-decrypt ... ok 58 ms
test pgp-encrypt ... ok 394 ms
test pgp-compression ... ok 15 ms
test pgp-pubkey-decrypt ... ok 95 ms
test pgp-pubkey-encrypt ... ok 30 ms
test pgp-info ... ok 8 ms
======================
All 22 tests passed.
======================
waiting for server to shut down.... done
server stopped
pg_tle
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_tle ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 12 ms
test md5 ... ok 8 ms
test sha1 ... ok 9 ms
test hmac-md5 ... ok 9 ms
test hmac-sha1 ... ok 10 ms
test blowfish ... ok 11 ms
test rijndael ... ok 11 ms
test sha2 ... ok 11 ms
test des ... ok 9 ms
test 3des ... ok 10 ms
test cast5 ... ok 10 ms
test crypt-des ... ok 32 ms
test crypt-md5 ... ok 58 ms
test crypt-blowfish ... ok 90 ms
test crypt-xdes ... ok 37 ms
test pgp-armor ... ok 27 ms
test pgp-decrypt ... ok 49 ms
test pgp-encrypt ... ok 398 ms
test pgp-compression ... ok 14 ms
test pgp-pubkey-decrypt ... ok 92 ms
test pgp-pubkey-encrypt ... ok 19 ms
test pgp-info ... ok 8 ms
======================
All 22 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_tle_api ... ok 227 ms
test pg_tle_management ... FAILED 179 ms
test pg_tle_injection ... FAILED 37 ms
test pg_tle_perms ... FAILED 94 ms
test pg_tle_requires ... ok 33 ms
======================
3 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_tle-1.0.4/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_tle-1.0.4/regression.out".
waiting for server to shut down.... done
server stopped
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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_tle_api ... ok 391 ms
test pg_tle_management ... ok 331 ms
test pg_tle_injection ... ok 83 ms
test pg_tle_perms ... ok 225 ms
test pg_tle_requires ... ok 67 ms
=====================
All 5 tests passed.
=====================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_tle ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 24 ms
test md5 ... ok 19 ms
test sha1 ... ok 16 ms
test hmac-md5 ... ok 16 ms
test hmac-sha1 ... ok 16 ms
test blowfish ... ok 18 ms
test rijndael ... ok 19 ms
test sha2 ... ok 20 ms
test des ... ok 15 ms
test 3des ... ok 16 ms
test cast5 ... ok 16 ms
test crypt-des ... ok 46 ms
test crypt-md5 ... ok 66 ms
test crypt-blowfish ... ok 123 ms
test crypt-xdes ... ok 36 ms
test pgp-armor ... ok 11 ms
test pgp-decrypt ... ok 26 ms
test pgp-encrypt ... ok 411 ms
test pgp-compression ... ok 14 ms
test pgp-pubkey-decrypt ... ok 84 ms
test pgp-pubkey-encrypt ... ok 18 ms
test pgp-info ... ok 7 ms
======================
All 22 tests passed.
======================
CREATE EXTENSION
CREATE EXTENSION
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (client-side)...
100000 of 1000000 tuples (10%) done (elapsed 0.06 s, remaining 0.57 s)
200000 of 1000000 tuples (20%) done (elapsed 0.18 s, remaining 0.71 s)
300000 of 1000000 tuples (30%) done (elapsed 0.26 s, remaining 0.60 s)
400000 of 1000000 tuples (40%) done (elapsed 0.39 s, remaining 0.58 s)
500000 of 1000000 tuples (50%) done (elapsed 0.50 s, remaining 0.50 s)
600000 of 1000000 tuples (60%) done (elapsed 0.57 s, remaining 0.38 s)
700000 of 1000000 tuples (70%) done (elapsed 0.68 s, remaining 0.29 s)
800000 of 1000000 tuples (80%) done (elapsed 0.79 s, remaining 0.20 s)
900000 of 1000000 tuples (90%) done (elapsed 0.88 s, remaining 0.10 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.99 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done in 1.44 s (drop tables 0.00 s, create tables 0.00 s, client-side generate 1.01 s, vacuum 0.11 s, primary keys 0.31 s).
CREATE EXTENSION
CREATE EXTENSION
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (client-side)...
100000 of 1000000 tuples (10%) done (elapsed 0.07 s, remaining 0.65 s)
200000 of 1000000 tuples (20%) done (elapsed 0.15 s, remaining 0.61 s)
300000 of 1000000 tuples (30%) done (elapsed 0.24 s, remaining 0.57 s)
400000 of 1000000 tuples (40%) done (elapsed 0.32 s, remaining 0.49 s)
500000 of 1000000 tuples (50%) done (elapsed 0.41 s, remaining 0.41 s)
600000 of 1000000 tuples (60%) done (elapsed 0.49 s, remaining 0.33 s)
700000 of 1000000 tuples (70%) done (elapsed 0.57 s, remaining 0.24 s)
800000 of 1000000 tuples (80%) done (elapsed 0.64 s, remaining 0.16 s)
900000 of 1000000 tuples (90%) done (elapsed 0.72 s, remaining 0.08 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.80 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done in 1.23 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 0.83 s, vacuum 0.11 s, primary keys 0.27 s).
waiting for server to shut down.... done
server stopped
pgextwlist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test init ... ok 27 ms
test md5 ... ok 7 ms
test sha1 ... ok 7 ms
test hmac-md5 ... ok 7 ms
test hmac-sha1 ... ok 7 ms
test blowfish ... ok 7 ms
test rijndael ... ok 8 ms
test sha2 ... ok 8 ms
test des ... ok 7 ms
test 3des ... ok 7 ms
test cast5 ... ok 7 ms
test crypt-des ... ok 29 ms
test crypt-md5 ... ok 50 ms
test crypt-blowfish ... ok 118 ms
test crypt-xdes ... ok 44 ms
test pgp-armor ... ok 39 ms
test pgp-decrypt ... ok 52 ms
test pgp-encrypt ... ok 396 ms
test pgp-compression ... ok 15 ms
test pgp-pubkey-decrypt ... ok 82 ms
test pgp-pubkey-encrypt ... ok 21 ms
test pgp-info ... ok 9 ms
======================
All 22 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 35 ms
test pgextwlist ... FAILED 68 ms
test errors ... FAILED 8 ms
test crossuser ... ok 16 ms
test hooks ... ok 8 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 45 ms
test pgextwlist ... FAILED 80 ms
test errors ... FAILED 9 ms
test crossuser ... ok 49 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".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test init ... ok 14 ms
test md5 ... ok 6 ms
test sha1 ... ok 6 ms
test hmac-md5 ... ok 6 ms
test hmac-sha1 ... ok 6 ms
test blowfish ... ok 7 ms
test rijndael ... ok 8 ms
test sha2 ... ok 7 ms
test des ... ok 6 ms
test 3des ... ok 7 ms
test cast5 ... ok 7 ms
test crypt-des ... ok 27 ms
test crypt-md5 ... ok 59 ms
test crypt-blowfish ... ok 106 ms
test crypt-xdes ... ok 29 ms
test pgp-armor ... ok 9 ms
test pgp-decrypt ... ok 19 ms
test pgp-encrypt ... ok 393 ms
test pgp-compression ... ok 14 ms
test pgp-pubkey-decrypt ... ok 103 ms
test pgp-pubkey-encrypt ... ok 19 ms
test pgp-info ... ok 8 ms
======================
All 22 tests passed.
======================
waiting for server to shut down.... done
server stopped
pgjwt
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 pgjwt ==============
ERROR: required extension "pgcrypto" is not installed
HINT: Use CREATE EXTENSION ... CASCADE to install required extensions too.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pgjwt\"" "contrib_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 "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pgjwt ==============
ERROR: required extension "pgcrypto" is not installed
HINT: Use CREATE EXTENSION ... CASCADE to install required extensions too.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pgjwt\"" "contrib_regression"
waiting for server to shut down.... done
server stopped
pgsentinel
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pgsentinel ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 12 ms
test md5 ... ok 6 ms
test sha1 ... ok 6 ms
test hmac-md5 ... ok 7 ms
test hmac-sha1 ... ok 7 ms
test blowfish ... ok 7 ms
test rijndael ... ok 7 ms
test sha2 ... ok 7 ms
test des ... ok 6 ms
test 3des ... ok 7 ms
test cast5 ... ok 7 ms
test crypt-des ... ok 30 ms
test crypt-md5 ... ok 44 ms
test crypt-blowfish ... ok 121 ms
test crypt-xdes ... ok 40 ms
test pgp-armor ... ok 41 ms
test pgp-decrypt ... ok 62 ms
test pgp-encrypt ... ok 404 ms
test pgp-compression ... ok 16 ms
test pgp-pubkey-decrypt ... ok 91 ms
test pgp-pubkey-encrypt ... ok 18 ms
test pgp-info ... ok 7 ms
======================
All 22 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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgsentinel-test ... ok 9068 ms
=====================
All 1 tests passed.
=====================
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (client-side)...
100000 of 1000000 tuples (10%) done (elapsed 0.08 s, remaining 0.70 s)
200000 of 1000000 tuples (20%) done (elapsed 0.17 s, remaining 0.69 s)
300000 of 1000000 tuples (30%) done (elapsed 0.24 s, remaining 0.57 s)
400000 of 1000000 tuples (40%) done (elapsed 0.34 s, remaining 0.51 s)
500000 of 1000000 tuples (50%) done (elapsed 0.45 s, remaining 0.45 s)
600000 of 1000000 tuples (60%) done (elapsed 0.53 s, remaining 0.35 s)
700000 of 1000000 tuples (70%) done (elapsed 0.65 s, remaining 0.28 s)
800000 of 1000000 tuples (80%) done (elapsed 0.73 s, remaining 0.18 s)
900000 of 1000000 tuples (90%) done (elapsed 0.85 s, remaining 0.09 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.95 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done in 1.38 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 0.97 s, vacuum 0.11 s, primary keys 0.30 s).
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (client-side)...
100000 of 1000000 tuples (10%) done (elapsed 0.06 s, remaining 0.57 s)
200000 of 1000000 tuples (20%) done (elapsed 0.12 s, remaining 0.50 s)
300000 of 1000000 tuples (30%) done (elapsed 0.21 s, remaining 0.49 s)
400000 of 1000000 tuples (40%) done (elapsed 0.30 s, remaining 0.45 s)
500000 of 1000000 tuples (50%) done (elapsed 0.37 s, remaining 0.37 s)
600000 of 1000000 tuples (60%) done (elapsed 0.46 s, remaining 0.31 s)
700000 of 1000000 tuples (70%) done (elapsed 0.53 s, remaining 0.23 s)
800000 of 1000000 tuples (80%) done (elapsed 0.61 s, remaining 0.15 s)
900000 of 1000000 tuples (90%) done (elapsed 0.69 s, remaining 0.08 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.77 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done in 1.20 s (drop tables 0.00 s, create tables 0.01 s, client-side generate 0.80 s, vacuum 0.12 s, primary keys 0.27 s).
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 pgcrypto ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgsentinel-test ... ok 9074 ms
=====================
All 1 tests passed.
=====================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
ERROR: database "contrib_regression" is being accessed by other users
DETAIL: There is 1 other session using the database.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
waiting for server to shut down.... done
server stopped
tds_fdw
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing tds_fdw ==============
ERROR: extension "tds_fdw" is not available
DETAIL: Could not open extension control file "/home/abigalek/pgext-cli-python/pg-15-dist/share/postgresql/extension/tds_fdw.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"tds_fdw\"" "contrib_regression"
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing tds_fdw ==============
ERROR: extension "tds_fdw" is not available
DETAIL: Could not open extension control file "/home/abigalek/pgext-cli-python/pg-15-dist/share/postgresql/extension/tds_fdw.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"tds_fdw\"" "contrib_regression"
waiting for server to shut down.... done
server stopped
timescaledb
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing timescaledb ==============
WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.11.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: Please enable telemetry to help us improve our product by running: ALTER DATABASE "contrib_regression" SET timescaledb.telemetry_level = 'basic';
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 10 ms
test md5 ... ok 7 ms
test sha1 ... ok 7 ms
test hmac-md5 ... ok 7 ms
test hmac-sha1 ... ok 7 ms
test blowfish ... ok 7 ms
test rijndael ... ok 7 ms
test sha2 ... ok 7 ms
test des ... ok 6 ms
test 3des ... ok 7 ms
test cast5 ... ok 6 ms
test crypt-des ... ok 16 ms
test crypt-md5 ... ok 18 ms
test crypt-blowfish ... ok 44 ms
test crypt-xdes ... ok 17 ms
test pgp-armor ... ok 8 ms
test pgp-decrypt ... ok 17 ms
test pgp-encrypt ... ok 431 ms
test pgp-compression ... ok 15 ms
test pgp-pubkey-decrypt ... ok 49 ms
test pgp-pubkey-encrypt ... ok 17 ms
test pgp-info ... ok 8 ms
======================
All 22 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 1151 ms
test alternate_users ... ok 827 ms
test chunk_utils ... ok 888 ms
test index ... ok 1038 ms
test pg_dump_unprivileged ... ok 783 ms
test tablespace ... ok 739 ms
parallel group (21 tests): drop_extension chunks ddl_errors create_chunks ddl-15 broken_tables delete-15 drop_hypertable agg_bookends-15 create_table ddl_extra custom_type baserel_cache cluster-15 create_hypertable cursor-15 chunk_adaptive copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5151 ms
append-15 ... ok 6702 ms
baserel_cache ... ok 5151 ms
broken_tables ... ok 5144 ms
chunk_adaptive ... ok 5164 ms
chunks ... ok 5137 ms
cluster-15 ... ok 5151 ms
constraint-15 ... ok 5238 ms
copy-15 ... ok 5174 ms
create_chunks ... ok 5137 ms
create_hypertable ... ok 5151 ms
create_table ... ok 5150 ms
cursor-15 ... ok 5151 ms
custom_type ... ok 5150 ms
ddl-15 ... ok 5143 ms
ddl_errors ... ok 5136 ms
ddl_extra ... ok 5149 ms
delete-15 ... ok 5146 ms
drop_extension ... FAILED 5128 ms
drop_hypertable ... ok 5146 ms
drop_owned ... ok 5265 ms
parallel group (21 tests): partitioning histogram_test null_exclusion drop_schema information_views drop_rename_hypertable partition extension_scripts misc merge insert_returning dump_meta lateral hash generated_as_identity grant_hypertable insert_single license parallel-15 insert-15 insert_many
drop_rename_hypertable ... ok 6153 ms
drop_schema ... ok 6146 ms
dump_meta ... ok 6186 ms
extension_scripts ... ok 6156 ms
generated_as_identity ... ok 6205 ms
grant_hypertable ... ok 6205 ms
hash ... ok 6197 ms
histogram_test ... ok 6145 ms
information_views ... ok 6150 ms
insert-15 ... ok 6340 ms
insert_many ... ok 7427 ms
insert_returning ... ok 6184 ms
insert_single ... ok 6204 ms
lateral ... ok 6185 ms
license ... ok 6204 ms
merge ... ok 6179 ms
misc ... ok 6179 ms
null_exclusion ... ok 6145 ms
parallel-15 ... ok 6204 ms
partition ... ok 6151 ms
partitioning ... ok 4802 ms
parallel group (21 tests): plan_hypertable_inline-15 tableam reloptions triggers sql_query sort_optimization plain query-15 upsert update-15 timestamp partitionwise-15 size_utils rowsecurity-15 plan_expand_hypertable-15 plan_ordered_append truncate trusted_extension relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7282 ms
pg_join ... ok 9708 ms
plain ... ok 7269 ms
plan_expand_hypertable-15 ... ok 7310 ms
plan_hashagg-15 ... ok 8953 ms
plan_hypertable_inline-15 ... ok 6716 ms
plan_ordered_append ... ok 7727 ms
query-15 ... ok 7275 ms
relocate_extension ... ok 7975 ms
reloptions ... ok 7259 ms
rowsecurity-15 ... ok 7292 ms
size_utils ... ok 7287 ms
sort_optimization ... ok 7263 ms
sql_query ... ok 7262 ms
tableam ... ok 7252 ms
timestamp ... ok 7280 ms
triggers ... ok 7259 ms
truncate ... ok 7816 ms
trusted_extension ... ok 7817 ms
update-15 ... ok 7279 ms
upsert ... ok 7278 ms
parallel group (4 tests): util version vacuum_parallel vacuum
util ... ok 695 ms
vacuum ... ok 705 ms
vacuum_parallel ... ok 704 ms
version ... ok 701 ms
=======================
1 of 73 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
CREATE EXTENSION
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing timescaledb ==============
WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.11.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: Please enable telemetry to help us improve our product by running: ALTER DATABASE "contrib_regression" SET timescaledb.telemetry_level = 'basic';
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 12 ms
test md5 ... ok 7 ms
test sha1 ... ok 7 ms
test hmac-md5 ... ok 7 ms
test hmac-sha1 ... ok 7 ms
test blowfish ... ok 7 ms
test rijndael ... ok 8 ms
test sha2 ... ok 7 ms
test des ... ok 6 ms
test 3des ... ok 7 ms
test cast5 ... ok 7 ms
test crypt-des ... ok 34 ms
test crypt-md5 ... ok 37 ms
test crypt-blowfish ... ok 70 ms
test crypt-xdes ... ok 33 ms
test pgp-armor ... ok 9 ms
test pgp-decrypt ... ok 16 ms
test pgp-encrypt ... ok 396 ms
test pgp-compression ... ok 17 ms
test pgp-pubkey-decrypt ... ok 89 ms
test pgp-pubkey-encrypt ... ok 17 ms
test pgp-info ... ok 9 ms
======================
All 22 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 2422 ms
test alternate_users ... ok 1711 ms
test chunk_utils ... ok 1853 ms
test index ... ok 2227 ms
test pg_dump_unprivileged ... ok 1474 ms
test tablespace ... ok 1532 ms
parallel group (21 tests): chunks custom_type ddl_errors drop_hypertable create_chunks drop_extension cursor-15 baserel_cache broken_tables create_table create_hypertable cluster-15 copy-15 ddl_extra delete-15 agg_bookends-15 ddl-15 append-15 chunk_adaptive constraint-15 drop_owned
agg_bookends-15 ... ok 11186 ms
append-15 ... ok 11188 ms
baserel_cache ... ok 11180 ms
broken_tables ... ok 11180 ms
chunk_adaptive ... ok 11195 ms
chunks ... ok 11169 ms
cluster-15 ... ok 11185 ms
constraint-15 ... ok 11422 ms
copy-15 ... ok 11185 ms
create_chunks ... ok 11178 ms
create_hypertable ... ok 11184 ms
create_table ... ok 11180 ms
cursor-15 ... ok 11179 ms
custom_type ... ok 11174 ms
ddl-15 ... ok 11185 ms
ddl_errors ... ok 11176 ms
ddl_extra ... ok 11184 ms
delete-15 ... ok 11184 ms
drop_extension ... FAILED 11178 ms
drop_hypertable ... ok 11176 ms
drop_owned ... ok 11451 ms
parallel group (21 tests): generated_as_identity hash lateral information_views dump_meta merge insert_returning parallel-15 misc grant_hypertable license partition drop_schema drop_rename_hypertable null_exclusion insert_single partitioning extension_scripts histogram_test insert-15 insert_many
drop_rename_hypertable ... ok 15435 ms
drop_schema ... ok 15435 ms
dump_meta ... ok 15429 ms
extension_scripts ... ok 15436 ms
generated_as_identity ... ok 11375 ms
grant_hypertable ... ok 15433 ms
hash ... ok 15393 ms
histogram_test ... ok 15437 ms
information_views ... ok 15427 ms
insert-15 ... ok 15995 ms
insert_many ... ok 18120 ms
insert_returning ... ok 15428 ms
insert_single ... ok 15434 ms
lateral ... ok 15414 ms
license ... ok 15432 ms
merge ... ok 15427 ms
misc ... ok 15428 ms
null_exclusion ... ok 15434 ms
parallel-15 ... ok 15427 ms
partition ... ok 15432 ms
partitioning ... ok 15434 ms
parallel group (21 tests): plain partitionwise-15 update-15 sql_query timestamp triggers query-15 plan_ordered_append plan_expand_hypertable-15 plan_hashagg-15 plan_hypertable_inline-15 tableam reloptions upsert size_utils sort_optimization rowsecurity-15 pg_join truncate trusted_extension relocate_extension
partitionwise-15 ... ok 19838 ms
pg_join ... ok 20330 ms
plain ... ok 19835 ms
plan_expand_hypertable-15 ... ok 19864 ms
plan_hashagg-15 ... ok 19877 ms
plan_hypertable_inline-15 ... ok 19925 ms
plan_ordered_append ... ok 19863 ms
query-15 ... ok 19862 ms
relocate_extension ... ok 20506 ms
reloptions ... ok 19940 ms
rowsecurity-15 ... ok 19940 ms
size_utils ... ok 19940 ms
sort_optimization ... ok 19940 ms
sql_query ... ok 19860 ms
tableam ... ok 19935 ms
timestamp ... ok 19860 ms
triggers ... ok 19860 ms
truncate ... ok 20474 ms
trusted_extension ... ok 20477 ms
update-15 ... ok 19851 ms
upsert ... ok 19939 ms
parallel group (4 tests): util vacuum_parallel version vacuum
util ... ok 1673 ms
vacuum ... ok 1703 ms
vacuum_parallel ... ok 1700 ms
version ... ok 1703 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".