fuzzystrmatch
The fuzzy string matching functions provide measures of similarity between strings, including Levenshtein distance, Jaro-Winkler distance, and Soundex codes, to facilitate approximate matching and comparison of textual data.
Information Analysis
| Extensibility Types: | Functions |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 2230 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 2230 |
| Lines of Encapsulated Versioning Code: ? | 0 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0% |
Compatibility Analysis
| Number of Failed Extensions: | 9 |
| Failure Rate: | 7.9% |
Failed Extensions
earthdistance
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "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 fuzzystrmatch ... ok 10 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 206 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 207 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 fuzzystrmatch ... ok 10 ms
=====================
All 1 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_cron-test ... ok 815 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_cron-test ... ok 857 ms
=====================
All 1 tests passed.
=====================
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_cron ==============
ERROR: can only create extension in database postgres
DETAIL: Jobs must be scheduled from the database configured in cron.database_name, since the pg_cron background worker reads job descriptions from this database.
HINT: Add cron.database_name = 'regression' in postgresql.conf to use the current database.
CONTEXT: PL/pgSQL function inline_code_block line 4 at RAISE
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"pg_cron\"" "regression"
waiting for server to shut down.... done
server stopped
pg_query_rewrite
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_query_rewrite ==============
CREATE EXTENSION
============== running regression test queries ==============
test fuzzystrmatch ... ok 10 ms
=====================
All 1 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 13 ms
test test1 ... ok 18 ms
test test2 ... ok 26 ms
test test3 ... ok 75 ms
test test4 ... ok 274 ms
test test5 ... ok 34 ms
test test6 ... ok 71 ms
test test7 ... FAILED 18 ms
test test8 ... ok 32 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 fuzzystrmatch ... ok 11 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 fuzzystrmatch ==============
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 fuzzystrmatch ... ok 18 ms
=====================
All 1 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 19 ms
test version ... ok 18 ms
test guc ... ok 20 ms
test pgsm_query_id ... ok 705 ms
test functions ... FAILED 61 ms
test counters ... ok 96 ms
test relations ... ok 161 ms
test database ... ok 519 ms
test error_insert ... ok 87 ms
test application_name ... ok 39 ms
test application_name_unique ... ok 42 ms
test top_query ... ok 51 ms
test cmd_type ... ok 84 ms
test error ... ok 53 ms
test rows ... ok 75 ms
test tags ... ok 31 ms
test user ... ok 78 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 27 ms
test version ... ok 43 ms
test guc ... ok 25 ms
test pgsm_query_id ... ok 695 ms
test functions ... FAILED 70 ms
test counters ... ok 74 ms
test relations ... ok 199 ms
test database ... ok 476 ms
test error_insert ... ok 90 ms
test application_name ... ok 54 ms
test application_name_unique ... ok 40 ms
test top_query ... ok 60 ms
test cmd_type ... ok 73 ms
test error ... ok 48 ms
test rows ... ok 78 ms
test tags ... ok 44 ms
test user ... ok 85 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 fuzzystrmatch ... ok 12 ms
=====================
All 1 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 fuzzystrmatch ... ok 12 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 64 ms
test pgextwlist ... FAILED 91 ms
test errors ... FAILED 9 ms
test crossuser ... ok 36 ms
test hooks ... ok 17 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 fuzzystrmatch ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 26 ms
test pgextwlist ... FAILED 37 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 fuzzystrmatch ... ok 22 ms
=====================
All 1 tests passed.
=====================
waiting for server to shut down.... done
server stopped
tds_fdw
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing tds_fdw ==============
ERROR: extension "tds_fdw" is not available
DETAIL: Could not open extension control file "/home/abigalek/pgext-cli-python/pg-15-dist/share/postgresql/extension/tds_fdw.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"tds_fdw\"" "regression"
waiting for server to shut down.... done
server stopped
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 fuzzystrmatch ... ok 11 ms
=====================
All 1 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 2503 ms
test alternate_users ... ok 1682 ms
test chunk_utils ... ok 1856 ms
test index ... ok 2207 ms
test pg_dump_unprivileged ... ok 1505 ms
test tablespace ... ok 1538 ms
parallel group (21 tests): custom_type broken_tables ddl_extra delete-15 ddl-15 chunks cluster-15 drop_hypertable create_chunks create_table baserel_cache agg_bookends-15 ddl_errors cursor-15 drop_extension append-15 chunk_adaptive create_hypertable copy-15 constraint-15 drop_owned
agg_bookends-15 ... ok 11795 ms
append-15 ... ok 11808 ms
baserel_cache ... ok 11779 ms
broken_tables ... ok 11762 ms
chunk_adaptive ... ok 11808 ms
chunks ... ok 11767 ms
cluster-15 ... ok 11767 ms
constraint-15 ... ok 12028 ms
copy-15 ... ok 11815 ms
create_chunks ... ok 11767 ms
create_hypertable ... ok 11807 ms
create_table ... ok 11768 ms
cursor-15 ... ok 11807 ms
custom_type ... ok 11756 ms
ddl-15 ... ok 11764 ms
ddl_errors ... ok 11806 ms
ddl_extra ... ok 11762 ms
delete-15 ... ok 11763 ms
drop_extension ... FAILED 11806 ms
drop_hypertable ... ok 11766 ms
drop_owned ... ok 12057 ms
parallel group (21 tests): misc null_exclusion hash insert_returning grant_hypertable information_views drop_rename_hypertable lateral drop_schema insert_single partitioning generated_as_identity histogram_test license extension_scripts dump_meta merge parallel-15 partition insert-15 insert_many
drop_rename_hypertable ... ok 15479 ms
drop_schema ... ok 15479 ms
dump_meta ... ok 15547 ms
extension_scripts ... ok 15487 ms
generated_as_identity ... ok 15487 ms
grant_hypertable ... ok 15477 ms
hash ... ok 15464 ms
histogram_test ... ok 15487 ms
information_views ... ok 15478 ms
insert-15 ... ok 16013 ms
insert_many ... ok 18124 ms
insert_returning ... ok 15464 ms
insert_single ... ok 15478 ms
lateral ... ok 15478 ms
license ... ok 15486 ms
merge ... ok 15545 ms
misc ... ok 11180 ms
null_exclusion ... ok 15439 ms
parallel-15 ... ok 15545 ms
partition ... ok 15545 ms
partitioning ... ok 15477 ms
parallel group (21 tests): reloptions tableam plan_hypertable_inline-15 sql_query upsert rowsecurity-15 query-15 sort_optimization timestamp update-15 triggers plan_expand_hypertable-15 partitionwise-15 size_utils plain plan_hashagg-15 plan_ordered_append pg_join trusted_extension truncate relocate_extension
partitionwise-15 ... ok 19529 ms
pg_join ... ok 19655 ms
plain ... ok 19530 ms
plan_expand_hypertable-15 ... ok 19520 ms
plan_hashagg-15 ... ok 19529 ms
plan_hypertable_inline-15 ... ok 19402 ms
plan_ordered_append ... ok 19529 ms
query-15 ... ok 19402 ms
relocate_extension ... ok 20659 ms
reloptions ... ok 18735 ms
rowsecurity-15 ... ok 19402 ms
size_utils ... ok 19529 ms
sort_optimization ... ok 19402 ms
sql_query ... ok 19401 ms
tableam ... ok 19400 ms
timestamp ... ok 19503 ms
triggers ... ok 19519 ms
truncate ... ok 19988 ms
trusted_extension ... ok 19988 ms
update-15 ... ok 19518 ms
upsert ... ok 19401 ms
parallel group (4 tests): util version vacuum vacuum_parallel
util ... ok 1587 ms
vacuum ... ok 1616 ms
vacuum_parallel ... ok 1616 ms
version ... ok 1612 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 fuzzystrmatch ... ok 11 ms
=====================
All 1 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 2411 ms
test alternate_users ... ok 1688 ms
test chunk_utils ... ok 1842 ms
test index ... ok 2198 ms
test pg_dump_unprivileged ... ok 1480 ms
test tablespace ... ok 1524 ms
parallel group (21 tests): cursor-15 agg_bookends-15 ddl_errors baserel_cache custom_type delete-15 drop_hypertable create_table ddl_extra create_chunks drop_extension chunks cluster-15 broken_tables create_hypertable chunk_adaptive ddl-15 append-15 copy-15 constraint-15 drop_owned
agg_bookends-15 ... ok 11279 ms
append-15 ... ok 11293 ms
baserel_cache ... ok 11284 ms
broken_tables ... ok 11291 ms
chunk_adaptive ... ok 11291 ms
chunks ... ok 11291 ms
cluster-15 ... ok 11291 ms
constraint-15 ... ok 11544 ms
copy-15 ... ok 11312 ms
create_chunks ... ok 11291 ms
create_hypertable ... ok 11291 ms
create_table ... ok 11285 ms
cursor-15 ... ok 11278 ms
custom_type ... ok 11283 ms
ddl-15 ... ok 11291 ms
ddl_errors ... ok 11278 ms
ddl_extra ... ok 11290 ms
delete-15 ... ok 11284 ms
drop_extension ... FAILED 11290 ms
drop_hypertable ... ok 11284 ms
drop_owned ... ok 11566 ms
parallel group (21 tests): license misc partitioning merge drop_rename_hypertable grant_hypertable information_views generated_as_identity insert_returning histogram_test drop_schema insert_single extension_scripts hash null_exclusion lateral dump_meta parallel-15 partition insert-15 insert_many
drop_rename_hypertable ... ok 15583 ms
drop_schema ... ok 15587 ms
dump_meta ... ok 15672 ms
extension_scripts ... ok 15587 ms
generated_as_identity ... ok 15583 ms
grant_hypertable ... ok 15583 ms
hash ... ok 15629 ms
histogram_test ... ok 15586 ms
information_views ... ok 15583 ms
insert-15 ... ok 16082 ms
insert_many ... ok 18205 ms
insert_returning ... ok 15583 ms
insert_single ... ok 15586 ms
lateral ... ok 15657 ms
license ... ok 11305 ms
merge ... ok 15581 ms
misc ... ok 15550 ms
null_exclusion ... ok 15628 ms
parallel-15 ... ok 15671 ms
partition ... ok 15671 ms
partitioning ... ok 15568 ms
parallel group (21 tests): reloptions sql_query triggers plain upsert size_utils partitionwise-15 tableam query-15 plan_hashagg-15 plan_expand_hypertable-15 sort_optimization plan_ordered_append timestamp update-15 plan_hypertable_inline-15 rowsecurity-15 pg_join trusted_extension relocate_extension truncate
partitionwise-15 ... ok 19739 ms
pg_join ... ok 20052 ms
plain ... ok 19737 ms
plan_expand_hypertable-15 ... ok 19772 ms
plan_hashagg-15 ... ok 19771 ms
plan_hypertable_inline-15 ... ok 19853 ms
plan_ordered_append ... ok 19853 ms
query-15 ... ok 19771 ms
relocate_extension ... ok 20080 ms
reloptions ... ok 19735 ms
rowsecurity-15 ... ok 19853 ms
size_utils ... ok 19738 ms
sort_optimization ... ok 19852 ms
sql_query ... ok 19735 ms
tableam ... ok 19738 ms
timestamp ... ok 19852 ms
triggers ... ok 19735 ms
truncate ... ok 20080 ms
trusted_extension ... ok 20076 ms
update-15 ... ok 19852 ms
upsert ... ok 19735 ms
parallel group (4 tests): util version vacuum vacuum_parallel
util ... ok 1669 ms
vacuum ... ok 1698 ms
vacuum_parallel ... ok 1698 ms
version ... ok 1695 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".