prefix
Repository:
https://github.com/dimitri/prefix
The functionality provided allows for efficient querying of strings based on prefixes by creating an index on the prefix of a string column, enabling fast lookup and matching of strings that start with a specified sequence of characters.
Information Analysis
| Extensibility Types: | Functions, Types, Index Access Methods |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 1879 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 1879 |
| Lines of Encapsulated Versioning Code: ? | 2 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0.11% |
| PostgreSQL Versions Cased On: ? | 16 |
Compatibility Analysis
| Number of Failed Extensions: | 15 |
| Failure Rate: | 15.3% |
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 prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test install_btree_gin ... FAILED 32 ms
test int2 ... ok 26 ms
test int4 ... ok 37 ms
test int8 ... ok 37 ms
test float4 ... ok 37 ms
test float8 ... ok 37 ms
test money ... ok 38 ms
test oid ... ok 37 ms
test timestamp ... ok 37 ms
test timestamptz ... ok 38 ms
test time ... ok 38 ms
test timetz ... ok 37 ms
test date ... ok 38 ms
test interval ... ok 38 ms
test macaddr ... ok 38 ms
test macaddr8 ... ok 37 ms
test inet ... ok 49 ms
test cidr ... ok 49 ms
test text ... ok 47 ms
test varchar ... ok 49 ms
test char ... ok 36 ms
test bytea ... ok 45 ms
test bit ... ok 38 ms
test varbit ... ok 47 ms
test numeric ... ok 47 ms
test enum ... ok 197 ms
test uuid ... ok 25 ms
test name ... ok 41 ms
test bool ... ok 43 ms
test bpchar ... ok 42 ms
=======================
1 of 30 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gin/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gin/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test install_btree_gin ... FAILED 21 ms
test int2 ... ok 10 ms
test int4 ... ok 9 ms
test int8 ... ok 10 ms
test float4 ... ok 13 ms
test float8 ... ok 9 ms
test money ... ok 9 ms
test oid ... ok 13 ms
test timestamp ... ok 10 ms
test timestamptz ... ok 10 ms
test time ... ok 10 ms
test timetz ... ok 10 ms
test date ... ok 10 ms
test interval ... ok 14 ms
test macaddr ... ok 16 ms
test macaddr8 ... ok 21 ms
test inet ... ok 38 ms
test cidr ... ok 36 ms
test text ... ok 34 ms
test varchar ... ok 36 ms
test char ... ok 29 ms
test bytea ... ok 35 ms
test bit ... ok 29 ms
test varbit ... ok 35 ms
test numeric ... ok 35 ms
test enum ... ok 153 ms
test uuid ... ok 17 ms
test name ... ok 22 ms
test bool ... ok 23 ms
test bpchar ... ok 27 ms
=======================
1 of 30 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gin/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gin/regression.out".
waiting for server to shut down.... done
server stopped
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 prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 49 ms
test int2 ... ok 26 ms
test int4 ... ok 26 ms
test int8 ... ok 30 ms
test float4 ... ok 56 ms
test float8 ... ok 53 ms
test cash ... ok 29 ms
test oid ... ok 20 ms
test timestamp ... ok 22 ms
test timestamptz ... ok 43 ms
test time ... ok 33 ms
test timetz ... ok 173 ms
test date ... ok 51 ms
test interval ... ok 53 ms
test macaddr ... ok 51 ms
test macaddr8 ... ok 49 ms
test inet ... ok 83 ms
test cidr ... ok 56 ms
test text ... ok 80 ms
test varchar ... ok 40 ms
test char ... ok 59 ms
test bytea ... ok 49 ms
test bit ... ok 32 ms
test varbit ... ok 42 ms
test numeric ... ok 90 ms
test uuid ... ok 25 ms
test not_equal ... ok 78 ms
test enum ... ok 36 ms
test bool ... ok 31 ms
=======================
1 of 29 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gist/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test init ... FAILED 33 ms
test int2 ... ok 13 ms
test int4 ... ok 18 ms
test int8 ... ok 41 ms
test float4 ... ok 20 ms
test float8 ... ok 19 ms
test cash ... ok 18 ms
test oid ... ok 17 ms
test timestamp ... ok 19 ms
test timestamptz ... ok 25 ms
test time ... ok 18 ms
test timetz ... ok 72 ms
test date ... ok 42 ms
test interval ... ok 46 ms
test macaddr ... ok 29 ms
test macaddr8 ... ok 28 ms
test inet ... ok 43 ms
test cidr ... ok 21 ms
test text ... ok 31 ms
test varchar ... ok 39 ms
test char ... ok 27 ms
test bytea ... ok 51 ms
test bit ... ok 24 ms
test varbit ... ok 28 ms
test numeric ... ok 51 ms
test uuid ... ok 22 ms
test not_equal ... ok 49 ms
test enum ... ok 45 ms
test bool ... ok 34 ms
=======================
1 of 29 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gist/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/btree_gist/regression.out".
waiting for server to shut down.... done
server stopped
citext
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test create_index_acl ... ok 221 ms
test citext ... FAILED 549 ms
test citext_utf8 ... ok 8 ms
======================
1 of 3 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/citext/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/citext/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test create_index_acl ... ok 131 ms
test citext ... FAILED 241 ms
test citext_utf8 ... ok 13 ms
======================
1 of 3 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/citext/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/citext/regression.out".
waiting for server to shut down.... done
server stopped
cube
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test cube ... FAILED 76 ms
test cube_sci ... ok 5 ms
======================
1 of 2 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/cube/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/cube/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test cube ... FAILED 77 ms
test cube_sci ... ok 5 ms
======================
1 of 2 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/cube/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/cube/regression.out".
waiting for server to shut down.... done
server stopped
earthdistance
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 180 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 prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 148 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
hstore
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test hstore ... FAILED 588 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/hstore/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/hstore/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test hstore ... FAILED 583 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/hstore/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/hstore/regression.out".
waiting for server to shut down.... done
server stopped
intarray
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test _int ... FAILED 1179 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/intarray/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/intarray/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test _int ... FAILED 1166 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/intarray/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/intarray/regression.out".
waiting for server to shut down.... done
server stopped
isn
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test isn ... FAILED 60 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/isn/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/isn/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test isn ... FAILED 59 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/isn/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/isn/regression.out".
waiting for server to shut down.... done
server stopped
ltree
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test ltree ... FAILED 251 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/ltree/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/ltree/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test ltree ... FAILED 201 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/ltree/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/ltree/regression.out".
waiting for server to shut down.... done
server stopped
pg_show_plans
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
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 prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 20 ms
test version ... ok 24 ms
test guc ... ok 23 ms
test pgsm_query_id ... ok 628 ms
test functions ... FAILED 75 ms
test counters ... ok 76 ms
test relations ... ok 202 ms
test database ... ok 453 ms
test error_insert ... ok 88 ms
test application_name ... ok 51 ms
test application_name_unique ... ok 29 ms
test top_query ... ok 29 ms
test cmd_type ... ok 56 ms
test error ... ok 36 ms
test rows ... ok 111 ms
test tags ... ok 52 ms
test user ... ok 93 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 prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 14 ms
test version ... ok 13 ms
test guc ... ok 14 ms
test pgsm_query_id ... ok 352 ms
test functions ... FAILED 62 ms
test counters ... ok 38 ms
test relations ... ok 63 ms
test database ... ok 318 ms
test error_insert ... ok 61 ms
test application_name ... ok 34 ms
test application_name_unique ... ok 29 ms
test top_query ... ok 18 ms
test cmd_type ... ok 47 ms
test error ... ok 48 ms
test rows ... ok 50 ms
test tags ... ok 13 ms
test user ... ok 28 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
pg_trgm
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_trgm ... FAILED 446 ms
test pg_word_trgm ... ok 73 ms
test pg_strict_word_trgm ... ok 57 ms
======================
1 of 3 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/pg_trgm/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/pg_trgm/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_trgm ... FAILED 300 ms
test pg_word_trgm ... ok 38 ms
test pg_strict_word_trgm ... ok 36 ms
======================
1 of 3 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/pg_trgm/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/pg_trgm/regression.out".
waiting for server to shut down.... done
server stopped
pgextwlist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 59 ms
test pgextwlist ... FAILED 63 ms
test errors ... FAILED 8 ms
test crossuser ... ok 48 ms
test hooks ... ok 33 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 28 ms
test pgextwlist ... FAILED 71 ms
test errors ... FAILED 7 ms
test crossuser ... ok 17 ms
test hooks ... ok 8 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
seg
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test security ... ok 24 ms
test seg ... FAILED 33 ms
======================
1 of 2 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/seg/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/seg/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing prefix ==============
CREATE EXTENSION
============== running regression test queries ==============
test security ... ok 32 ms
test seg ... FAILED 59 ms
======================
1 of 2 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/seg/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/seg/regression.out".
waiting for server to shut down.... done
server stopped
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
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 1120 ms
test alternate_users ... ok 815 ms
test chunk_utils ... ok 847 ms
test index ... ok 1032 ms
test pg_dump_unprivileged ... ok 772 ms
test tablespace ... ok 712 ms
parallel group (21 tests): ddl_errors ddl_extra baserel_cache drop_hypertable chunk_adaptive agg_bookends-15 delete-15 create_chunks chunks broken_tables cluster-15 create_table cursor-15 custom_type ddl-15 drop_extension create_hypertable copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5267 ms
append-15 ... ok 6556 ms
baserel_cache ... ok 5261 ms
broken_tables ... ok 5273 ms
chunk_adaptive ... ok 5264 ms
chunks ... ok 5273 ms
cluster-15 ... ok 5273 ms
constraint-15 ... ok 5344 ms
copy-15 ... ok 5288 ms
create_chunks ... ok 5270 ms
create_hypertable ... ok 5286 ms
create_table ... ok 5276 ms
cursor-15 ... ok 5276 ms
custom_type ... ok 5278 ms
ddl-15 ... ok 5280 ms
ddl_errors ... ok 5257 ms
ddl_extra ... ok 5258 ms
delete-15 ... ok 5265 ms
drop_extension ... FAILED 5279 ms
drop_hypertable ... ok 5259 ms
drop_owned ... ok 5378 ms
parallel group (21 tests): partitioning hash insert_returning insert_single histogram_test information_views grant_hypertable license drop_rename_hypertable merge partition lateral null_exclusion generated_as_identity dump_meta parallel-15 extension_scripts drop_schema misc insert-15 insert_many
drop_rename_hypertable ... ok 6290 ms
drop_schema ... ok 6320 ms
dump_meta ... ok 6293 ms
extension_scripts ... ok 6304 ms
generated_as_identity ... ok 6293 ms
grant_hypertable ... ok 6287 ms
hash ... ok 6276 ms
histogram_test ... ok 6286 ms
information_views ... ok 6287 ms
insert-15 ... ok 6474 ms
insert_many ... ok 7591 ms
insert_returning ... ok 6285 ms
insert_single ... ok 6285 ms
lateral ... ok 6292 ms
license ... ok 6288 ms
merge ... ok 6288 ms
misc ... ok 6324 ms
null_exclusion ... ok 6292 ms
parallel-15 ... ok 6296 ms
partition ... ok 6288 ms
partitioning ... ok 4893 ms
parallel group (21 tests): tableam timestamp plain triggers reloptions partitionwise-15 sql_query plan_hypertable_inline-15 sort_optimization update-15 upsert size_utils query-15 rowsecurity-15 plan_expand_hypertable-15 plan_ordered_append truncate trusted_extension relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7303 ms
pg_join ... ok 9851 ms
plain ... FAILED 7294 ms
plan_expand_hypertable-15 ... ok 7331 ms
plan_hashagg-15 ... ok 8991 ms
plan_hypertable_inline-15 ... ok 7309 ms
plan_ordered_append ... ok 7430 ms
query-15 ... ok 7325 ms
relocate_extension ... ok 7971 ms
reloptions ... ok 7294 ms
rowsecurity-15 ... ok 7330 ms
size_utils ... ok 7315 ms
sort_optimization ... ok 7308 ms
sql_query ... ok 7303 ms
tableam ... ok 6753 ms
timestamp ... ok 7291 ms
triggers ... ok 7293 ms
truncate ... ok 7732 ms
trusted_extension ... ok 7733 ms
update-15 ... ok 7308 ms
upsert ... ok 7312 ms
parallel group (4 tests): util version vacuum_parallel vacuum
util ... ok 672 ms
vacuum ... ok 681 ms
vacuum_parallel ... ok 679 ms
version ... ok 678 ms
=======================
2 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
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 1086 ms
test alternate_users ... ok 803 ms
test chunk_utils ... ok 875 ms
test index ... ok 1046 ms
test pg_dump_unprivileged ... ok 752 ms
test tablespace ... ok 756 ms
parallel group (21 tests): custom_type ddl_errors drop_hypertable broken_tables delete-15 cluster-15 chunks ddl_extra cursor-15 agg_bookends-15 create_hypertable drop_extension create_table baserel_cache ddl-15 create_chunks chunk_adaptive copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5229 ms
append-15 ... ok 6683 ms
baserel_cache ... ok 5229 ms
broken_tables ... ok 5223 ms
chunk_adaptive ... ok 5245 ms
chunks ... ok 5223 ms
cluster-15 ... ok 5223 ms
constraint-15 ... ok 5304 ms
copy-15 ... ok 5249 ms
create_chunks ... ok 5230 ms
create_hypertable ... ok 5228 ms
create_table ... ok 5228 ms
cursor-15 ... ok 5224 ms
custom_type ... ok 5218 ms
ddl-15 ... ok 5228 ms
ddl_errors ... ok 5218 ms
ddl_extra ... ok 5222 ms
delete-15 ... ok 5222 ms
drop_extension ... FAILED 5228 ms
drop_hypertable ... ok 5219 ms
drop_owned ... ok 5341 ms
parallel group (21 tests): partitioning license hash grant_hypertable insert_returning partition merge null_exclusion insert_single extension_scripts drop_rename_hypertable generated_as_identity parallel-15 misc dump_meta drop_schema lateral histogram_test information_views insert-15 insert_many
drop_rename_hypertable ... ok 6127 ms
drop_schema ... ok 6159 ms
dump_meta ... ok 6158 ms
extension_scripts ... ok 6127 ms
generated_as_identity ... ok 6133 ms
grant_hypertable ... ok 6115 ms
hash ... ok 6115 ms
histogram_test ... ok 6166 ms
information_views ... ok 6166 ms
insert-15 ... ok 6302 ms
insert_many ... ok 7375 ms
insert_returning ... ok 6115 ms
insert_single ... ok 6125 ms
lateral ... ok 6162 ms
license ... ok 6112 ms
merge ... ok 6124 ms
misc ... ok 6136 ms
null_exclusion ... ok 6124 ms
parallel-15 ... ok 6136 ms
partition ... ok 6123 ms
partitioning ... ok 5107 ms
parallel group (21 tests): plan_hypertable_inline-15 plain upsert update-15 query-15 plan_ordered_append tableam triggers reloptions sort_optimization sql_query partitionwise-15 timestamp size_utils plan_expand_hypertable-15 rowsecurity-15 trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 8313 ms
pg_join ... ok 10634 ms
plain ... FAILED 8299 ms
plan_expand_hypertable-15 ... ok 8314 ms
plan_hashagg-15 ... ok 9437 ms
plan_hypertable_inline-15 ... ok 7700 ms
plan_ordered_append ... ok 8308 ms
query-15 ... ok 8307 ms
relocate_extension ... ok 9248 ms
reloptions ... ok 8308 ms
rowsecurity-15 ... ok 8314 ms
size_utils ... ok 8312 ms
sort_optimization ... ok 8309 ms
sql_query ... ok 8309 ms
tableam ... ok 8307 ms
timestamp ... ok 8311 ms
triggers ... ok 8307 ms
truncate ... ok 8715 ms
trusted_extension ... ok 8587 ms
update-15 ... ok 8305 ms
upsert ... ok 8299 ms
parallel group (4 tests): util version vacuum_parallel vacuum
util ... ok 705 ms
vacuum ... ok 714 ms
vacuum_parallel ... ok 714 ms
version ... ok 711 ms
=======================
2 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".