pg_bigm

Repository: https://github.com/pgbigm/pg_bigm

The big integer and numeric mathematical operations library provides support for arbitrary-precision arithmetic, enabling calculations involving very large integers and high-precision decimal numbers to be performed accurately within a database environment.

Information Analysis

Extensibility Types:	Functions, Index Access Methods
System Components:	Custom Configuration Variables

Duplicate Code Analysis

Total Lines of Code: ?	1265
Lines of Duplicate Code: ?	0
Percentage of Codebase: ?	0%

Versioning Analysis

Total Lines of Code: ?	1265
Lines of Encapsulated Versioning Code: ?	87
Percentage of Encapsulated Versioning Code in Codebase: ?	6.88%
PostgreSQL Versions Cased On: ?	9,12,13

Compatibility Analysis

Number of Failed Extensions:	21
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 "regression"         ==============
SET
DROP DATABASE
============== creating database "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 pg_bigm                      ... ok          169 ms
test pg_bigm_ja                   ... ok           43 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test install_btree_gin            ... FAILED       42 ms
test int2                         ... ok           29 ms
test int4                         ... ok           35 ms
test int8                         ... ok           37 ms
test float4                       ... ok           36 ms
test float8                       ... ok           36 ms
test money                        ... ok           36 ms
test oid                          ... ok           36 ms
test timestamp                    ... ok           37 ms
test timestamptz                  ... ok           36 ms
test time                         ... ok           37 ms
test timetz                       ... ok           36 ms
test date                         ... ok           37 ms
test interval                     ... ok           36 ms
test macaddr                      ... ok           36 ms
test macaddr8                     ... ok           36 ms
test inet                         ... ok           46 ms
test cidr                         ... ok           47 ms
test text                         ... ok           46 ms
test varchar                      ... ok           51 ms
test char                         ... ok           35 ms
test bytea                        ... ok           48 ms
test bit                          ... ok           40 ms
test varbit                       ... ok           50 ms
test numeric                      ... ok           46 ms
test enum                         ... ok          302 ms
test uuid                         ... ok           25 ms
test name                         ... ok           33 ms
test bool                         ... ok           42 ms
test bpchar                       ... ok           40 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test install_btree_gin            ... FAILED       24 ms
test int2                         ... ok           10 ms
test int4                         ... ok           23 ms
test int8                         ... ok           33 ms
test float4                       ... ok           33 ms
test float8                       ... ok           32 ms
test money                        ... ok           32 ms
test oid                          ... ok           34 ms
test timestamp                    ... ok           31 ms
test timestamptz                  ... ok           34 ms
test time                         ... ok           31 ms
test timetz                       ... ok           34 ms
test date                         ... ok           31 ms
test interval                     ... ok           33 ms
test macaddr                      ... ok           32 ms
test macaddr8                     ... ok           33 ms
test inet                         ... ok           44 ms
test cidr                         ... ok           42 ms
test text                         ... ok           41 ms
test varchar                      ... ok           43 ms
test char                         ... ok           31 ms
test bytea                        ... ok           39 ms
test bit                          ... ok           36 ms
test varbit                       ... ok           43 ms
test numeric                      ... ok           42 ms
test enum                         ... ok          204 ms
test uuid                         ... ok           22 ms
test name                         ... ok           36 ms
test bool                         ... ok           39 ms
test bpchar                       ... ok           36 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".

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gin                   ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          138 ms
test pg_bigm_ja                   ... ok           38 ms

=====================
 All 2 tests passed. 
