PostgreSQL wiki - Recent changes [en]

Converting from other Databases to PostgreSQL

Bersace03 — Thu, 12 Nov 2026 08:15:51 GMT

Document PostgreSQL Migrator for Oracle, MariaDB and MySQL.

← Older revision		Revision as of 08:15, 12 November 2026
Line 9:		Line 9:

	* [https://www.ispirer.com/products/postgresql-migration#migrate-to-postgresql Ispirer Toolkit] performs automatic migration of any popular RDBMS to PostgreSQL. A free demo of Ispirer Toolkit is available.		* [https://www.ispirer.com/products/postgresql-migration#migrate-to-postgresql Ispirer Toolkit] performs automatic migration of any popular RDBMS to PostgreSQL. A free demo of Ispirer Toolkit is available.
	* [https://postgresql-migrator.readthedocs.org PostgreSQL Migrator] 100% Open source. Handles Oracle 11+, MySQL 8+ and MariaDB. Transpiles query and procedural code. Fast transfer using streamed bulk COPY.		* [https://postgresql-migrator.readthedocs.org PostgreSQL Migrator] 100% Open source. Handles Oracle 11+, MySQL 5.7+ and MariaDB 10.3+. Transpiles query and procedural code. Fast transfer using streamed bulk COPY.
	* [https://www.spectralcore.com/sqltran SQL Tran] is a database code translation IDE that converts the SQL and procedural code (types, tables, views, procedures, functions, triggers, packages) of Oracle, SQL Server, and Azure SQL to PostgreSQL, automatically translating 95% to 99% of the code. It processes millions of lines of database code in seconds, performs full static analysis, and generates both correctness and performance tests. Integration with Omni Loader allows for unified code and data migration. A free assessment is available.		* [https://www.spectralcore.com/sqltran SQL Tran] is a database code translation IDE that converts the SQL and procedural code (types, tables, views, procedures, functions, triggers, packages) of Oracle, SQL Server, and Azure SQL to PostgreSQL, automatically translating 95% to 99% of the code. It processes millions of lines of database code in seconds, performs full static analysis, and generates both correctness and performance tests. Integration with Omni Loader allows for unified code and data migration. A free assessment is available.
	* [https://www.convertum.ru/database-migration/postgresql-migration#migrate-to-postgresql Convertum.ru] is a robust tool for automatic migration of more than 25 databases, including migration to PostgreSQL. 30-days trial is available for free.		* [https://www.convertum.ru/database-migration/postgresql-migration#migrate-to-postgresql Convertum.ru] is a robust tool for automatic migration of more than 25 databases, including migration to PostgreSQL. 30-days trial is available for free.
Line 219:		Line 219:
	=== Scripts, programs ===		=== Scripts, programs ===

	[https://~~www~~.~~ispirer~~.~~com/products/mysql-to-postgresql-migration Ispirer Toolkit~~] ~~automatically migrates the entire database schema (tables, views, stored procedures, functions~~, ~~triggers, etc~~.) and ~~transfers data from MySQL to PostgreSQL~~. ~~A free demo of Ispirer Toolkit is available~~.		* [https://postgresql-migrator.readthedocs.org PostgreSQL Migrator] 100% Open source. Handles MySQL 5.7 and later, MariaDB 10.3 and later. Fast transfer using streamed bulk COPY and long column chunking.

	[https://~~pypi~~.~~python~~.~~org~~/~~pypi~~/~~pg_chameleon pg_chameleon~~] ~~is a python procedure which replicates~~ MySQL ~~into~~ PostgreSQL. ~~The tool can detach the replica for minimal downtime migrations~~.		* [https://www.ispirer.com/products/mysql-to-postgresql-migration Ispirer Toolkit] automatically migrates the entire database schema (tables, views, stored procedures, functions, triggers, etc.) and transfers data from MySQL to PostgreSQL. A free demo of Ispirer Toolkit is available.

	[https://~~www~~.~~dbsofts~~.~~com~~/~~articles~~/~~mysql_to_postgresql/ ESF Database Migration Toolkit~~] ~~How to migrate~~ MySQL to PostgreSQL ~~in an easy way~~.		* [https://pypi.python.org/pypi/pg_chameleon pg_chameleon] is a python procedure which replicates MySQL into PostgreSQL. The tool can detach the replica for minimal downtime migrations.

	[https://github.com/dimitri/pgloader pgloader] supports full migration of the database schema and data from a single command line and provides a command language for more complex or specific scenarios. It is still fully supported: please report any bugs on its GitHub page. It appears in the 2013 section here because that's when it has been published first.		* [https://www.dbsofts.com/articles/mysql_to_postgresql/ ESF Database Migration Toolkit] How to migrate MySQL to PostgreSQL in an easy way.

			* [https://github.com/dimitri/pgloader pgloader] supports full migration of the database schema and data from a single command line and provides a command language for more complex or specific scenarios. It is still fully supported: please report any bugs on its GitHub page. It appears in the 2013 section here because that's when it has been published first.

	* [https://dbconvert.com/mysql/postgresql/ DBConvert] Desktop tool that migrates MySQL schema, data, indexes and keys to PostgreSQL, with per-column type mapping and repeatable runs.		* [https://dbconvert.com/mysql/postgresql/ DBConvert] Desktop tool that migrates MySQL schema, data, indexes and keys to PostgreSQL, with per-column type mapping and repeatable runs.
Line 288:		Line 290:

	* [https://www.ispirer.com/products/oracle-to-postgresql-migration Ispirer Toolkit] automatically migrates the entire database schema (tables, views, packages, stored procedures, functions, triggers, etc.) and transfers data from Oracle to PostgreSQL. A free demo of Ispirer Toolkit is available.		* [https://www.ispirer.com/products/oracle-to-postgresql-migration Ispirer Toolkit] automatically migrates the entire database schema (tables, views, packages, stored procedures, functions, triggers, etc.) and transfers data from Oracle to PostgreSQL. A free demo of Ispirer Toolkit is available.
			* [https://postgresql-migrator.readthedocs.org PostgreSQL Migrator] 100% Open source. Handles Oracle 11c to 26ai. Transpiles query and procedural code. Fast transfer using streamed bulk COPY and LOB chunking.
	* [https://github.com/Muzzammil242/pgrecon pgrecon] assesses an Oracle schema for a move to PostgreSQL from an offline dump and converts what it can prove. It never connects to either database: a read-only SQL*Plus script run by the DBA produces the dump; pgrecon builds a local inventory from it, runs 80 compatibility rules with remedies and an effort estimate, and emits PostgreSQL DDL, naming everything it declines in a residue report. Open source, Apache-2.0, Python (pip install pgrecon).		* [https://github.com/Muzzammil242/pgrecon pgrecon] assesses an Oracle schema for a move to PostgreSQL from an offline dump and converts what it can prove. It never connects to either database: a read-only SQL*Plus script run by the DBA produces the dump; pgrecon builds a local inventory from it, runs 80 compatibility rules with remedies and an effort estimate, and emits PostgreSQL DDL, naming everything it declines in a residue report. Open source, Apache-2.0, Python (pip install pgrecon).
	* [https://www.ispirer.com/data-migration IDM (Ispirer Data Migrator)], a part of the Ispirer Ecosystem, is an enterprise-grade replication solution designed for streamlined data migration with near-zero downtime and no middleware required.		* [https://www.ispirer.com/data-migration IDM (Ispirer Data Migrator)], a part of the Ispirer Ecosystem, is an enterprise-grade replication solution designed for streamlined data migration with near-zero downtime and no middleware required.

Known Buildfarm Test Failures

Law — Thu, 12 Nov 2026 06:47:29 GMT

Also 001_rep_changes.pl failed on fairywren due to walreceiver not reconnecting after primary restart

@@ Line 939: / Line 939: @@
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=unicorn&dt=2026-09-21%2012%3A31%3A10 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=unicorn&dt=2026-09-21%2012%3A31%3A10 - master]<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=unicorn&dt=2026-11-02%2018%3A32%3A39 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=unicorn&dt=2026-11-02%2018%3A32%3A39 - REL_19_STABLE]<br/>
 ==== Also 021_twophase.pl failed on fairywren due to walreceiver not reconnecting after primary restart ====
@@ Line 2,508: / Line 2,509: @@
 {{messageLink|078be990-1420-4ab5-997f-82e7afb86f7c%40gmail.com|Emptying oauth_validator_libraries doesn't stop OAuth logins \ oauth_validator/001_server.pl fails now on overloaded animals}}
 ----
@@ Line 11,347: / Line 11,381: @@
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2016%3A55%3A05 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2016%3A55%3A05 - REL_14_STABLE]<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-11-09%2018%3A39%3A24 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-11-09%2018%3A39%3A24 - REL_14_STABLE]<br/>
+[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-11-11%2018%3A24%3A18 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-11-11%2018%3A24%3A18 - REL_15_STABLE]<br/>
 <pre>
@@ Line 11,772: / Line 11,806: @@
 ----
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hamerkop&dt=2026-10-31%2019%3A11%3A07 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hamerkop&dt=2026-10-31%2019%3A11%3A07 - REL_17_STABLE]<br/>
 <pre>
 SUCCESS: The process with PID 8636 (child process of PID 19508) has been terminated.
@@ Line 11,786: / Line 11,821: @@
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2013%3A03%3A08 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2013%3A03%3A08 - REL_15_STABLE]<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A52%3A32 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A52%3A32 - REL_15_STABLE]<br/>
 <pre>
 t/003_check.pl         (Wstat: 65280 (exited 255) Tests: 3 Failed: 0)
@@ Line 11,809: / Line 11,848: @@
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A59%3A07 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A59%3A07 - REL_17_STABLE]<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A35%3A07 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A35%3A07 - REL_16_STABLE]<br/>
 <pre>

PostgreSQL 19 Open Items

Michael-kun — Wed, 11 Nov 2026 22:19:45 GMT

← Older revision		Revision as of 22:19, 11 November 2026
Line 25:		Line 25:
	** Commit: {{PgCommitURL\|447aae13b03}}		** Commit: {{PgCommitURL\|447aae13b03}}
	** Owner: Alexander Korotkov		** Owner: Alexander Korotkov

			== Resolved Issues ==

			=== resolved before 19.0 ===

	* [https://postgr.es/m/CAN4CZFNP%2B_aVsTqxfyNLU%2BAtRZMJeDRAR9XRfjPTwsWs3TXVaQ%40mail.gmail.com BGWORKER_INTERRUPTIBLE workers are never restarted after DROP/ALTER/CREATE DATABASE]		* [https://postgr.es/m/CAN4CZFNP%2B_aVsTqxfyNLU%2BAtRZMJeDRAR9XRfjPTwsWs3TXVaQ%40mail.gmail.com BGWORKER_INTERRUPTIBLE workers are never restarted after DROP/ALTER/CREATE DATABASE]
	** Commit: {{PgCommitURL\|f1e251be80a0}}		** Commit: {{PgCommitURL\|f1e251be80a0}}
	** Owner: Michael Paquier		** Owner: Michael Paquier
			** Fix: {{PgCommitURL\|5bf919736b20}}
	~~== Resolved Issues ==~~

	=== resolved before 19rc2 ===		=== resolved before 19rc2 ===

Known Buildfarm Test Failures

Law — Wed, 11 Nov 2026 18:04:16 GMT

Unsorted/Unhelpful Test Failures

← Older revision		Revision as of 18:04, 11 November 2026
(6 intermediate revisions by the same user not shown)
Line 8,793:		Line 8,793:
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A20%3A59 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A20%3A59 - REL_19_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A20%3A59 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A20%3A59 - REL_19_STABLE]<br/>
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A50%3A43 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A50%3A43 - master]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A50%3A43 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-10%2015%3A50%3A43 - master]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-11%2013%3A08%3A06 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=ayu&dt=2026-11-11%2013%3A08%3A06 - REL_14_STABLE]<br/>
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A12%3A25 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A12%3A25 - REL_14_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A12%3A25 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A12%3A25 - REL_14_STABLE]<br/>
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A35%3A13 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A35%3A13 - REL_15_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A35%3A13 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-10%2011%3A35%3A13 - REL_15_STABLE]<br/>
Line 8,807:		Line 8,808:
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-10%2003%3A29%3A58 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-10%2003%3A29%3A58 - master]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-10%2003%3A29%3A58 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-10%2003%3A29%3A58 - master]<br/>
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-11%2001%3A08%3A06 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-11%2001%3A08%3A06 - REL_14_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-11%2001%3A08%3A06 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=urocryon&dt=2026-11-11%2001%3A08%3A06 - REL_14_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-11%2011%3A12%3A24 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chimaera&dt=2026-11-11%2011%3A12%3A24 - REL_14_STABLE]<br/>


