orafce
Repository:
https://github.com/orafce/orafce
The package provides a set of functions and operators that emulate the functionality of Oracle's SQL syntax and behavior, allowing for easier migration and compatibility with existing Oracle-based applications.
Information Analysis
Duplicate Code Analysis
| Total Lines of Code: ? | 22688 |
| Lines of Duplicate Code: ? | 3242 |
| Percentage of Codebase: ? | 14.29% |
Versioning Analysis
| Total Lines of Code: ? | 22688 |
| Lines of Encapsulated Versioning Code: ? | 1090 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 4.8% |
| PostgreSQL Versions Cased On: ? | 9,12,13,14,15,16 |
Compatibility Analysis
| Number of Failed Extensions: | 7 |
| Failure Rate: | 6.3% |
Failed Extensions
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 orafce ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_cron-test ... ok 445 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 orafce ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_cron-test ... ok 466 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 init ... ok 59 ms
parallel group (2 tests): dbms_pipe_session_A dbms_pipe_session_B
dbms_pipe_session_A ... ok 186 ms
dbms_pipe_session_B ... ok 10247 ms
parallel group (3 tests): dbms_alert_session_C dbms_alert_session_A dbms_alert_session_B
dbms_alert_session_A ... ok 11199 ms
dbms_alert_session_B ... ok 13193 ms
dbms_alert_session_C ... ok 3135 ms
test orafce ... ok 109 ms
test orafce2 ... ok 11 ms
test dbms_output ... ok 293 ms
test dbms_utility ... ok 2030 ms
test files ... ok 38 ms
test varchar2 ... ok 40 ms
test nvarchar2 ... ok 51 ms
test aggregates ... ok 44 ms
test nlssort ... ok 127 ms
test dbms_random ... ok 5 ms
test regexp_func ... ok 23 ms
test dbms_sql ... ok 44 ms
======================
All 18 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 orafce ==============
CREATE EXTENSION
============== running regression test queries ==============
test test0 ... ok 8 ms
test test1 ... ok 10 ms
test test2 ... ok 12 ms
test test3 ... ok 36 ms
test test4 ... ok 114 ms
test test5 ... ok 11 ms
test test6 ... ok 34 ms
test test7 ... FAILED 17 ms
test test8 ... ok 27 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 init ... FAILED 51 ms
parallel group (2 tests): dbms_pipe_session_B dbms_pipe_session_A
dbms_pipe_session_A ... FAILED 154 ms
dbms_pipe_session_B ... FAILED 129 ms
parallel group (3 tests): dbms_alert_session_C dbms_alert_session_B dbms_alert_session_A
dbms_alert_session_A ... FAILED 3132 ms
dbms_alert_session_B ... FAILED 131 ms
dbms_alert_session_C ... FAILED 124 ms
test orafce ... FAILED 77 ms
test orafce2 ... FAILED 4 ms
test dbms_output ... FAILED 226 ms
test dbms_utility ... FAILED 24 ms
test files ... FAILED 28 ms
test varchar2 ... FAILED 31 ms
test nvarchar2 ... FAILED 32 ms
test aggregates ... FAILED 42 ms
test nlssort ... FAILED 116 ms
test dbms_random ... FAILED 14 ms
test regexp_func ... FAILED 52 ms
test dbms_sql ... FAILED 55 ms
========================
18 of 18 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/orafce-VERSION_4_2_1/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/orafce-VERSION_4_2_1/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 orafce ==============
ERROR: cache lookup failed for type 18
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"orafce\"" "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.... 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?
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 init ... ok 90 ms
parallel group (2 tests): dbms_pipe_session_A dbms_pipe_session_B
dbms_pipe_session_A ... ok 182 ms
dbms_pipe_session_B ... ok 10243 ms
parallel group (3 tests): dbms_alert_session_C dbms_alert_session_A dbms_alert_session_B
dbms_alert_session_A ... ok 11211 ms
dbms_alert_session_B ... ok 13203 ms
dbms_alert_session_C ... ok 3135 ms
test orafce ... ok 120 ms
test orafce2 ... ok 12 ms
test dbms_output ... ok 304 ms
test dbms_utility ... ok 2031 ms
test files ... ok 42 ms
test varchar2 ... ok 52 ms
test nvarchar2 ... ok 47 ms
test aggregates ... ok 44 ms
test nlssort ... ok 127 ms
test dbms_random ... ok 5 ms
test regexp_func ... ok 22 ms
test dbms_sql ... ok 57 ms
======================
All 18 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 orafce ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 29 ms
test pgextwlist ... FAILED 71 ms
test errors ... FAILED 7 ms
test crossuser ... ok 16 ms
test hooks ... ok 8 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing orafce ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 25 ms
test pgextwlist ... FAILED 36 ms
test errors ... FAILED 7 ms
test crossuser ... ok 17 ms
test hooks ... ok 26 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "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 init ... ok 86 ms
parallel group (2 tests): dbms_pipe_session_A dbms_pipe_session_B
dbms_pipe_session_A ... ok 184 ms
dbms_pipe_session_B ... ok 10246 ms
parallel group (3 tests): dbms_alert_session_C dbms_alert_session_A dbms_alert_session_B
dbms_alert_session_A ... ok 11193 ms
dbms_alert_session_B ... ok 13187 ms
dbms_alert_session_C ... ok 3139 ms
test orafce ... ok 109 ms
test orafce2 ... ok 12 ms
test dbms_output ... ok 290 ms
test dbms_utility ... ok 2031 ms
test files ... ok 56 ms
test varchar2 ... ok 33 ms
test nvarchar2 ... ok 29 ms
test aggregates ... ok 40 ms
test nlssort ... ok 173 ms
test dbms_random ... ok 6 ms
test regexp_func ... ok 23 ms
test dbms_sql ... ok 46 ms
======================
All 18 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 init ... ok 57 ms
parallel group (2 tests): dbms_pipe_session_A dbms_pipe_session_B
dbms_pipe_session_A ... ok 147 ms
dbms_pipe_session_B ... ok 10202 ms
parallel group (3 tests): dbms_alert_session_C dbms_alert_session_A dbms_alert_session_B
dbms_alert_session_A ... ok 11185 ms
dbms_alert_session_B ... ok 13179 ms
dbms_alert_session_C ... ok 3131 ms
test orafce ... ok 96 ms
test orafce2 ... ok 4 ms
test dbms_output ... ok 190 ms
test dbms_utility ... ok 2017 ms
test files ... ok 33 ms
test varchar2 ... ok 28 ms
test nvarchar2 ... ok 26 ms
test aggregates ... ok 23 ms
test nlssort ... ok 95 ms
test dbms_random ... ok 7 ms
test regexp_func ... ok 23 ms
test dbms_sql ... ok 43 ms
======================
All 18 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 1154 ms
test alternate_users ... ok 836 ms
test chunk_utils ... ok 921 ms
test index ... ok 1039 ms
test pg_dump_unprivileged ... ok 778 ms
test tablespace ... ok 750 ms
parallel group (21 tests): create_table ddl_errors custom_type baserel_cache ddl_extra drop_extension drop_hypertable create_hypertable agg_bookends-15 broken_tables cluster-15 create_chunks cursor-15 delete-15 chunks ddl-15 chunk_adaptive copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5122 ms
append-15 ... ok 6565 ms
baserel_cache ... ok 5116 ms
broken_tables ... ok 5132 ms
chunk_adaptive ... ok 5145 ms
chunks ... ok 5136 ms
cluster-15 ... ok 5134 ms
constraint-15 ... ok 5235 ms
copy-15 ... ok 5150 ms
create_chunks ... ok 5134 ms
create_hypertable ... ok 5121 ms
create_table ... ok 5114 ms
cursor-15 ... ok 5134 ms
custom_type ... ok 5114 ms
ddl-15 ... ok 5143 ms
ddl_errors ... ok 5114 ms
ddl_extra ... ok 5118 ms
delete-15 ... ok 5134 ms
drop_extension ... FAILED 5118 ms
drop_hypertable ... ok 5119 ms
drop_owned ... ok 5247 ms
parallel group (21 tests): generated_as_identity drop_schema dump_meta partition merge histogram_test hash drop_rename_hypertable license partitioning lateral parallel-15 insert_single misc null_exclusion information_views insert_returning grant_hypertable extension_scripts insert-15 insert_many
drop_rename_hypertable ... ok 6069 ms
drop_schema ... ok 6067 ms
dump_meta ... ok 6067 ms
extension_scripts ... ok 6080 ms
generated_as_identity ... ok 4584 ms
grant_hypertable ... ok 6079 ms
hash ... ok 6068 ms
histogram_test ... ok 6068 ms
information_views ... ok 6077 ms
insert-15 ... ok 6474 ms
insert_many ... ok 7470 ms
insert_returning ... ok 6076 ms
insert_single ... ok 6076 ms
lateral ... ok 6073 ms
license ... ok 6067 ms
merge ... ok 6067 ms
misc ... ok 6076 ms
null_exclusion ... ok 6075 ms
parallel-15 ... ok 6073 ms
partition ... ok 6065 ms
partitioning ... ok 6070 ms
parallel group (21 tests): plain sort_optimization partitionwise-15 timestamp rowsecurity-15 update-15 plan_expand_hypertable-15 upsert tableam reloptions sql_query size_utils triggers plan_hypertable_inline-15 query-15 relocate_extension plan_ordered_append trusted_extension truncate plan_hashagg-15 pg_join
partitionwise-15 ... ok 7873 ms
pg_join ... ok 9912 ms
plain ... ok 7867 ms
plan_expand_hypertable-15 ... ok 7892 ms
plan_hashagg-15 ... ok 8865 ms
plan_hypertable_inline-15 ... ok 7929 ms
plan_ordered_append ... ok 8001 ms
query-15 ... ok 7929 ms
relocate_extension ... ok 7984 ms
reloptions ... ok 7919 ms
rowsecurity-15 ... ok 7882 ms
size_utils ... ok 7920 ms
sort_optimization ... ok 7866 ms
sql_query ... ok 7919 ms
tableam ... ok 7917 ms
timestamp ... ok 7872 ms
triggers ... ok 7927 ms
truncate ... ok 8043 ms
trusted_extension ... ok 8042 ms
update-15 ... ok 7887 ms
upsert ... ok 7915 ms
parallel group (4 tests): version vacuum_parallel util vacuum
util ... ok 723 ms
vacuum ... ok 725 ms
vacuum_parallel ... ok 722 ms
version ... ok 713 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 init ... ok 74 ms
parallel group (2 tests): dbms_pipe_session_A dbms_pipe_session_B
dbms_pipe_session_A ... ok 208 ms
dbms_pipe_session_B ... ok 10249 ms
parallel group (3 tests): dbms_alert_session_C dbms_alert_session_A dbms_alert_session_B
dbms_alert_session_A ... ok 11195 ms
dbms_alert_session_B ... ok 13192 ms
dbms_alert_session_C ... ok 3127 ms
test orafce ... ok 88 ms
test orafce2 ... ok 4 ms
test dbms_output ... ok 163 ms
test dbms_utility ... ok 2017 ms
test files ... ok 35 ms
test varchar2 ... ok 27 ms
test nvarchar2 ... ok 26 ms
test aggregates ... ok 22 ms
test nlssort ... ok 93 ms
test dbms_random ... ok 7 ms
test regexp_func ... ok 24 ms
test dbms_sql ... ok 43 ms
======================
All 18 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 1199 ms
test alternate_users ... ok 792 ms
test chunk_utils ... ok 905 ms
test index ... ok 1013 ms
test pg_dump_unprivileged ... ok 794 ms
test tablespace ... ok 744 ms
parallel group (21 tests): delete-15 drop_hypertable ddl_extra custom_type agg_bookends-15 ddl_errors baserel_cache create_hypertable broken_tables cluster-15 create_chunks create_table cursor-15 ddl-15 drop_extension chunks chunk_adaptive copy-15 constraint-15 drop_owned append-15
agg_bookends-15 ... ok 6885 ms
append-15 ... ok 8153 ms
baserel_cache ... ok 6885 ms
broken_tables ... ok 6894 ms
chunk_adaptive ... ok 6906 ms
chunks ... ok 6894 ms
cluster-15 ... ok 6893 ms
constraint-15 ... ok 7036 ms
copy-15 ... ok 6922 ms
create_chunks ... ok 6893 ms
create_hypertable ... ok 6886 ms
create_table ... ok 6893 ms
cursor-15 ... ok 6893 ms
custom_type ... ok 6881 ms
ddl-15 ... ok 6892 ms
ddl_errors ... ok 6883 ms
ddl_extra ... ok 6875 ms
delete-15 ... ok 6868 ms
drop_extension ... FAILED 6892 ms
drop_hypertable ... ok 6869 ms
drop_owned ... ok 7048 ms
parallel group (21 tests): null_exclusion partitioning license hash misc insert_returning merge generated_as_identity dump_meta extension_scripts histogram_test grant_hypertable information_views insert_single drop_rename_hypertable drop_schema lateral partition parallel-15 insert-15 insert_many
drop_rename_hypertable ... ok 9166 ms
drop_schema ... ok 9166 ms
dump_meta ... ok 9163 ms
extension_scripts ... ok 9163 ms
generated_as_identity ... ok 9163 ms
grant_hypertable ... ok 9165 ms
hash ... ok 9145 ms
histogram_test ... ok 9163 ms
information_views ... ok 9165 ms
insert-15 ... ok 9381 ms
insert_many ... ok 10766 ms
insert_returning ... ok 9158 ms
insert_single ... ok 9164 ms
lateral ... ok 9165 ms
license ... ok 9144 ms
merge ... ok 9158 ms
misc ... ok 9158 ms
null_exclusion ... ok 7453 ms
parallel-15 ... ok 9190 ms
partition ... ok 9164 ms
partitioning ... ok 9126 ms
parallel group (21 tests): reloptions timestamp update-15 plan_hypertable_inline-15 plain query-15 sort_optimization sql_query partitionwise-15 size_utils triggers tableam upsert plan_expand_hypertable-15 rowsecurity-15 plan_hashagg-15 plan_ordered_append trusted_extension truncate relocate_extension pg_join
partitionwise-15 ... ok 16278 ms
pg_join ... ok 17019 ms
plain ... ok 16269 ms
plan_expand_hypertable-15 ... ok 16303 ms
plan_hashagg-15 ... ok 16303 ms
plan_hypertable_inline-15 ... ok 16267 ms
plan_ordered_append ... ok 16303 ms
query-15 ... ok 16269 ms
relocate_extension ... ok 16693 ms
reloptions ... ok 16234 ms
rowsecurity-15 ... ok 16302 ms
size_utils ... ok 16277 ms
sort_optimization ... ok 16270 ms
sql_query ... ok 16276 ms
tableam ... ok 16277 ms
timestamp ... ok 16248 ms
triggers ... ok 16277 ms
truncate ... ok 16689 ms
trusted_extension ... ok 16660 ms
update-15 ... ok 16252 ms
upsert ... ok 16276 ms
parallel group (4 tests): version util vacuum_parallel vacuum
util ... ok 1394 ms
vacuum ... ok 1404 ms
vacuum_parallel ... ok 1401 ms
version ... ok 1371 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".