=====================

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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gist                  ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          164 ms
test pg_bigm_ja                   ... ok           56 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test init                         ... FAILED       41 ms
test int2                         ... ok           18 ms
test int4                         ... ok           18 ms
test int8                         ... ok           18 ms
test float4                       ... ok           19 ms
test float8                       ... ok           19 ms
test cash                         ... ok           20 ms
test oid                          ... ok           25 ms
test timestamp                    ... ok           36 ms
test timestamptz                  ... ok           56 ms
test time                         ... ok           44 ms
test timetz                       ... ok          180 ms
test date                         ... ok           49 ms
test interval                     ... ok           52 ms
test macaddr                      ... ok           54 ms
test macaddr8                     ... ok           49 ms
test inet                         ... ok           63 ms
test cidr                         ... ok           54 ms
test text                         ... ok           79 ms
test varchar                      ... ok           36 ms
test char                         ... ok           51 ms
test bytea                        ... ok           75 ms
test bit                          ... ok           51 ms
test varbit                       ... ok           66 ms
test numeric                      ... ok           92 ms
test uuid                         ... ok           21 ms
test not_equal                    ... ok           70 ms
test enum                         ... ok           51 ms
test bool                         ... ok          143 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test init                         ... FAILED       72 ms
test int2                         ... ok           16 ms
test int4                         ... ok           32 ms
test int8                         ... ok           35 ms
test float4                       ... ok           34 ms
test float8                       ... ok           45 ms
test cash                         ... ok           49 ms
test oid                          ... ok           45 ms
test timestamp                    ... ok           37 ms
test timestamptz                  ... ok           45 ms
test time                         ... ok           33 ms
test timetz                       ... ok          133 ms
test date                         ... ok           47 ms
test interval                     ... ok           52 ms
test macaddr                      ... ok           48 ms
test macaddr8                     ... ok           47 ms
test inet                         ... ok           57 ms
test cidr                         ... ok           38 ms
test text                         ... ok           58 ms
test varchar                      ... ok           42 ms
test char                         ... ok           27 ms
test bytea                        ... ok           43 ms
test bit                          ... ok           28 ms
test varbit                       ... ok           39 ms
test numeric                      ... ok           76 ms
test uuid                         ... ok           21 ms
test not_equal                    ... ok           81 ms
test enum                         ... ok           45 ms
test bool                         ... ok           39 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".

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing btree_gist                  ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          115 ms
test pg_bigm_ja                   ... ok          158 ms

=====================
 All 2 tests passed. 
=====================

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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing citext                      ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          191 ms
test pg_bigm_ja                   ... ok           43 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test create_index_acl             ... ok          327 ms
test citext                       ... FAILED      641 ms
test citext_utf8                  ... ok           26 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test create_index_acl             ... ok          146 ms
test citext                       ... FAILED      398 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".