Line 11,743:		Line 11,745:
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-20%2002%3A12%3A32 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-20%2002%3A12%3A32 - master]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-20%2002%3A12%3A32 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-20%2002%3A12%3A32 - master]<br/>
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-21%2000%3A20%3A14 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-21%2000%3A20%3A14 - master]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-21%2000%3A20%3A14 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-10-21%2000%3A20%3A14 - master]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2008%3A42%3A07 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2008%3A42%3A07 - REL_16_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2009%3A05%3A16 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2009%3A05%3A16 - REL_17_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2009%3A29%3A50 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2009%3A29%3A50 - REL_18_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2013%3A22%3A44 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-11-11%2013%3A22%3A44 - master]<br/>
	<pre>		<pre>
	2026-10-20 15:15:39.568 UTC [9076:4] [unknown] FATAL: could not write init file: No space left on device		2026-10-20 15:15:39.568 UTC [9076:4] [unknown] FATAL: could not write init file: No space left on device
Line 11,777:		Line 11,783:
	----		----
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A03%3A08 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A03%3A08 - REL_14_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A03%3A08 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A03%3A08 - REL_14_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A35%3A07 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A35%3A07 - REL_16_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2013%3A03%3A08 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2013%3A03%3A08 - REL_15_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A52%3A32 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2004%3A52%3A32 - REL_15_STABLE]<br/>
	<pre>		<pre>
	t/003_check.pl (Wstat: 65280 (exited 255) Tests: 3 Failed: 0)		t/003_check.pl (Wstat: 65280 (exited 255) Tests: 3 Failed: 0)
