The new client vertx-pg-client) is shipped by default with vert.x 3.8, RMB however pins the client version to the custom vertx-mysql-postgresql-client 3.5.1-FOLIO.1 (which fixes some connection sharing issues we have discovered with the client). The old client is still supported and available with vertx 3.8.

Vert.x 4 will remove support for the old client. Vertx 4 milestone 1 announcement page: https://vertx.io/blog/eclipse-vert-x-4-milestone-1-released/

Vert.x will stop its LTS support for the old Postgres/MySQL client 12/2020.

Both the old and the new client are dedicated, non-blocking Postgres clients that support batch inserts and streaming selects. Only the new supports streaming inserts/updates.

Migration includes changing the code to use the new prepared statement syntax using $1 instead of ? (see also rejected feature request).

*See"

• New recommended client: https://vertx.io/docs/vertx-pg-client/java/

  • Batch insert: https://vertx.io/docs/vertx-pg-client/java/#_prepared_queries , https://vertx.io/docs/vertx-pg-client/java/#_batches

  • Streaming select: https://vertx.io/docs/vertx-pg-client/java/#_cursors_and_streaming

  • Prepared statement with streaming execute: https://vertx.io/docs/vertx-pg-client/java/#_using_connections

• Old deprecated client: http://vertx.io/docs/vertx-mysql-postgresql-client/java/

  • Batch insert: https://vertx.io/docs/vertx-sql-common/java/#_prepared_statement_updates , https://vertx.io/docs/vertx-sql-common/java/#_batch_operations

  • Streaming select: https://vertx.io/docs/vertx-sql-common/java/#_streaming

  • No support for prepared statement with streaming execute.

Migration guide should be prepared.