(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 citext                      ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          148 ms
test pg_bigm_ja                   ... ok           37 ms

=====================
 All 2 tests passed. 
=====================

waiting for server to shut down.... done
server stopped

cube

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube                        ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          188 ms
test pg_bigm_ja                   ... ok           47 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test cube                         ... FAILED       97 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test cube                         ... FAILED       95 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".

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube                        ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          125 ms
test pg_bigm_ja                   ... ok           36 ms

=====================
 All 2 tests passed. 
=====================

waiting for server to shut down.... done
server stopped

earthdistance

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube                        ==============
CREATE EXTENSION
============== installing earthdistance               ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          151 ms
test pg_bigm_ja                   ... ok           43 ms

=====================
 All 2 tests passed. 
=====================

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test earthdistance                ... FAILED      178 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test earthdistance                ... FAILED      164 ms

======================
 1 of 1 tests failed. 
======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing cube                        ==============
CREATE EXTENSION
============== installing earthdistance               ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           78 ms
test pg_bigm_ja                   ... ok           47 ms

=====================
 All 2 tests passed. 
=====================

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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing hstore                      ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          122 ms
test pg_bigm_ja                   ... ok           32 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test hstore                       ... FAILED      665 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test hstore                       ... FAILED      653 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".

(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 hstore                      ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           97 ms
test pg_bigm_ja                   ... ok           33 ms

=====================
 All 2 tests passed. 
=====================

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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing intarray                    ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          155 ms
test pg_bigm_ja                   ... ok           47 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test _int                         ... FAILED     1430 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test _int                         ... FAILED     1424 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".

(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 intarray                    ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          148 ms
test pg_bigm_ja                   ... ok           44 ms

=====================
 All 2 tests passed. 
=====================

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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing isn                         ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          128 ms
test pg_bigm_ja                   ... ok           95 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test isn                          ... FAILED       73 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test isn                          ... FAILED       70 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".

(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 isn                         ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          142 ms
test pg_bigm_ja                   ... ok           94 ms

=====================
 All 2 tests passed. 
=====================

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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing ltree                       ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           96 ms
test pg_bigm_ja                   ... ok           33 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test ltree                        ... 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/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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test ltree                        ... FAILED      204 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".

(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 ltree                       ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           79 ms
test pg_bigm_ja                   ... ok           32 ms

=====================
 All 2 tests passed. 
=====================

waiting for server to shut down.... done
server stopped

pg_cron

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_cron                     ==============
ERROR:  can only create extension in database postgres
DETAIL:  Jobs must be scheduled from the database configured in cron.database_name, since the pg_cron background worker reads job descriptions from this database.
HINT:  Add cron.database_name = 'regression' in postgresql.conf to use the current database.
CONTEXT:  PL/pgSQL function inline_code_block line 4 at RAISE
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pg_cron\"" "regression"
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_cron-test                 ... ok          874 ms

=====================
 All 1 tests passed. 
=====================

waiting for server to shut down.... done
server stopped

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_cron-test                 ... ok          729 ms

=====================
 All 1 tests passed. 
=====================

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_cron                     ==============
ERROR:  can only create extension in database postgres
DETAIL:  Jobs must be scheduled from the database configured in cron.database_name, since the pg_cron background worker reads job descriptions from this database.
HINT:  Add cron.database_name = 'regression' in postgresql.conf to use the current database.
CONTEXT:  PL/pgSQL function inline_code_block line 4 at RAISE
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pg_cron\"" "regression"
waiting for server to shut down.... done
server stopped

pg_qualstats

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_qualstats                ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           99 ms
test pg_bigm_ja                   ... ok           42 ms

=====================
 All 2 tests passed. 
=====================

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_qualstats                 ... FAILED      113 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_qualstats/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_qualstats/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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_qualstats                 ... FAILED       84 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_qualstats/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_qualstats/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_qualstats                ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           73 ms
test pg_bigm_ja                   ... ok           33 ms

=====================
 All 2 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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_query_rewrite            ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          171 ms
test pg_bigm_ja                   ... ok           42 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test test0                        ... ok           16 ms
test test1                        ... ok           38 ms
test test2                        ... ok           48 ms
test test3                        ... ok           86 ms
test test4                        ... ok          230 ms
test test5                        ... ok           21 ms
test test6                        ... ok           40 ms
test test7                        ... FAILED       14 ms
test test8                        ... ok           38 ms

======================
 1 of 9 tests failed. 
======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_query_rewrite/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_query_rewrite/regression.out".

waiting for server to shut down.... done
server stopped

pg_queryid

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_statements          ==============
CREATE EXTENSION
============== installing pg_queryid                  ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          133 ms
test pg_bigm_ja                   ... ok           40 ms

=====================
 All 2 tests passed. 
=====================

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_queryid                   ... FAILED       71 ms

======================
 1 of 1 tests failed. 
======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.out".

waiting for server to shut down.... done
server stopped

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?

pg_stat_kcache

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?

pg_stat_monitor

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_monitor             ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          158 ms
test pg_bigm_ja                   ... ok           45 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test basic                        ... ok           23 ms
test version                      ... ok           21 ms
test guc                          ... ok           23 ms
test pgsm_query_id                ... ok          702 ms
test functions                    ... FAILED       75 ms
test counters                     ... ok           72 ms
test relations                    ... ok          187 ms
test database                     ... ok          482 ms
test error_insert                 ... ok           91 ms
test application_name             ... ok           50 ms
test application_name_unique      ... ok           39 ms
test top_query                    ... ok           46 ms
test cmd_type                     ... ok           72 ms
test error                        ... ok           56 ms
test rows                         ... ok           67 ms
test tags                         ... ok           29 ms
test user                         ... ok           90 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test basic                        ... ok           16 ms
test version                      ... ok           12 ms
test guc                          ... ok           13 ms
test pgsm_query_id                ... ok          411 ms
test functions                    ... FAILED       43 ms
test counters                     ... ok           40 ms
test relations                    ... ok           59 ms
test database                     ... ok          284 ms
test error_insert                 ... ok           35 ms
test application_name             ... ok           41 ms
test application_name_unique      ... ok           16 ms
test top_query                    ... ok           16 ms
test cmd_type                     ... ok           24 ms
test error                        ... ok           17 ms
test rows                         ... ok           66 ms
test tags                         ... ok           29 ms
test user                         ... ok           34 ms

=======================
 1 of 17 tests failed. 
=======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_stat_monitor             ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           97 ms
test pg_bigm_ja                   ... ok           33 ms

=====================
 All 2 tests passed. 
=====================

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 "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_trgm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          169 ms
test pg_bigm_ja                   ... ok           42 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_trgm                      ... FAILED      516 ms
test pg_word_trgm                 ... ok           58 ms
test pg_strict_word_trgm          ... ok           56 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_trgm                      ... FAILED      308 ms
test pg_word_trgm                 ... ok           38 ms
test pg_strict_word_trgm          ... ok           38 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".

(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_trgm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           68 ms
test pg_bigm_ja                   ... ok           76 ms

=====================
 All 2 tests passed. 
=====================

waiting for server to shut down.... done
server stopped

pgextwlist

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries        ==============
test pg_bigm                      ... ok          169 ms
test pg_bigm_ja                   ... ok           42 ms

=====================
 All 2 tests passed. 
=====================

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test setup                        ... ok           61 ms
test pgextwlist                   ... FAILED       64 ms
test errors                       ... FAILED       10 ms
test crossuser                    ... ok           47 ms
test hooks                        ... ok           32 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test setup                        ... ok           32 ms
test pgextwlist                   ... FAILED       78 ms
test errors                       ... FAILED        8 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".

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries        ==============
test pg_bigm                      ... ok           80 ms
test pg_bigm_ja                   ... ok           35 ms

=====================
 All 2 tests passed. 
=====================

waiting for server to shut down.... done
server stopped

pgtt

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pgtt                        ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          134 ms
test pg_bigm_ja                   ... ok           33 ms

=====================
 All 2 tests passed. 
=====================

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test 00_init                      ... ok           60 ms
test 01_oncommitdelete            ... ok           66 ms
test 02_oncommitpreserve          ... ok           51 ms
test 03_createontruncate          ... ok           74 ms
test 04_rename                    ... ok          110 ms
test 05_useindex                  ... ok          102 ms
test 06_createas                  ... ok           45 ms
test 07_createlike                ... ok           81 ms
test 08_plplgsql                  ... FAILED       65 ms
test 09_transaction               ... ok           69 ms
test 10_foreignkey                ... ok           33 ms
test 11_after_error               ... ok           65 ms
test 12_droptable                 ... ok           37 ms

=======================
 1 of 13 tests failed. 
=======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgtt-2.10/regression.out".

waiting for server to shut down.... done
server stopped

seg

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing seg                         ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          146 ms
test pg_bigm_ja                   ... ok           36 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_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test security                     ... ok           29 ms
test seg                          ... FAILED       49 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 pg_bigm                     ==============
CREATE EXTENSION
============== running regression test queries        ==============
test security                     ... ok           41 ms
test seg                          ... FAILED       93 ms

======================
 1 of 2 tests failed. 
======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/seg/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/seg/regression.out".

(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing seg                         ==============
CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           75 ms
test pg_bigm_ja                   ... ok           34 ms

=====================
 All 2 tests passed. 
=====================

waiting for server to shut down.... done
server stopped

tds_fdw

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing tds_fdw                     ==============
ERROR:  extension "tds_fdw" is not available
DETAIL:  Could not open extension control file "/home/abigalek/pgext-cli-python/pg-15-dist/share/postgresql/extension/tds_fdw.control": No such file or directory.
HINT:  The extension must first be installed on the system where PostgreSQL is running.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"tds_fdw\"" "regression"
waiting for server to shut down.... done
server stopped

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing tds_fdw                     ==============
ERROR:  extension "tds_fdw" is not available
DETAIL:  Could not open extension control file "/home/abigalek/pgext-cli-python/pg-15-dist/share/postgresql/extension/tds_fdw.control": No such file or directory.
HINT:  The extension must first be installed on the system where PostgreSQL is running.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"tds_fdw\"" "regression"
waiting for server to shut down.... done
server stopped

timescaledb

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing timescaledb                 ==============
WARNING:  
WELCOME TO
 _____ _                               _     ____________  
|_   _(_)                             | |    |  _  \ ___ \ 
  | |  _ _ __ ___   ___  ___  ___ __ _| | ___| | | | |_/ / 
  | | | |  _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \ 
  | | | | | | | | |  __/\__ \ (_| (_| | |  __/ |/ /| |_/ /
  |_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
               Running version 2.11.1
For more information on TimescaleDB, please visit the following links:

 1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
 2. API reference documentation: https://docs.timescale.com/api/latest
 3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts

Note: Please enable telemetry to help us improve our product by running: ALTER DATABASE "regression" SET timescaledb.telemetry_level = 'basic';

CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok           67 ms
test pg_bigm_ja                   ... ok           35 ms

=====================
 All 2 tests passed. 
=====================

CREATE EXTENSION
waiting for server to shut down.... done
server stopped
TESTS 
IGNORES 
SKIPS 
(using postmaster on localhost, port 5432)
============== dropping database "single"             ==============
SET
DROP DATABASE
============== dropping role "super_user"             ==============
SET
DROP ROLE
============== dropping role "default_perm_user"      ==============
SET
DROP ROLE
============== dropping role "default_perm_user_2"    ==============
SET
DROP ROLE
============== dropping role "cluster_super_user"     ==============
SET
DROP ROLE
============== dropping role "test_role_1"            ==============
SET
DROP ROLE
============== dropping role "test_role_2"            ==============
SET
DROP ROLE
============== dropping role "test_role_3"            ==============
SET
DROP ROLE
============== dropping role "test_role_4"            ==============
SET
DROP ROLE
============== dropping role "test_role_read_only"    ==============
SET
DROP ROLE
============== creating database "single"             ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== creating role "super_user"             ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user"      ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user_2"    ==============
CREATE ROLE
GRANT
============== creating role "cluster_super_user"     ==============
CREATE ROLE
GRANT
============== creating role "test_role_1"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_2"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_3"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_4"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_read_only"    ==============
CREATE ROLE
GRANT
============== running regression test queries        ==============
test alter                        ... ok         1113 ms
test alternate_users              ... ok          800 ms
test chunk_utils                  ... ok          883 ms
test index                        ... ok         1011 ms
test pg_dump_unprivileged         ... ok          760 ms
test tablespace                   ... ok          725 ms
parallel group (21 tests):  ddl_errors broken_tables drop_hypertable baserel_cache cluster-15 create_chunks chunks create_hypertable cursor-15 delete-15 create_table ddl-15 custom_type agg_bookends-15 ddl_extra drop_extension chunk_adaptive copy-15 constraint-15 drop_owned append-15
     agg_bookends-15              ... ok         5224 ms
     append-15                    ... ok         6585 ms
     baserel_cache                ... ok         5207 ms
     broken_tables                ... ok         5205 ms
     chunk_adaptive               ... ok         5226 ms
     chunks                       ... ok         5219 ms
     cluster-15                   ... ok         5216 ms
     constraint-15                ... ok         5299 ms
     copy-15                      ... ok         5245 ms
     create_chunks                ... ok         5216 ms
     create_hypertable            ... ok         5219 ms
     create_table                 ... ok         5219 ms
     cursor-15                    ... ok         5219 ms
     custom_type                  ... ok         5220 ms
     ddl-15                       ... ok         5219 ms
     ddl_errors                   ... ok         5202 ms
     ddl_extra                    ... ok         5222 ms
     delete-15                    ... ok         5218 ms
     drop_extension               ... FAILED     5223 ms
     drop_hypertable              ... ok         5204 ms
     drop_owned                   ... ok         5345 ms
parallel group (21 tests):  drop_schema partitioning lateral drop_rename_hypertable null_exclusion license hash merge partition extension_scripts misc parallel-15 insert_single generated_as_identity histogram_test insert_returning grant_hypertable information_views dump_meta insert-15 insert_many
     drop_rename_hypertable       ... ok         6154 ms
     drop_schema                  ... ok         4662 ms
     dump_meta                    ... ok         6205 ms
     extension_scripts            ... ok         6160 ms
     generated_as_identity        ... ok         6194 ms
     grant_hypertable             ... ok         6204 ms
     hash                         ... ok         6158 ms
     histogram_test               ... ok         6195 ms
     information_views            ... ok         6204 ms
     insert-15                    ... ok         6391 ms
     insert_many                  ... ok         7514 ms
     insert_returning             ... ok         6200 ms
     insert_single                ... ok         6169 ms
     lateral                      ... ok         6152 ms
     license                      ... ok         6155 ms
     merge                        ... ok         6159 ms
     misc                         ... ok         6163 ms
     null_exclusion               ... ok         6153 ms
     parallel-15                  ... ok         6167 ms
     partition                    ... ok         6158 ms
     partitioning                 ... ok         6145 ms
parallel group (21 tests):  plan_hypertable_inline-15 tableam partitionwise-15 plain reloptions update-15 triggers query-15 size_utils sql_query sort_optimization timestamp upsert rowsecurity-15 plan_expand_hypertable-15 plan_ordered_append trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
     partitionwise-15             ... ok         7382 ms
     pg_join                      ... ok         9834 ms
     plain                        ... ok         7382 ms
     plan_expand_hypertable-15    ... ok         7395 ms
     plan_hashagg-15              ... ok         8923 ms
     plan_hypertable_inline-15    ... ok         6834 ms
     plan_ordered_append          ... ok         7407 ms
     query-15                     ... ok         7384 ms
     relocate_extension           ... ok         8082 ms
     reloptions                   ... ok         7381 ms
     rowsecurity-15               ... ok         7394 ms
     size_utils                   ... ok         7388 ms
     sort_optimization            ... ok         7389 ms
     sql_query                    ... ok         7388 ms
     tableam                      ... ok         7375 ms
     timestamp                    ... ok         7389 ms
     triggers                     ... ok         7383 ms
     truncate                     ... ok         7927 ms
     trusted_extension            ... ok         7804 ms
     update-15                    ... ok         7381 ms
     upsert                       ... ok         7389 ms
parallel group (4 tests):  version util vacuum_parallel vacuum
     util                         ... ok          708 ms
     vacuum                       ... ok          711 ms
     vacuum_parallel              ... ok          711 ms
     version                      ... ok          700 ms

=======================
 1 of 73 tests failed. 
=======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".

The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start

waiting for server to start.... done
server started
CREATE EXTENSION
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
SET
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing timescaledb                 ==============
WARNING:  
WELCOME TO
 _____ _                               _     ____________  
|_   _(_)                             | |    |  _  \ ___ \ 
  | |  _ _ __ ___   ___  ___  ___ __ _| | ___| | | | |_/ / 
  | | | |  _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \ 
  | | | | | | | | |  __/\__ \ (_| (_| | |  __/ |/ /| |_/ /
  |_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
               Running version 2.11.1
For more information on TimescaleDB, please visit the following links:

 1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
 2. API reference documentation: https://docs.timescale.com/api/latest
 3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts

Note: Please enable telemetry to help us improve our product by running: ALTER DATABASE "regression" SET timescaledb.telemetry_level = 'basic';

CREATE EXTENSION
============== running regression test queries        ==============
test pg_bigm                      ... ok          107 ms
test pg_bigm_ja                   ... ok           39 ms

=====================
 All 2 tests passed. 
=====================

waiting for server to shut down.... done
server stopped
TESTS 
IGNORES 
SKIPS 
(using postmaster on localhost, port 5432)
============== dropping database "single"             ==============
SET
DROP DATABASE
============== dropping role "super_user"             ==============
SET
DROP ROLE
============== dropping role "default_perm_user"      ==============
SET
DROP ROLE
============== dropping role "default_perm_user_2"    ==============
SET
DROP ROLE
============== dropping role "cluster_super_user"     ==============
SET
DROP ROLE
============== dropping role "test_role_1"            ==============
SET
DROP ROLE
============== dropping role "test_role_2"            ==============
SET
DROP ROLE
============== dropping role "test_role_3"            ==============
SET
DROP ROLE
============== dropping role "test_role_4"            ==============
SET
DROP ROLE
============== dropping role "test_role_read_only"    ==============
SET
DROP ROLE
============== creating database "single"             ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== creating role "super_user"             ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user"      ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user_2"    ==============
CREATE ROLE
GRANT
============== creating role "cluster_super_user"     ==============
CREATE ROLE
GRANT
============== creating role "test_role_1"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_2"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_3"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_4"            ==============
CREATE ROLE
GRANT
============== creating role "test_role_read_only"    ==============
CREATE ROLE
GRANT
============== running regression test queries        ==============
test alter                        ... ok         1415 ms
test alternate_users              ... ok          948 ms
test chunk_utils                  ... ok         1052 ms
test index                        ... ok         1210 ms
test pg_dump_unprivileged         ... ok          966 ms
test tablespace                   ... ok          889 ms
parallel group (21 tests):  broken_tables baserel_cache create_hypertable delete-15 drop_extension ddl_errors cursor-15 agg_bookends-15 cluster-15 create_table ddl_extra create_chunks custom_type drop_hypertable chunks ddl-15 chunk_adaptive copy-15 constraint-15 drop_owned append-15
     agg_bookends-15              ... ok         7260 ms
     append-15                    ... ok         8325 ms
     baserel_cache                ... ok         7236 ms
     broken_tables                ... ok         7234 ms
     chunk_adaptive               ... ok         7277 ms
     chunks                       ... ok         7267 ms
     cluster-15                   ... ok         7260 ms
     constraint-15                ... ok         7401 ms
     copy-15                      ... ok         7285 ms
     create_chunks                ... ok         7260 ms
     create_hypertable            ... ok         7236 ms
     create_table                 ... ok         7259 ms
     cursor-15                    ... ok         7252 ms
     custom_type                  ... ok         7260 ms
     ddl-15                       ... ok         7266 ms
     ddl_errors                   ... ok         7249 ms
     ddl_extra                    ... ok         7259 ms
     delete-15                    ... ok         7240 ms
     drop_extension               ... FAILED     7247 ms
     drop_hypertable              ... ok         7265 ms
     drop_owned                   ... ok         7422 ms
parallel group (21 tests):  partitioning grant_hypertable merge histogram_test misc null_exclusion information_views drop_schema lateral license insert_returning partition generated_as_identity dump_meta drop_rename_hypertable hash extension_scripts parallel-15 insert_single insert-15 insert_many
     drop_rename_hypertable       ... ok         6037 ms
     drop_schema                  ... ok         5990 ms
     dump_meta                    ... ok         6036 ms
     extension_scripts            ... ok         6041 ms
     generated_as_identity        ... ok         6036 ms
     grant_hypertable             ... ok         5987 ms
     hash                         ... ok         6037 ms
     histogram_test               ... ok         5989 ms
     information_views            ... ok         5989 ms
     insert-15                    ... ok         6173 ms
     insert_many                  ... ok         7171 ms
     insert_returning             ... ok         6030 ms
     insert_single                ... ok         6044 ms
     lateral                      ... ok         6014 ms
     license                      ... ok         6024 ms
     merge                        ... ok         5988 ms
     misc                         ... ok         5988 ms
     null_exclusion               ... ok         5988 ms
     parallel-15                  ... ok         6042 ms
     partition                    ... ok         6033 ms
     partitioning                 ... ok         4779 ms
parallel group (21 tests):  sort_optimization reloptions upsert plain timestamp tableam partitionwise-15 update-15 size_utils triggers query-15 sql_query plan_expand_hypertable-15 plan_hypertable_inline-15 rowsecurity-15 plan_ordered_append truncate relocate_extension trusted_extension plan_hashagg-15 pg_join
     partitionwise-15             ... ok         8502 ms
     pg_join                      ... ok        10322 ms
     plain                        ... ok         8497 ms
     plan_expand_hypertable-15    ... ok         8531 ms
     plan_hashagg-15              ... ok         9029 ms
     plan_hypertable_inline-15    ... ok         8531 ms
     plan_ordered_append          ... ok         8534 ms
     query-15                     ... ok         8522 ms
     relocate_extension           ... ok         8640 ms
     reloptions                   ... ok         8475 ms
     rowsecurity-15               ... ok         8533 ms
     size_utils                   ... ok         8509 ms
     sort_optimization            ... ok         8471 ms
     sql_query                    ... ok         8530 ms
     tableam                      ... ok         8500 ms
     timestamp                    ... ok         8500 ms
     triggers                     ... ok         8509 ms
     truncate                     ... ok         8622 ms
     trusted_extension            ... ok         8643 ms
     update-15                    ... ok         8505 ms
     upsert                       ... ok         8495 ms
parallel group (4 tests):  version util vacuum_parallel vacuum
     util                         ... ok          742 ms
     vacuum                       ... ok          745 ms
     vacuum_parallel              ... ok          744 ms
     version                      ... ok          735 ms

=======================
 1 of 73 tests failed. 
=======================

The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".