pg_hint_plan
Repository:
https://github.com/ossc-db/pg_hint_plan
The functionality provides a means to influence the query planner's decision-making process by allowing users to specify hints within SQL comments, which are then used to guide the selection of join methods, join orders, and index usage.
Information Analysis
| Extensibility Types: | Query Processing, Utility Commands |
| System Components: | Custom Configuration Variables |
Duplicate Code Analysis
| Total Lines of Code: ? | 6990 |
| Lines of Duplicate Code: ? | 1532 |
| Percentage of Codebase: ? | 21.92% |
Versioning Analysis
| Total Lines of Code: ? | 6990 |
| Lines of Encapsulated Versioning Code: ? | 0 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0% |
Compatibility Analysis
| Number of Failed Extensions: | 20 |
| Failure Rate: | 20.5% |
Failed Extensions
btree_gin
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1341 ms
test base_plan ... ok 12 ms
test pg_hint_plan ... ok 7409 ms
test ut-init ... FAILED 833 ms
test ut-A ... ok 442 ms
test ut-S ... ok 190 ms
test ut-J ... ok 85 ms
test ut-L ... ok 96 ms
test ut-G ... ok 44 ms
test ut-R ... ok 1064 ms
test ut-fdw ... ok 36 ms
test ut-W ... ok 113 ms
test ut-T ... ok 48 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 137 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test install_btree_gin ... ok 22 ms
test int2 ... ok 10 ms
test int4 ... ok 9 ms
test int8 ... ok 10 ms
test float4 ... ok 12 ms
test float8 ... ok 13 ms
test money ... ok 13 ms
test oid ... ok 12 ms
test timestamp ... ok 18 ms
test timestamptz ... ok 26 ms
test time ... ok 27 ms
test timetz ... ok 27 ms
test date ... ok 27 ms
test interval ... ok 26 ms
test macaddr ... ok 26 ms
test macaddr8 ... ok 26 ms
test inet ... ok 33 ms
test cidr ... ok 35 ms
test text ... ok 35 ms
test varchar ... ok 37 ms
test char ... ok 29 ms
test bytea ... ok 35 ms
test bit ... ok 30 ms
test varbit ... ok 31 ms
test numeric ... ok 33 ms
test enum ... ok 167 ms
test uuid ... ok 25 ms
test name ... ok 21 ms
test bool ... ok 18 ms
test bpchar ... ok 17 ms
======================
All 30 tests passed.
======================
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test install_btree_gin ... ok 34 ms
test int2 ... ok 21 ms
test int4 ... ok 21 ms
test int8 ... ok 29 ms
test float4 ... ok 33 ms
test float8 ... ok 29 ms
test money ... ok 28 ms
test oid ... ok 32 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 38 ms
test time ... ok 38 ms
test timetz ... ok 37 ms
test date ... ok 37 ms
test interval ... ok 37 ms
test macaddr ... ok 38 ms
test macaddr8 ... ok 36 ms
test inet ... ok 48 ms
test cidr ... ok 48 ms
test text ... ok 47 ms
test varchar ... ok 49 ms
test char ... ok 37 ms
test bytea ... ok 48 ms
test bit ... ok 38 ms
test varbit ... ok 45 ms
test numeric ... ok 47 ms
test enum ... ok 207 ms
test uuid ... ok 18 ms
test name ... ok 18 ms
test bool ... ok 18 ms
test bpchar ... ok 19 ms
======================
All 30 tests passed.
======================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gin ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2584 ms
test base_plan ... ok 20 ms
test pg_hint_plan ... ok 7568 ms
test ut-init ... FAILED 778 ms
test ut-A ... ok 453 ms
test ut-S ... ok 192 ms
test ut-J ... ok 87 ms
test ut-L ... ok 95 ms
test ut-G ... ok 31 ms
test ut-R ... ok 447 ms
test ut-fdw ... ok 77 ms
test ut-W ... ok 126 ms
test ut-T ... ok 49 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 81 ms
test oldextversions ... ok 149 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
btree_gist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1347 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7437 ms
test ut-init ... FAILED 831 ms
test ut-A ... ok 379 ms
test ut-S ... ok 194 ms
test ut-J ... ok 133 ms
test ut-L ... ok 94 ms
test ut-G ... ok 31 ms
test ut-R ... ok 444 ms
test ut-fdw ... ok 37 ms
test ut-W ... ok 81 ms
test ut-T ... ok 24 ms
test ut-fini ... ok 21 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 135 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 58 ms
test int2 ... ok 12 ms
test int4 ... ok 11 ms
test int8 ... ok 11 ms
test float4 ... ok 11 ms
test float8 ... ok 12 ms
test cash ... ok 11 ms
test oid ... ok 10 ms
test timestamp ... ok 11 ms
test timestamptz ... ok 15 ms
test time ... ok 13 ms
test timetz ... ok 74 ms
test date ... ok 19 ms
test interval ... ok 12 ms
test macaddr ... ok 11 ms
test macaddr8 ... ok 11 ms
test inet ... ok 21 ms
test cidr ... ok 15 ms
test text ... ok 23 ms
test varchar ... ok 17 ms
test char ... ok 20 ms
test bytea ... ok 45 ms
test bit ... ok 23 ms
test varbit ... ok 27 ms
test numeric ... ok 68 ms
test uuid ... ok 13 ms
test not_equal ... ok 28 ms
test enum ... ok 12 ms
test bool ... ok 14 ms
======================
All 29 tests passed.
======================
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 63 ms
test int2 ... ok 19 ms
test int4 ... ok 20 ms
test int8 ... ok 38 ms
test float4 ... ok 53 ms
test float8 ... ok 51 ms
test cash ... ok 31 ms
test oid ... ok 29 ms
test timestamp ... ok 31 ms
test timestamptz ... ok 40 ms
test time ... ok 31 ms
test timetz ... ok 164 ms
test date ... ok 45 ms
test interval ... ok 55 ms
test macaddr ... ok 52 ms
test macaddr8 ... ok 50 ms
test inet ... ok 85 ms
test cidr ... ok 56 ms
test text ... ok 76 ms
test varchar ... ok 31 ms
test char ... ok 32 ms
test bytea ... ok 40 ms
test bit ... ok 24 ms
test varbit ... ok 30 ms
test numeric ... ok 96 ms
test uuid ... ok 23 ms
test not_equal ... ok 101 ms
test enum ... ok 50 ms
test bool ... ok 43 ms
======================
All 29 tests passed.
======================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gist ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2902 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7607 ms
test ut-init ... FAILED 1451 ms
test ut-A ... ok 651 ms
test ut-S ... ok 223 ms
test ut-J ... ok 126 ms
test ut-L ... ok 96 ms
test ut-G ... ok 49 ms
test ut-R ... ok 498 ms
test ut-fdw ... ok 92 ms
test ut-W ... ok 124 ms
test ut-T ... ok 25 ms
test ut-fini ... ok 33 ms
test hints_anywhere ... ok 26 ms
test plpgsql ... ok 89 ms
test oldextversions ... ok 146 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
citus
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 "contrib_regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
All 169 tests passed.
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
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 citus ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 960 ms
test base_plan ... ok 8 ms
test pg_hint_plan ... FAILED 7268 ms
test ut-init ... ok 535 ms
test ut-A ... FAILED 211 ms
test ut-S ... FAILED 144 ms
test ut-J ... FAILED 91 ms
test ut-L ... FAILED 97 ms
test ut-G ... ok 37 ms
test ut-R ... ok 449 ms
test ut-fdw ... ok 39 ms
test ut-W ... ok 60 ms
test ut-T ... ok 13 ms
test ut-fini ... ok 12 ms
test hints_anywhere ... ok 7 ms
test plpgsql ... FAILED 30 ms
test oldextversions ... ok 55 ms
=======================
6 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
All 169 tests passed.
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 1340 ms
test base_plan ... ok 21 ms
test pg_hint_plan ... ok 7429 ms
test ut-init ... ok 817 ms
test ut-A ... ok 447 ms
test ut-S ... ok 151 ms
test ut-J ... ok 131 ms
test ut-L ... ok 95 ms
test ut-G ... ok 31 ms
test ut-R ... ok 446 ms
test ut-fdw ... ok 77 ms
test ut-W ... ok 124 ms
test ut-T ... ok 37 ms
test ut-fini ... ok 29 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 139 ms
======================
All 17 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_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 146 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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 155 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 1420 ms
test base_plan ... ok 14 ms
test pg_hint_plan ... ok 7455 ms
test ut-init ... ok 791 ms
test ut-A ... ok 401 ms
test ut-S ... ok 210 ms
test ut-J ... ok 90 ms
test ut-L ... ok 101 ms
test ut-G ... ok 43 ms
test ut-R ... ok 780 ms
test ut-fdw ... ok 80 ms
test ut-W ... ok 138 ms
test ut-T ... ok 26 ms
test ut-fini ... ok 19 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 137 ms
======================
All 17 tests passed.
======================
waiting for server to shut down.... done
server stopped
file_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 file_fdw ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1345 ms
test base_plan ... ok 18 ms
test pg_hint_plan ... ok 7450 ms
test ut-init ... ok 849 ms
test ut-A ... ok 420 ms
test ut-S ... ok 188 ms
test ut-J ... ok 87 ms
test ut-L ... ok 94 ms
test ut-G ... ok 31 ms
test ut-R ... ok 445 ms
test ut-fdw ... FAILED 72 ms
test ut-W ... ok 124 ms
test ut-T ... ok 25 ms
test ut-fini ... ok 18 ms
test hints_anywhere ... ok 22 ms
test plpgsql ... ok 82 ms
test oldextversions ... ok 149 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test file_fdw ... FAILED 140 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/file_fdw/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/file_fdw/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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test file_fdw ... FAILED 275 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/file_fdw/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/file_fdw/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 file_fdw ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2837 ms
test base_plan ... ok 14 ms
test pg_hint_plan ... ok 7552 ms
test ut-init ... ok 1267 ms
test ut-A ... ok 537 ms
test ut-S ... ok 205 ms
test ut-J ... ok 105 ms
test ut-L ... ok 99 ms
test ut-G ... ok 32 ms
test ut-R ... ok 633 ms
test ut-fdw ... FAILED 30 ms
test ut-W ... ok 76 ms
test ut-T ... ok 30 ms
test ut-fini ... ok 23 ms
test hints_anywhere ... ok 21 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 140 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
pg_ivm
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_ivm ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1268 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7458 ms
test ut-init ... ok 840 ms
test ut-A ... ok 419 ms
test ut-S ... ok 181 ms
test ut-J ... ok 85 ms
test ut-L ... ok 95 ms
test ut-G ... ok 31 ms
test ut-R ... ok 443 ms
test ut-fdw ... ok 24 ms
test ut-W ... ok 92 ms
test ut-T ... ok 29 ms
test ut-fini ... ok 23 ms
test hints_anywhere ... ok 22 ms
test plpgsql ... ok 54 ms
test oldextversions ... ok 54 ms
======================
All 17 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_stat_statements ==============
ERROR: could not open relation with OID 0
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pg_stat_statements\"" "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 pg_stat_statements ==============
ERROR: could not open relation with OID 0
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pg_stat_statements\"" "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 pg_ivm ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2762 ms
test base_plan ... ok 16 ms
test pg_hint_plan ... ok 7607 ms
test ut-init ... ok 1092 ms
test ut-A ... ok 356 ms
test ut-S ... ok 182 ms
test ut-J ... ok 85 ms
test ut-L ... ok 95 ms
test ut-G ... ok 31 ms
test ut-R ... ok 443 ms
test ut-fdw ... ok 36 ms
test ut-W ... ok 95 ms
test ut-T ... ok 36 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 81 ms
test oldextversions ... ok 145 ms
======================
All 17 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 1402 ms
test base_plan ... ok 12 ms
test pg_hint_plan ... FAILED 7447 ms
test ut-init ... ok 834 ms
test ut-A ... FAILED 340 ms
test ut-S ... FAILED 150 ms
test ut-J ... FAILED 88 ms
test ut-L ... FAILED 93 ms
test ut-G ... FAILED 31 ms
test ut-R ... FAILED 445 ms
test ut-fdw ... FAILED 35 ms
test ut-W ... FAILED 110 ms
test ut-T ... FAILED 23 ms
test ut-fini ... ok 16 ms
test hints_anywhere ... FAILED 8 ms
test plpgsql ... FAILED 46 ms
test oldextversions ... ok 135 ms
========================
12 of 17 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 10 ms
test test1 ... ok 15 ms
test test2 ... ok 17 ms
test test3 ... ok 68 ms
test test4 ... ok 132 ms
test test5 ... ok 16 ms
test test6 ... ok 33 ms
test test7 ... FAILED 19 ms
test test8 ... ok 30 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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 13 ms
test test1 ... ok 20 ms
test test2 ... ok 44 ms
test test3 ... ok 94 ms
test test4 ... ok 254 ms
test test5 ... ok 47 ms
test test6 ... ok 87 ms
test test7 ... ok 25 ms
test test8 ... ok 42 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 2695 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... FAILED 7627 ms
test ut-init ... ok 780 ms
test ut-A ... FAILED 348 ms
test ut-S ... FAILED 215 ms
test ut-J ... FAILED 84 ms
test ut-L ... FAILED 94 ms
test ut-G ... FAILED 34 ms
test ut-R ... FAILED 444 ms
test ut-fdw ... FAILED 39 ms
test ut-W ... FAILED 89 ms
test ut-T ... FAILED 49 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... FAILED 23 ms
test plpgsql ... FAILED 83 ms
test oldextversions ... ok 137 ms
========================
12 of 17 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
pg_queryid
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_queryid ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1451 ms
test base_plan ... ok 14 ms
test pg_hint_plan ... FAILED 57 ms
test ut-init ... FAILED 849 ms
test ut-A ... FAILED 317 ms
test ut-S ... FAILED 201 ms
test ut-J ... ok 89 ms
test ut-L ... ok 94 ms
test ut-G ... ok 31 ms
test ut-R ... ok 446 ms
test ut-fdw ... ok 35 ms
test ut-W ... ok 117 ms
test ut-T ... FAILED 6 ms
test ut-fini ... ok 14 ms
test hints_anywhere ... ok 6 ms
test plpgsql ... FAILED 57 ms
test oldextversions ... ok 141 ms
=======================
6 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 21 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_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 "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_repack ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1333 ms
test base_plan ... ok 13 ms
test pg_hint_plan ... ok 7435 ms
test ut-init ... ok 842 ms
test ut-A ... ok 419 ms
test ut-S ... ok 196 ms
test ut-J ... ok 85 ms
test ut-L ... ok 95 ms
test ut-G ... ok 31 ms
test ut-R ... ok 447 ms
test ut-fdw ... ok 78 ms
test ut-W ... ok 119 ms
test ut-T ... ok 38 ms
test ut-fini ... ok 34 ms
test hints_anywhere ... ok 25 ms
test plpgsql ... ok 77 ms
test oldextversions ... ok 139 ms
======================
All 17 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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test init-extension ... ok 23 ms
test repack-setup ... ok 244 ms
test repack-run ... FAILED 1069 ms
test error-on-invalid-idx ... FAILED 902 ms
test after-schema ... ok 65 ms
test repack-check ... ok 2560 ms
test nosuper ... ok 114 ms
test tablespace ... ok 1126 ms
test get_order_by ... ok 647 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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test init-extension ... ok 37 ms
test repack-setup ... ok 543 ms
test repack-run ... FAILED 1529 ms
test error-on-invalid-idx ... FAILED 1315 ms
test after-schema ... ok 66 ms
test repack-check ... ok 4081 ms
test nosuper ... ok 250 ms
test tablespace ... ok 1891 ms
test get_order_by ... ok 964 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 "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_repack ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2732 ms
test base_plan ... ok 20 ms
test pg_hint_plan ... ok 7591 ms
test ut-init ... ok 1251 ms
test ut-A ... ok 559 ms
test ut-S ... ok 228 ms
test ut-J ... ok 135 ms
test ut-L ... ok 97 ms
test ut-G ... ok 48 ms
test ut-R ... ok 1055 ms
test ut-fdw ... ok 47 ms
test ut-W ... ok 114 ms
test ut-T ... ok 23 ms
test ut-fini ... ok 15 ms
test hints_anywhere ... ok 7 ms
test plpgsql ... ok 53 ms
test oldextversions ... ok 127 ms
======================
All 17 tests passed.
======================
waiting for server to shut down.... done
server stopped
pg_stat_kcache
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_stat_kcache ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1351 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7442 ms
test ut-init ... FAILED 829 ms
test ut-A ... ok 399 ms
test ut-S ... ok 160 ms
test ut-J ... ok 86 ms
test ut-L ... ok 96 ms
test ut-G ... ok 31 ms
test ut-R ... ok 445 ms
test ut-fdw ... ok 78 ms
test ut-W ... ok 116 ms
test ut-T ... ok 35 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 137 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgsk ... FAILED 34 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_kcache/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_kcache/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_monitor
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_monitor ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1321 ms
test base_plan ... ok 12 ms
test pg_hint_plan ... ok 7442 ms
test ut-init ... ok 824 ms
test ut-A ... ok 407 ms
test ut-S ... ok 195 ms
test ut-J ... ok 87 ms
test ut-L ... ok 96 ms
test ut-G ... ok 34 ms
test ut-R ... ok 441 ms
test ut-fdw ... ok 76 ms
test ut-W ... ok 124 ms
test ut-T ... ok 24 ms
test ut-fini ... ok 18 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 83 ms
test oldextversions ... ok 143 ms
======================
All 17 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_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 20 ms
test version ... ok 17 ms
test guc ... ok 18 ms
test pgsm_query_id ... ok 251 ms
test functions ... FAILED 46 ms
test counters ... ok 48 ms
test relations ... ok 102 ms
test database ... ok 271 ms
test error_insert ... ok 35 ms
test application_name ... ok 46 ms
test application_name_unique ... ok 19 ms
test top_query ... ok 17 ms
test cmd_type ... ok 24 ms
test error ... ok 15 ms
test rows ... ok 52 ms
test tags ... ok 45 ms
test user ... ok 49 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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 20 ms
test version ... ok 27 ms
test guc ... ok 34 ms
test pgsm_query_id ... FAILED 620 ms
test functions ... FAILED 76 ms
test counters ... ok 96 ms
test relations ... ok 152 ms
test database ... ok 454 ms
test error_insert ... ok 91 ms
test application_name ... ok 51 ms
test application_name_unique ... ok 31 ms
test top_query ... FAILED 40 ms
test cmd_type ... FAILED 57 ms
test error ... ok 36 ms
test rows ... ok 81 ms
test tags ... ok 40 ms
test user ... FAILED 82 ms
=======================
5 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 2530 ms
test base_plan ... ok 14 ms
test pg_hint_plan ... ok 7545 ms
test ut-init ... ok 774 ms
test ut-A ... ok 391 ms
test ut-S ... ok 173 ms
test ut-J ... ok 109 ms
test ut-L ... ok 97 ms
test ut-G ... ok 30 ms
test ut-R ... ok 448 ms
test ut-fdw ... ok 39 ms
test ut-W ... ok 85 ms
test ut-T ... ok 49 ms
test ut-fini ... ok 29 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 80 ms
test oldextversions ... ok 138 ms
======================
All 17 tests passed.
======================
waiting for server to shut down.... done
server stopped
pg_stat_statements
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
============== running regression test queries ==============
test init ... ok 1301 ms
test base_plan ... ok 12 ms
test pg_hint_plan ... ok 7428 ms
test ut-init ... FAILED 823 ms
test ut-A ... ok 345 ms
test ut-S ... ok 144 ms
test ut-J ... ok 85 ms
test ut-L ... ok 94 ms
test ut-G ... ok 30 ms
test ut-R ... ok 442 ms
test ut-fdw ... ok 78 ms
test ut-W ... ok 119 ms
test ut-T ... ok 23 ms
test ut-fini ... ok 14 ms
test hints_anywhere ... ok 7 ms
test plpgsql ... ok 63 ms
test oldextversions ... ok 140 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_stat_statements ... ok 181 ms
test oldextversions ... ok 38 ms
=====================
All 2 tests passed.
=====================
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_stat_statements ... ok 327 ms
test oldextversions ... ok 96 ms
=====================
All 2 tests passed.
=====================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2786 ms
test base_plan ... ok 16 ms
test pg_hint_plan ... ok 7537 ms
test ut-init ... FAILED 1295 ms
test ut-A ... ok 574 ms
test ut-S ... ok 194 ms
test ut-J ... ok 133 ms
test ut-L ... ok 97 ms
test ut-G ... ok 37 ms
test ut-R ... ok 458 ms
test ut-fdw ... ok 45 ms
test ut-W ... ok 83 ms
test ut-T ... ok 29 ms
test ut-fini ... ok 16 ms
test hints_anywhere ... ok 7 ms
test plpgsql ... ok 48 ms
test oldextversions ... ok 138 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
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 1322 ms
test base_plan ... ok 12 ms
test pg_hint_plan ... FAILED 7443 ms
test ut-init ... ok 817 ms
test ut-A ... ok 341 ms
test ut-S ... ok 198 ms
test ut-J ... ok 86 ms
test ut-L ... ok 95 ms
test ut-G ... ok 41 ms
test ut-R ... ok 1049 ms
test ut-fdw ... ok 33 ms
test ut-W ... ok 80 ms
test ut-T ... ok 24 ms
test ut-fini ... ok 17 ms
test hints_anywhere ... ok 11 ms
test plpgsql ... ok 79 ms
test oldextversions ... ok 138 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_tle_api ... ok 212 ms
test pg_tle_management ... FAILED 181 ms
test pg_tle_injection ... FAILED 55 ms
test pg_tle_perms ... FAILED 112 ms
test pg_tle_requires ... ok 32 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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_tle_api ... ok 400 ms
test pg_tle_management ... ok 392 ms
test pg_tle_injection ... ok 133 ms
test pg_tle_perms ... ok 257 ms
test pg_tle_requires ... ok 63 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 2795 ms
test base_plan ... ok 19 ms
test pg_hint_plan ... FAILED 7591 ms
test ut-init ... ok 1335 ms
test ut-A ... ok 577 ms
test ut-S ... ok 215 ms
test ut-J ... ok 137 ms
test ut-L ... ok 95 ms
test ut-G ... ok 31 ms
test ut-R ... ok 445 ms
test ut-fdw ... ok 36 ms
test ut-W ... ok 110 ms
test ut-T ... ok 25 ms
test ut-fini ... ok 24 ms
test hints_anywhere ... ok 25 ms
test plpgsql ... ok 94 ms
test oldextversions ... ok 149 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
pgaudit
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 pgaudit ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1389 ms
test base_plan ... ok 14 ms
test pg_hint_plan ... ok 7415 ms
test ut-init ... ok 822 ms
test ut-A ... ok 419 ms
test ut-S ... ok 192 ms
test ut-J ... ok 85 ms
test ut-L ... ok 95 ms
test ut-G ... ok 30 ms
test ut-R ... ok 446 ms
test ut-fdw ... ok 32 ms
test ut-W ... ok 80 ms
test ut-T ... ok 35 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 23 ms
test plpgsql ... ok 82 ms
test oldextversions ... ok 141 ms
======================
All 17 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_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgaudit ... FAILED 1168 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgaudit-1.7.0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgaudit-1.7.0/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgaudit ... FAILED 2095 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgaudit-1.7.0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgaudit-1.7.0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pgaudit ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2449 ms
test base_plan ... ok 37 ms
test pg_hint_plan ... ok 7587 ms
test ut-init ... ok 780 ms
test ut-A ... ok 368 ms
test ut-S ... ok 205 ms
test ut-J ... ok 87 ms
test ut-L ... ok 96 ms
test ut-G ... ok 31 ms
test ut-R ... ok 471 ms
test ut-fdw ... ok 34 ms
test ut-W ... ok 83 ms
test ut-T ... ok 29 ms
test ut-fini ... ok 17 ms
test hints_anywhere ... ok 12 ms
test plpgsql ... ok 72 ms
test oldextversions ... ok 140 ms
======================
All 17 tests passed.
======================
waiting for server to shut down.... done
server stopped
pgextwlist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "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 1369 ms
test base_plan ... ok 10 ms
test pg_hint_plan ... ok 7431 ms
test ut-init ... ok 844 ms
test ut-A ... ok 384 ms
test ut-S ... ok 159 ms
test ut-J ... ok 84 ms
test ut-L ... ok 94 ms
test ut-G ... ok 30 ms
test ut-R ... ok 446 ms
test ut-fdw ... ok 35 ms
test ut-W ... ok 109 ms
test ut-T ... ok 23 ms
test ut-fini ... ok 16 ms
test hints_anywhere ... ok 10 ms
test plpgsql ... ok 63 ms
test oldextversions ... ok 136 ms
======================
All 17 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_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 29 ms
test pgextwlist ... FAILED 59 ms
test errors ... FAILED 7 ms
test crossuser ... ok 30 ms
test hooks ... ok 12 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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 44 ms
test pgextwlist ... FAILED 60 ms
test errors ... FAILED 8 ms
test crossuser ... ok 32 ms
test hooks ... ok 26 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 1356 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7465 ms
test ut-init ... ok 771 ms
test ut-A ... ok 380 ms
test ut-S ... ok 165 ms
test ut-J ... ok 133 ms
test ut-L ... ok 95 ms
test ut-G ... ok 41 ms
test ut-R ... ok 1009 ms
test ut-fdw ... ok 84 ms
test ut-W ... ok 118 ms
test ut-T ... ok 25 ms
test ut-fini ... ok 18 ms
test hints_anywhere ... ok 21 ms
test plpgsql ... ok 83 ms
test oldextversions ... ok 141 ms
======================
All 17 tests passed.
======================
waiting for server to shut down.... done
server stopped
pgsentinel
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pgsentinel ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1349 ms
test base_plan ... ok 15 ms
test pg_hint_plan ... ok 7434 ms
test ut-init ... FAILED 826 ms
test ut-A ... ok 361 ms
test ut-S ... ok 158 ms
test ut-J ... ok 85 ms
test ut-L ... ok 95 ms
test ut-G ... ok 41 ms
test ut-R ... ok 1034 ms
test ut-fdw ... ok 36 ms
test ut-W ... ok 82 ms
test ut-T ... ok 25 ms
test ut-fini ... ok 18 ms
test hints_anywhere ... ok 21 ms
test plpgsql ... ok 76 ms
test oldextversions ... ok 130 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
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
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test pgsentinel-test ... FAILED 9069 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgsentinel/src/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgsentinel/src/regression.out".
(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
plprofiler
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
postgres_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 postgres_fdw ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 1441 ms
test base_plan ... ok 13 ms
test pg_hint_plan ... ok 7439 ms
test ut-init ... ok 804 ms
test ut-A ... ok 393 ms
test ut-S ... ok 171 ms
test ut-J ... ok 86 ms
test ut-L ... ok 94 ms
test ut-G ... ok 31 ms
test ut-R ... ok 439 ms
test ut-fdw ... ok 33 ms
test ut-W ... ok 110 ms
test ut-T ... ok 25 ms
test ut-fini ... ok 17 ms
test hints_anywhere ... ok 17 ms
test plpgsql ... ok 79 ms
test oldextversions ... ok 135 ms
======================
All 17 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_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test postgres_fdw ... FAILED 5701 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/postgres_fdw/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/postgres_fdw/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 pg_stat_statements ==============
CREATE EXTENSION
============== installing pg_hint_plan ==============
CREATE EXTENSION
============== running regression test queries ==============
test postgres_fdw ... FAILED 8301 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/postgres_fdw/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/postgres_fdw/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 postgres_fdw ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... ok 2425 ms
test base_plan ... ok 20 ms
test pg_hint_plan ... ok 7586 ms
test ut-init ... ok 822 ms
test ut-A ... ok 412 ms
test ut-S ... ok 199 ms
test ut-J ... ok 132 ms
test ut-L ... ok 95 ms
test ut-G ... ok 30 ms
test ut-R ... ok 475 ms
test ut-fdw ... ok 38 ms
test ut-W ... ok 110 ms
test ut-T ... ok 36 ms
test ut-fini ... ok 30 ms
test hints_anywhere ... ok 25 ms
test plpgsql ... ok 82 ms
test oldextversions ... ok 151 ms
======================
All 17 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 "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 ... FAILED 942 ms
test base_plan ... FAILED 10 ms
test pg_hint_plan ... FAILED 7270 ms
test ut-init ... ok 564 ms
test ut-A ... FAILED 212 ms
test ut-S ... FAILED 143 ms
test ut-J ... FAILED 89 ms
test ut-L ... FAILED 98 ms
test ut-G ... FAILED 34 ms
test ut-R ... FAILED 435 ms
test ut-fdw ... FAILED 35 ms
test ut-W ... FAILED 64 ms
test ut-T ... FAILED 25 ms
test ut-fini ... ok 17 ms
test hints_anywhere ... ok 8 ms
test plpgsql ... ok 46 ms
test oldextversions ... ok 82 ms
========================
12 of 17 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
CREATE EXTENSION
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 1137 ms
test alternate_users ... ok 811 ms
test chunk_utils ... ok 883 ms
test index ... FAILED 1022 ms
test pg_dump_unprivileged ... ok 742 ms
test tablespace ... ok 757 ms
parallel group (21 tests): ddl_extra drop_hypertable create_table ddl-15 delete-15 baserel_cache create_hypertable drop_extension custom_type agg_bookends-15 chunks ddl_errors cursor-15 broken_tables create_chunks cluster-15 copy-15 chunk_adaptive constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5267 ms
append-15 ... ok 6595 ms
baserel_cache ... ok 5254 ms
broken_tables ... ok 5277 ms
chunk_adaptive ... ok 5302 ms
chunks ... ok 5272 ms
cluster-15 ... ok 5288 ms
constraint-15 ... ok 5400 ms
copy-15 ... ok 5300 ms
create_chunks ... ok 5279 ms
create_hypertable ... ok 5260 ms
create_table ... ok 5250 ms
cursor-15 ... ok 5276 ms
custom_type ... ok 5264 ms
ddl-15 ... ok 5250 ms
ddl_errors ... ok 5274 ms
ddl_extra ... ok 5245 ms
delete-15 ... ok 5249 ms
drop_extension ... FAILED 5260 ms
drop_hypertable ... FAILED 5245 ms
drop_owned ... ok 5414 ms
parallel group (21 tests): null_exclusion hash histogram_test generated_as_identity license lateral partition drop_schema merge parallel-15 partitioning insert_single misc information_views insert_returning grant_hypertable extension_scripts drop_rename_hypertable dump_meta insert-15 insert_many
drop_rename_hypertable ... ok 6236 ms
drop_schema ... ok 6219 ms
dump_meta ... ok 6238 ms
extension_scripts ... ok 6234 ms
generated_as_identity ... ok 6202 ms
grant_hypertable ... ok 6232 ms
hash ... ok 6201 ms
histogram_test ... ok 6202 ms
information_views ... ok 6225 ms
insert-15 ... ok 6436 ms
insert_many ... FAILED 7431 ms
insert_returning ... ok 6225 ms
insert_single ... ok 6224 ms
lateral ... ok 6216 ms
license ... ok 6202 ms
merge ... ok 6217 ms
misc ... ok 6224 ms
null_exclusion ... ok 4972 ms
parallel-15 ... ok 6217 ms
partition ... FAILED 6216 ms
partitioning ... ok 6217 ms
parallel group (21 tests): plan_hypertable_inline-15 sort_optimization reloptions timestamp triggers tableam plain upsert sql_query partitionwise-15 update-15 size_utils rowsecurity-15 query-15 plan_expand_hypertable-15 plan_ordered_append truncate relocate_extension trusted_extension plan_hashagg-15 pg_join
partitionwise-15 ... FAILED 7609 ms
pg_join ... ok 9990 ms
plain ... ok 7588 ms
plan_expand_hypertable-15 ... ok 7614 ms
plan_hashagg-15 ... ok 9180 ms
plan_hypertable_inline-15 ... ok 6779 ms
plan_ordered_append ... ok 7629 ms
query-15 ... ok 7610 ms
relocate_extension ... ok 7878 ms
reloptions ... ok 7584 ms
rowsecurity-15 ... ok 7609 ms
size_utils ... ok 7609 ms
sort_optimization ... ok 7584 ms
sql_query ... FAILED 7600 ms
tableam ... ok 7586 ms
timestamp ... ok 7586 ms
triggers ... ok 7586 ms
truncate ... ok 7851 ms
trusted_extension ... ok 7879 ms
update-15 ... ok 7607 ms
upsert ... ok 7598 ms
parallel group (4 tests): version util vacuum vacuum_parallel
util ... ok 705 ms
vacuum ... ok 707 ms
vacuum_parallel ... ok 708 ms
version ... ok 698 ms
=======================
7 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
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 ... FAILED 2092 ms
test base_plan ... FAILED 11 ms
test pg_hint_plan ... FAILED 7347 ms
test ut-init ... ok 516 ms
test ut-A ... FAILED 214 ms
test ut-S ... FAILED 146 ms
test ut-J ... FAILED 90 ms
test ut-L ... FAILED 98 ms
test ut-G ... FAILED 34 ms
test ut-R ... FAILED 435 ms
test ut-fdw ... FAILED 30 ms
test ut-W ... FAILED 59 ms
test ut-T ... FAILED 29 ms
test ut-fini ... ok 16 ms
test hints_anywhere ... ok 9 ms
test plpgsql ... ok 33 ms
test oldextversions ... ok 63 ms
========================
12 of 17 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/pg_hint_plan-REL15_1_5_0/regression.out".
waiting for server to shut down.... done
server stopped
TESTS
IGNORES
SKIPS
(using postmaster on localhost, port 5432)
============== dropping database "single" ==============
SET
DROP DATABASE
============== dropping role "super_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user_2" ==============
SET
DROP ROLE
============== dropping role "cluster_super_user" ==============
SET
DROP ROLE
============== dropping role "test_role_1" ==============
SET
DROP ROLE
============== dropping role "test_role_2" ==============
SET
DROP ROLE
============== dropping role "test_role_3" ==============
SET
DROP ROLE
============== dropping role "test_role_4" ==============
SET
DROP ROLE
============== dropping role "test_role_read_only" ==============
SET
DROP ROLE
============== creating database "single" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== creating role "super_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user_2" ==============
CREATE ROLE
GRANT
============== creating role "cluster_super_user" ==============
CREATE ROLE
GRANT
============== creating role "test_role_1" ==============
CREATE ROLE
GRANT
============== creating role "test_role_2" ==============
CREATE ROLE
GRANT
============== creating role "test_role_3" ==============
CREATE ROLE
GRANT
============== creating role "test_role_4" ==============
CREATE ROLE
GRANT
============== creating role "test_role_read_only" ==============
CREATE ROLE
GRANT
============== running regression test queries ==============
test alter ... ok 2238 ms
test alternate_users ... ok 1616 ms
test chunk_utils ... ok 1732 ms
test index ... FAILED 2084 ms
test pg_dump_unprivileged ... ok 1374 ms
test tablespace ... ok 1456 ms
parallel group (21 tests): create_table custom_type drop_hypertable agg_bookends-15 ddl_extra delete-15 broken_tables baserel_cache cursor-15 create_chunks ddl_errors drop_extension ddl-15 append-15 chunks cluster-15 create_hypertable chunk_adaptive copy-15 constraint-15 drop_owned
agg_bookends-15 ... ok 10802 ms
append-15 ... ok 10808 ms
baserel_cache ... ok 10804 ms
broken_tables ... ok 10803 ms
chunk_adaptive ... ok 10824 ms
chunks ... ok 10807 ms
cluster-15 ... ok 10809 ms
constraint-15 ... ok 11027 ms
copy-15 ... ok 10834 ms
create_chunks ... ok 10804 ms
create_hypertable ... ok 10816 ms
create_table ... ok 10790 ms
cursor-15 ... ok 10804 ms
custom_type ... ok 10797 ms
ddl-15 ... ok 10806 ms
ddl_errors ... ok 10804 ms
ddl_extra ... ok 10801 ms
delete-15 ... ok 10801 ms
drop_extension ... FAILED 10806 ms
drop_hypertable ... FAILED 10799 ms
drop_owned ... ok 11047 ms
parallel group (21 tests): null_exclusion insert_returning dump_meta generated_as_identity grant_hypertable information_views license misc partitioning extension_scripts histogram_test merge drop_schema insert_single parallel-15 drop_rename_hypertable hash lateral partition insert-15 insert_many
drop_rename_hypertable ... ok 14757 ms
drop_schema ... ok 14707 ms
dump_meta ... ok 14691 ms
extension_scripts ... ok 14705 ms
generated_as_identity ... ok 14703 ms
grant_hypertable ... ok 14704 ms
hash ... ok 14756 ms
histogram_test ... ok 14705 ms
information_views ... ok 14703 ms
insert-15 ... ok 15113 ms
insert_many ... FAILED 16975 ms
insert_returning ... ok 14672 ms
insert_single ... ok 14706 ms
lateral ... ok 14756 ms
license ... ok 14703 ms
merge ... ok 14704 ms
misc ... ok 14702 ms
null_exclusion ... ok 11379 ms
parallel-15 ... ok 14705 ms
partition ... FAILED 14755 ms
partitioning ... ok 14702 ms
parallel group (21 tests): reloptions plan_hypertable_inline-15 plain plan_expand_hypertable-15 sql_query update-15 tableam upsert triggers size_utils timestamp sort_optimization partitionwise-15 rowsecurity-15 plan_hashagg-15 query-15 plan_ordered_append pg_join trusted_extension relocate_extension truncate
partitionwise-15 ... FAILED 19249 ms
pg_join ... ok 19507 ms
plain ... ok 19228 ms
plan_expand_hypertable-15 ... ok 19244 ms
plan_hashagg-15 ... ok 19249 ms
plan_hypertable_inline-15 ... ok 19213 ms
plan_ordered_append ... ok 19249 ms
query-15 ... ok 19249 ms
relocate_extension ... ok 19521 ms
reloptions ... ok 19204 ms
rowsecurity-15 ... ok 19248 ms
size_utils ... ok 19247 ms
sort_optimization ... ok 19247 ms
sql_query ... FAILED 19243 ms
tableam ... ok 19243 ms
timestamp ... ok 19247 ms
triggers ... ok 19245 ms
truncate ... ok 19520 ms
trusted_extension ... ok 19517 ms
update-15 ... ok 19242 ms
upsert ... ok 19244 ms
parallel group (4 tests): util version vacuum vacuum_parallel
util ... ok 1545 ms
vacuum ... ok 1572 ms
vacuum_parallel ... ok 1572 ms
version ... ok 1568 ms
=======================
7 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".