wal2json
Repository:
https://github.com/eulerto/wal2json
The output plugin decodes and converts PostgreSQL write-ahead log records into JSON format, providing a structured representation of database transactions for further processing or analysis.
Information Analysis
| Extensibility Types: | Utility Commands |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 3064 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 3064 |
| Lines of Encapsulated Versioning Code: ? | 574 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 18.73% |
| PostgreSQL Versions Cased On: ? | 9,10,11,12,15 |
Compatibility Analysis
| Number of Failed Extensions: | 8 |
| Failure Rate: | 5.8% |
Failed Extensions
basic_archive
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 cmdline ... FAILED 83 ms
test insert1 ... FAILED 91 ms
test update1 ... FAILED 130 ms
test update2 ... FAILED 150 ms
test update3 ... FAILED 138 ms
test update4 ... FAILED 81 ms
test delete1 ... FAILED 130 ms
test delete2 ... FAILED 153 ms
test delete3 ... FAILED 142 ms
test delete4 ... FAILED 81 ms
test savepoint ... FAILED 64 ms
test specialvalue ... FAILED 50 ms
test toast ... FAILED 97 ms
test bytea ... FAILED 58 ms
test message ... FAILED 44 ms
test typmod ... FAILED 67 ms
test filtertable ... FAILED 441 ms
test selecttable ... FAILED 226 ms
test include_timestamp ... FAILED 44 ms
test include_lsn ... FAILED 48 ms
test include_xids ... FAILED 49 ms
test include_domain_data_type ... FAILED 140 ms
test truncate ... FAILED 174 ms
test type_oid ... FAILED 44 ms
test actions ... FAILED 60 ms
test position ... FAILED 61 ms
test default ... FAILED 125 ms
test pk ... FAILED 141 ms
test rename_column ... FAILED 133 ms
========================
29 of 29 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/wal2json-wal2json_2_5/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/wal2json-wal2json_2_5/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test basic_archive ... ok 230 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
============== running regression test queries ==============
test pg_cron-test ... ok 793 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
============== running regression test queries ==============
test pg_cron-test ... ok 877 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 cmdline ... ok 153 ms
test insert1 ... ok 163 ms
test update1 ... ok 170 ms
test update2 ... ok 206 ms
test update3 ... ok 201 ms
test update4 ... ok 131 ms
test delete1 ... ok 180 ms
test delete2 ... ok 195 ms
test delete3 ... ok 216 ms
test delete4 ... ok 132 ms
test savepoint ... ok 113 ms
test specialvalue ... ok 113 ms
test toast ... ok 208 ms
test bytea ... ok 144 ms
test message ... ok 103 ms
test typmod ... ok 124 ms
test filtertable ... ok 485 ms
test selecttable ... ok 259 ms
test include_timestamp ... ok 106 ms
test include_lsn ... ok 111 ms
test include_xids ... ok 112 ms
test include_domain_data_type ... ok 208 ms
test truncate ... ok 236 ms
test type_oid ... ok 108 ms
test actions ... ok 130 ms
test position ... ok 127 ms
test default ... ok 194 ms
test pk ... ok 192 ms
test rename_column ... ok 189 ms
======================
All 29 tests passed.
======================
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test test0 ... ok 14 ms
test test1 ... ok 18 ms
test test2 ... ok 22 ms
test test3 ... ok 43 ms
test test4 ... ok 271 ms
test test5 ... ok 21 ms
test test6 ... ok 63 ms
test test7 ... FAILED 25 ms
test test8 ... ok 42 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 cmdline ... ok 167 ms
test insert1 ... ok 166 ms
test update1 ... ok 203 ms
test update2 ... ok 191 ms
test update3 ... ok 209 ms
test update4 ... ok 132 ms
test delete1 ... ok 156 ms
test delete2 ... ok 208 ms
test delete3 ... ok 193 ms
test delete4 ... ok 138 ms
test savepoint ... ok 116 ms
test specialvalue ... ok 107 ms
test toast ... ok 192 ms
test bytea ... ok 144 ms
test message ... ok 98 ms
test typmod ... ok 124 ms
test filtertable ... ok 492 ms
test selecttable ... ok 263 ms
test include_timestamp ... ok 107 ms
test include_lsn ... ok 116 ms
test include_xids ... ok 112 ms
test include_domain_data_type ... ok 202 ms
test truncate ... ok 223 ms
test type_oid ... ok 107 ms
test actions ... ok 131 ms
test position ... ok 130 ms
test default ... ok 186 ms
test pk ... ok 188 ms
test rename_column ... ok 186 ms
======================
All 29 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
============== running regression test queries ==============
test pg_queryid ... FAILED 50 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_show_plans
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
(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_walinspect
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_walinspect ==============
CREATE EXTENSION
============== running regression test queries ==============
test cmdline ... FAILED 79 ms
test insert1 ... FAILED 109 ms
test update1 ... FAILED 136 ms
test update2 ... FAILED 156 ms
test update3 ... FAILED 153 ms
test update4 ... FAILED 78 ms
test delete1 ... FAILED 133 ms
test delete2 ... FAILED 146 ms
test delete3 ... FAILED 136 ms
test delete4 ... FAILED 76 ms
test savepoint ... FAILED 63 ms
test specialvalue ... FAILED 44 ms
test toast ... FAILED 99 ms
test bytea ... FAILED 56 ms
test message ... FAILED 44 ms
test typmod ... FAILED 68 ms
test filtertable ... FAILED 469 ms
test selecttable ... FAILED 210 ms
test include_timestamp ... FAILED 28 ms
test include_lsn ... FAILED 36 ms
test include_xids ... FAILED 47 ms
test include_domain_data_type ... FAILED 130 ms
test truncate ... FAILED 163 ms
test type_oid ... FAILED 46 ms
test actions ... FAILED 63 ms
test position ... FAILED 60 ms
test default ... FAILED 123 ms
test pk ... FAILED 131 ms
test rename_column ... FAILED 129 ms
========================
29 of 29 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/wal2json-wal2json_2_5/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/wal2json-wal2json_2_5/regression.out".
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test pg_walinspect ... ok 135 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
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
test_decoding
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test ddl ... ok 1779 ms
test xact ... ok 91 ms
test rewrite ... ok 2060 ms
test toast ... ok 542 ms
test permissions ... ok 299 ms
test decoding_in_xact ... ok 249 ms
test decoding_into_rel ... ok 145 ms
test binary ... ok 91 ms
test prepared ... ok 126 ms
test replorigin ... ok 286 ms
test time ... ok 90 ms
test messages ... ok 99 ms
test spill ... ok 2264 ms
test slot ... FAILED 1347 ms
test truncate ... ok 130 ms
test stream ... ok 150 ms
test stats ... FAILED 384 ms
test twophase ... ok 234 ms
test twophase_stream ... ok 145 ms
=======================
2 of 19 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/test_decoding/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/test_decoding/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 cmdline ... ok 164 ms
test insert1 ... ok 169 ms
test update1 ... ok 184 ms
test update2 ... ok 213 ms
test update3 ... ok 166 ms
test update4 ... ok 140 ms
test delete1 ... ok 201 ms
test delete2 ... ok 196 ms
test delete3 ... ok 201 ms
test delete4 ... ok 149 ms
test savepoint ... ok 115 ms
test specialvalue ... ok 114 ms
test toast ... ok 218 ms
test bytea ... ok 144 ms
test message ... ok 111 ms
test typmod ... ok 129 ms
test filtertable ... ok 445 ms
test selecttable ... ok 258 ms
test include_timestamp ... ok 108 ms
test include_lsn ... ok 102 ms
test include_xids ... ok 113 ms
test include_domain_data_type ... ok 199 ms
test truncate ... ok 272 ms
test type_oid ... ok 123 ms
test actions ... ok 135 ms
test position ... ok 116 ms
test default ... ok 195 ms
test pk ... ok 166 ms
test rename_column ... ok 188 ms
======================
All 29 tests passed.
======================
waiting for server to shut down.... done
server stopped