Line 11,793:		Line 11,802:
	# No postmaster PID for node "test"		# No postmaster PID for node "test"
	Bail out! open failed: Invalid argument		Bail out! open failed: Invalid argument
			</pre>
			----
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2007%3A36%3A59 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2007%3A36%3A59 - master]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2006%3A55%3A37 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2006%3A55%3A37 - REL_19_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2006%3A26%3A10 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2006%3A26%3A10 - REL_18_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A59%3A07 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A59%3A07 - REL_17_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A35%3A07 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-11-11%2005%3A35%3A07 - REL_16_STABLE]<br/>

			<pre>
			2026-11-11 08:21:08.384 UTC [9720:1] LOG: starting PostgreSQL 20devel on x86_64-windows, compiled by gcc-16.2.0, 64-bit
			2026-11-11 08:21:08.385 UTC [9720:2] FATAL: could not create lock file "/home/pgrunner/bf/root/tmp/buildfarm-gL35Uf/.s.PGSQL.5778.lock": No such file or directory
	</pre>		</pre>
	----		----

	== [https://wiki.postgresql.org/wiki/Known_Buildfarm_Test_Failures_-_Archive Known Buildfarm Test Failures - Archive] ==		== [https://wiki.postgresql.org/wiki/Known_Buildfarm_Test_Failures_-_Archive Known Buildfarm Test Failures - Archive] ==

PGConf.EU 2026 New PostgreSQL Community Members Summit

Alexk — Wed, 11 Nov 2026 08:18:40 GMT

New PostgreSQL Community Members - Summit

← Older revision		Revision as of 08:18, 11 November 2026
Line 30:		Line 30:
	15:30: [https://vyruss.org/blog/pgconfeu-2026-megapost.html#:~:text=New%20PostgreSQL%20Community%20Members%20Summit Zero to PUG: A Playbook for New Community Builders] (Jimmy Angelakos, Charis Charalampidi)		15:30: [https://vyruss.org/blog/pgconfeu-2026-megapost.html#:~:text=New%20PostgreSQL%20Community%20Members%20Summit Zero to PUG: A Playbook for New Community Builders] (Jimmy Angelakos, Charis Charalampidi)

	15:45: PostgreSQL Berlin: how to start a user group (Oleksii Kliukin)		15:45: [https://wiki.postgresql.org/images/b/bb/Pgberlin-how-to-start-a-user-group.pdf PostgreSQL Berlin: how to start a user group] (Oleksii Kliukin)

	16:00: [https://cdn.cloomba.com/cloomba/pgconfeu-community-day-cloomba.pdf A Privacy-First Event Platform for the European PostgreSQL Community] (Pavlo Golub, Sergey Chehuta Cloomba)		16:00: [https://cdn.cloomba.com/cloomba/pgconfeu-community-day-cloomba.pdf A Privacy-First Event Platform for the European PostgreSQL Community] (Pavlo Golub, Sergey Chehuta Cloomba)

File:Pgberlin-how-to-start-a-user-group.pdf

Alexk — Wed, 11 Nov 2026 08:10:10 GMT

Alexk uploaded File:Pgberlin-how-to-start-a-user-group.pdf A talk "Postgres Berlin: How to start a user group" by Oleksii Kliukin from the PostreSQL Community Summit at PGConf.EU 2026 in Valencia

New page

== Summary ==
A talk "Postgres Berlin: How to start a user group" by Oleksii Kliukin from the PostreSQL Community Summit at PGConf.EU 2026 in Valencia

Known Buildfarm Test Failures

Law — Wed, 11 Nov 2026 05:36:39 GMT

Unsorted/Unhelpful Test Failures

@@ Line 8,756: / Line 8,756: @@
 [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=dcf112bd4  Fix oauth validator test on EXEC_BACKEND]
 ----
@@ Line 11,718: / Line 11,774: @@
 duration:     50.20s
 result:       exit status 1
 </pre>
 ----
 == [https://wiki.postgresql.org/wiki/Known_Buildfarm_Test_Failures_-_Archive Known Buildfarm Test Failures - Archive] ==

Don't Do This

Kirkw — Wed, 11 Nov 2026 03:40:59 GMT

Added comments on not using Temporary Tables in frequent executed code (Which I wish I knew)

@@ Line 64: / Line 64: @@
 One of the very few exceptions would be [https://github.com/arkhipov/temporal_tables temporal_tables] extension if you are in a pinch and want to use that for row versioning in place of a lacking SQL 2011 support. Table inheritance will provide a small shortcut instead of using <code>UNION ALL</code> to get both historical as well as current rows.
 Even then you ought to be wary of [http://clarkdave.net/2015/02/historical-records-with-postgresql-and-temporal-tables-and-sql-2011/#using-inheritance caveats] while working with parent table.
 <!--====================================================================================================-->

The PostgreSQL Security Threat Model (DRAFT)

Bmomjian — Tue, 10 Nov 2026 14:59:29 GMT

Behaviors That Are Not Considered Security Vulnerabilities: add "C"

← Older revision		Revision as of 14:59, 10 November 2026
(One intermediate revision by the same user not shown)
Line 16:		Line 16:

	* Denial of service attacks caused by repeated cluster connection attempts; these are best solved by network tools		* Denial of service attacks caused by repeated cluster connection attempts; these are best solved by network tools

			* Crash caused by a NULL C pointer reference

	* CPU, memory, and I/O exhaustion from a valid SQL statement by an authenticated user; these are best solved with user activity and system resource monitoring		* CPU, memory, and I/O exhaustion from a valid SQL statement by an authenticated user; these are best solved with user activity and system resource monitoring

Known Buildfarm Test Failures

Law — Mon, 09 Nov 2026 19:00:14 GMT

Unsorted/Unhelpful Test Failures

← Older revision		Revision as of 19:00, 9 November 2026
(One intermediate revision by the same user not shown)
Line 2,713:		Line 2,713:
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=phycodurus&dt=2026-10-22%2022%3A04%3A35 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=phycodurus&dt=2026-10-22%2022%3A04%3A35 - REL_14_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=phycodurus&dt=2026-10-22%2022%3A04%3A35 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=phycodurus&dt=2026-10-22%2022%3A04%3A35 - REL_14_STABLE]<br/>
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2026-10-30%2005%3A41%3A54 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2026-10-30%2005%3A41%3A54 - REL_14_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2026-10-30%2005%3A41%3A54 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2026-10-30%2005%3A41%3A54 - REL_14_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=phycodurus&dt=2026-11-09%2007%3A47%3A17 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=phycodurus&dt=2026-11-09%2007%3A47%3A17 - REL_14_STABLE]<br/>


Line 11,287:		Line 11,288:
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2004%3A51%3A58 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2004%3A51%3A58 - REL_14_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2004%3A51%3A58 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2004%3A51%3A58 - REL_14_STABLE]<br/>
	[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2016%3A55%3A05 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2016%3A55%3A05 - REL_14_STABLE]<br/>		[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2016%3A55%3A05 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-10-26%2016%3A55%3A05 - REL_14_STABLE]<br/>
			[https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-11-09%2018%3A39%3A24 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=adder&dt=2026-11-09%2018%3A39%3A24 - REL_14_STABLE]<br/>

PGConf.EU 2026 PostgreSQL Training Materials Working Group

P.luzanov@postgrespro.ru — Mon, 09 Nov 2026 10:11:23 GMT

Existing training materials: what's good and bad

← Older revision		Revision as of 10:11, 9 November 2026
Line 74:		Line 74:
	\|-		\|-
	\| [https://www.crunchydata.com/developers/playground Crunchy Data Developer Playground] \|\| Sandbox plus tutorials.		\| [https://www.crunchydata.com/developers/playground Crunchy Data Developer Playground] \|\| Sandbox plus tutorials.
			\|-
			\| [https://postgrespro.com/community/courses Postgres Pro courses for DBAs and developers] \|\| Self study training courses.
	\|}		\|}

Known Buildfarm Test Failures

Law — Mon, 09 Nov 2026 05:17:29 GMT

oauth_validator/001_server.pl fails on overloaded animals

@@ Line 15: / Line 15: @@
 # with stderr:
 # Looks like your test exited with 29 just after 4.
-[23:01:41] t/020_archive_status.pl ..............
+[23:01:41] t/020_archive_status.pl 7..............
 Dubious, test returned 29 (wstat 7424, 0x1d00)
 Failed 12/16 subtests
@@ Line 2,482: / Line 2,482: @@
 {{messageLink|4ccf62c4-48ed-47cb-badc-9ae436d91b39%40app.fastmail.com#6434c9ffe3c955bfbefb5a3748bc7d2f|greenfly lwlock corruption in REL_14_STABLE and REL_15_STABLE}}
 ----

PGConf.EU 2026 Organizing and Growing Community Events

Henr33 — Sun, 08 Nov 2026 19:28:22 GMT

Developer outreach (Henrietta Dombrovskaya)

Show changes

PostgreSQL 19 Open Items

Zhong950419 — Sun, 08 Nov 2026 01:37:07 GMT

Live issues

← Older revision		Revision as of 01:37, 8 November 2026
(3 intermediate revisions by the same user not shown)
Line 21:		Line 21:

	'''NOTE''': Please list the Owner of the open item. If you're unsure who the Owner is, by default the owner should be the committer who made the target commit.		'''NOTE''': Please list the Owner of the open item. If you're unsure who the Owner is, by default the owner should be the committer who made the target commit.

	* [https://postgr.es/m/CAGRkXqT+5+mQhoKZFTiM4yOZtVV=NW506vDwFtVeG+VmL_W5wQ@mail.gmail.com pg_upgrade --check passes, then the upgrade fails (standard_conforming_strings = off, escape_string_warning, user uuid/bytea casts)]
	** Commit: {{PgCommitURL\|45762084545}}, {{PgCommitURL\|ba21f5bf8af}}
	** Owner: Tom Lane, Masahiko Sawada

	* [https://www.postgresql.org/message-id/CABPTF7XekTZiMrzDVjW9mdBZMm_9E_8+FvA=nzsPfqvbysxXyA@mail.gmail.com test: avoid redundant standby catchup in 049_wait_for_lsn]		* [https://www.postgresql.org/message-id/CABPTF7XekTZiMrzDVjW9mdBZMm_9E_8+FvA=nzsPfqvbysxXyA@mail.gmail.com test: avoid redundant standby catchup in 049_wait_for_lsn]
Line 1,196:		Line 1,192:

	* [https://www.postgresql.org/message-id/CAGRkXqTBsBegZ8rNMYjwkeu1V5wRQ06zR6jTVickqP_3E7mb8g@mail.gmail.com Wrong results from Memoize with a nondeterministic collation]		* [https://www.postgresql.org/message-id/CAGRkXqTBsBegZ8rNMYjwkeu1V5wRQ06zR6jTVickqP_3E7mb8g@mail.gmail.com Wrong results from Memoize with a nondeterministic collation]

			* [https://postgr.es/m/CAGRkXqRzM-68S9OhtLsTscZ_hhpHhy=ArWCdmp5GxRxo+UBmig@mail.gmail.com pg_upgrade --check passes, then the upgrade fails (standard_conforming_strings = off, escape_string_warning, user uuid/bytea casts)]
			** Commit: {{PgCommitURL\|45762084545}}, {{PgCommitURL\|ba21f5bf8af}}
			** Owner: Tom Lane, Masahiko Sawada

	=== Fixed issues ===		=== Fixed issues ===

PostgreSQL 19 Open Items

Zsolt.parragi — Sat, 07 Nov 2026 22:09:08 GMT

Open Issues

← Older revision		Revision as of 22:09, 7 November 2026
Line 29:		Line 29:
	** Commit: {{PgCommitURL\|447aae13b03}}		** Commit: {{PgCommitURL\|447aae13b03}}
	** Owner: Alexander Korotkov		** Owner: Alexander Korotkov

			* [https://postgr.es/m/CAN4CZFNP%2B_aVsTqxfyNLU%2BAtRZMJeDRAR9XRfjPTwsWs3TXVaQ%40mail.gmail.com BGWORKER_INTERRUPTIBLE workers are never restarted after DROP/ALTER/CREATE DATABASE]
			** Commit: {{PgCommitURL\|f1e251be80a0}}
			** Owner: Michael Paquier

	== Resolved Issues ==		== Resolved Issues ==

User:Zsolt.parragi

Jconway — Sat, 07 Nov 2026 14:17:56 GMT

Jconway changed group membership for Zsolt.parragi from (none) to editor

PostgreSQL 20 Extension Bugs

Devrimgunduz — Sat, 07 Nov 2026 10:04:05 GMT

Created page with "= Please DO NOT EDIT THIS PAGE unless you are Devrim or Christoph. = == Known PostgreSQL 20 problems in extension modules == === Extensions that fail to build === === Extensions that build but regression tests fail === ues/25 (not critical) === Discontinued extensions === * login_hook: https://github.com/splendiddata/login_hook/?tab=readme-ov-file#postgres-versions (feature is already included in v17) * pg_auto_failover: https://github.com/hapostgres/pg_auto_failov..."

New page

= Please DO NOT EDIT THIS PAGE unless you are Devrim or Christoph. =

== Known PostgreSQL 20 problems in extension modules ==

=== Extensions that fail to build ===

=== Extensions that build but regression tests fail ===
ues/25 (not critical)

=== Discontinued extensions ===

* login_hook: https://github.com/splendiddata/login_hook/?tab=readme-ov-file#postgres-versions (feature is already included in v17)
* pg_auto_failover: https://github.com/hapostgres/pg_auto_failover (maintainer is away)
* pgcryptokey: https://momjian.us/download/pgcryptokey/
* periods: https://github.com/xocolatl/periods/ : Temporal primary keys are in v18.

=== Extensions that are not maintained ===

* redis_fdw: Does not build since v14: https://github.com/nahanni/rw_redis_fdw/issues/23

=== Testing pending ===

=== Already working or fixed ===

[[Category:Extensions]]
[[Category:Development]]

Known Buildfarm Test Failures

Law — Sat, 07 Nov 2026 05:31:45 GMT

culicidae failed to restart server due to incorrect checksum in control file

@@ Line 446: / Line 446: @@
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=culicidae&dt=2026-10-14%2010%3A10%3A20 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=culicidae&dt=2026-10-14%2010%3A10%3A20 - REL_17_STABLE]<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=culicidae&dt=2026-10-29%2002%3A33%3A06 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=culicidae&dt=2026-10-29%2002%3A33%3A06 - REL_16_STABLE]<br/>
@@ Line 2,448: / Line 2,449: @@
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-11-04%2014%3A00%3A05 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-11-04%2014%3A00%3A05 - REL_14_STABLE]<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-11-05%2016%3A07%3A36 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-11-05%2016%3A07%3A36 - REL_15_STABLE]<br/>
@@ Line 8,699: / Line 8,701: @@
 [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f1e25929e Stabilize 051_effective_wal_level.pl.]
 ----

PGConf.EU 2026 New PostgreSQL Community Members Summit

Ads — Sat, 07 Nov 2026 00:12:30 GMT

← Older revision		Revision as of 00:12, 7 November 2026
Line 12:		Line 12:
	=== Sessions ===		=== Sessions ===

	13:30: Intro & Welcome (Cornelia Biacsics & Andreas Scherbaum)		13:30: [https://wiki.postgresql.org/wiki/File:Intro_New_PostgreSQL_Community_Members_Summit.pdf Intro & Welcome] (Cornelia Biacsics & Andreas Scherbaum)

	13:40: Down the Rabbit Hole: Navigating the PostgreSQL Community (Valeria Kaplan)		13:40: [https://dataegret.com/wp-content/uploads/2026/11/down-the-rabbit-hole-Valeria-Kaplan-pgconf-eu-2026.pdf Down the Rabbit Hole: Navigating the PostgreSQL Community] (Valeria Kaplan)

	13:55: [https://www.dropbox.com/scl/fi/yokzcbzlsmodyxnqn2lt0/PGConfEU-2026-Community-Session-Me-You-Them-Equals-PostgreSQL-Stacey-Haysler.pdf?rlkey=6pr1sntduiz4eyz8tfh9hcdct&st=mmwdi34s&dl=0 You + Me + Them = PostgreSQL] (Stacey Haysler)		13:55: [https://www.dropbox.com/scl/fi/yokzcbzlsmodyxnqn2lt0/PGConfEU-2026-Community-Session-Me-You-Them-Equals-PostgreSQL-Stacey-Haysler.pdf?rlkey=6pr1sntduiz4eyz8tfh9hcdct&st=mmwdi34s&dl=0 You + Me + Them = PostgreSQL] (Stacey Haysler)
Line 32:		Line 32:
	15:45: PostgreSQL Berlin: how to start a user group (Oleksii Kliukin)		15:45: PostgreSQL Berlin: how to start a user group (Oleksii Kliukin)

	16:00: A Privacy-First Event Platform for the European PostgreSQL Community (Pavlo Golub, Sergey Chehuta Cloomba)		16:00: [https://cdn.cloomba.com/cloomba/pgconfeu-community-day-cloomba.pdf A Privacy-First Event Platform for the European PostgreSQL Community] (Pavlo Golub, Sergey Chehuta Cloomba)

	16:15: Discussion		16:15: Discussion

	=== Notes ===		=== Notes ===

File:Intro New PostgreSQL Community Members Summit.pdf

Ads — Sat, 07 Nov 2026 00:12:04 GMT

Ads uploaded File:Intro New PostgreSQL Community Members Summit.pdf

New page

PostgreSQL 19 Open Items

Adunstan — Fri, 06 Nov 2026 20:07:57 GMT

revert JSON_ARRAY()/JSON_OBJECT() expression indexes accepted since ecd9288624a can go stale

← Older revision		Revision as of 20:07, 6 November 2026
Line 25:		Line 25:
	** Commit: {{PgCommitURL\|45762084545}}, {{PgCommitURL\|ba21f5bf8af}}		** Commit: {{PgCommitURL\|45762084545}}, {{PgCommitURL\|ba21f5bf8af}}
	** Owner: Tom Lane, Masahiko Sawada		** Owner: Tom Lane, Masahiko Sawada

	* {{messageLink\|1=179372513496.2500379.6217138376932454060@gmail.com\|2=JSON_ARRAY()/JSON_OBJECT() expression indexes accepted since ecd9288624a can go stale}}
	** Commit: {{PgCommitURL\|ecd9288624a}}
	** Owner: Andrew Dunstan

	* [https://www.postgresql.org/message-id/CABPTF7XekTZiMrzDVjW9mdBZMm_9E_8+FvA=nzsPfqvbysxXyA@mail.gmail.com test: avoid redundant standby catchup in 049_wait_for_lsn]		* [https://www.postgresql.org/message-id/CABPTF7XekTZiMrzDVjW9mdBZMm_9E_8+FvA=nzsPfqvbysxXyA@mail.gmail.com test: avoid redundant standby catchup in 049_wait_for_lsn]
Line 139:		Line 135:
	** Owner: Tatsuo Ishii		** Owner: Tatsuo Ishii
	** Fix: {{PgCommitURL\|24f39139668}}		** Fix: {{PgCommitURL\|24f39139668}}

			* {{messageLink\|1=179372513496.2500379.6217138376932454060@gmail.com\|2=JSON_ARRAY()/JSON_OBJECT() expression indexes accepted since ecd9288624a can go stale}}
			** Commit: {{PgCommitURL\|ecd9288624a}}
			** Owner: Andrew Dunstan
			** Fix: {{PgCommitURL\|4b80cba35a1}} (reverted)

	=== resolved before 19rc1 ===		=== resolved before 19rc1 ===

Known Buildfarm Test Failures

Law — Fri, 06 Nov 2026 17:53:36 GMT

003_standby_restarts.pl is unstable with slow xlog flush

@@ Line 2,351: / Line 2,351: @@
 Other occurrences:<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=thorntail&dt=2026-10-31%2006%3A31%3A25 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=thorntail&dt=2026-10-31%2006%3A31%3A25 - master]<br/>
 {{messageLink|93b93478-6624-43f8-b4d4-c743d73ad1d0%40gmail.com|Stabilize and shorten test_checksums/013_rewind test \ stability issues with 003_standby_restarts.pl}}
 ----
@@ Line 2,484: / Line 2,447: @@
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-10-30%2016%3A07%3A27 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-10-30%2016%3A07%3A27 - REL_15_STABLE]<br/>
 [https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-11-04%2014%3A00%3A05 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=greenfly&dt=2026-11-04%2014%3A00%3A05 - REL_14_STABLE]<br/>
@@ Line 8,695: / Line 8,659: @@
 [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=590788ad0 Improve stability of authentication test 007_pre_auth]
 ----