apache-airflow-providers-postgres

Changelog

6.5.1

Release Date: 2025-12-13

Misc

  • Add backcompat for exceptions in providers (#58727)

6.5.0

Release Date: 2025-11-30

Note

This release of provider is only available for Airflow 2.11+ as explained in the Apache Airflow providers support policy <https://github.com/apache/airflow/blob/main/PROVIDERS.rst#minimum-supported-version-of-airflow-for-community-managed-providers>_.

Misc

  • Bump minimum Airflow version in providers to Airflow 2.11.0 (#58612)

6.4.1

Release Date: 2025-11-17

Misc

  • Convert all airflow distributions to be compliant with ASF requirements (#58138)

  • better error handling in SnowflakeHook and PostgresHook when old version of AzureBaseHook (#57184)

6.4.0

Release Date: 2025-10-26

Features

  • Add Azure IAM/Entra ID support for PostgresHook (#55729)

Misc

  • fix mypy type errors in common/sql provider for sqlalchemy 2 upgrade (#56824)

  • Migrate postgres provider to ''common.compat'' (#57022)

Doc-only

  • Remove placeholder Release Date in changelog and index files (#56056)

6.3.0

Release Date: 2025-09-09

Features

  • Added specialized insert_rows in PostgresHook which uses faster psycopg execute_batch method (#54988)

  • Add rudimentary support for psycopg3 (#52976)

  • Implemented native get_column_names in PostgresDialect to become SQLAlchemy independent (#54437)

Bug Fixes

  • PostgresDialect should use index instead of name in get_column_names and get_primary_keys (#54832)

Misc

  • Add CI support for SQLAlchemy 2.0 (#52233)

Doc-only

  • Make term Dag consistent in providers docs (#55101)

6.2.3

Release Date: 2025-08-11

Bug Fixes

  • Fix the PostgresHook ignoring custom adapters registered (#53707)

6.2.2

Release Date: 2025-08-02

Bug Fixes

  • fix(postgres/hooks): ensure get_df uses SQLAlchemy engine to avoid pandas warning (#52224)

Misc

  • Add Python 3.13 support for Airflow. (#46891)

  • Cleanup type ignores in postgres provider where possible (#53275)

  • Remove type ignore across codebase after mypy upgrade (#53243)

  • Remove upper-binding for "python-requires" (#52980)

  • Temporarily switch to use >=,< pattern instead of '~=' (#52967)

6.2.1

Release Date: 2025-07-06

Misc

  • Move 'BaseHook' implementation to task SDK (#51873)

  • Disable UP038 ruff rule and revert mandatory 'X | Y' in insintance checks (#52644)

  • Drop support for Python 3.9 (#52072)

6.2.0

Release Date: 2025-05-18

Note

This release of provider is only available for Airflow 2.10+ as explained in the Apache Airflow providers support policy <https://github.com/apache/airflow/blob/main/PROVIDERS.rst#minimum-supported-version-of-airflow-for-community-managed-providers>_.

Misc

  • Bump min Airflow version in providers to 2.10 (#49843)

6.1.3

Release Date: 2025-04-19

Bug Fixes

  • Fix PostgresHook Json serialization (#49120)

Misc

  • remove superfluous else block (#49199)

6.1.2

Release Date: 2025-04-09

Misc

  • Update minimum version of common.sql provider to 1.23.0 (#48416)

6.1.1

Release Date: 2025-03-13

Misc

  • Upgrade flit to 3.11.0 (#46938)

6.1.0

Release Date: 2025-02-26

Features

  • Introduce notion of dialects in DbApiHook (#41327)

Bug Fixes

  • Fix escaping of special characters or reserved words as column names in dialects of common sql provider (#45640)

Misc

  • Bump psycopg2 to 2.9.9 to possibly avoid crash on Python 3.12 (#46431)

  • Added ADR document describing why the notion of dialects is introduced (#45456)

  • Bump minimum version of psycopg2-binary to 2.9.7 (#45635)

6.0.0

Release Date: 2024-12-26

Note

This release of provider is only available for Airflow 2.9+ as explained in the Apache Airflow providers support policy.

Breaking changes

Warning

All deprecated classes, parameters and features have been removed from the Postgres provider package. The following breaking changes were introduced:

  • Hooks

    • The schema arg has been renamed to database as it contained the database name. Deprecated parameters, getters and setters have been removed. Please use database to set the database name.

  • Operators

    • Remove airflow.providers.postgres.operators.postgres.PostgresOperator. Please use airflow.providers.common.sql.operators.sql.SQLExecuteQueryOperator instead.

  • Remove Provider Deprecations in Postgres (#44705)

Misc

  • Bump minimum Airflow version in providers to Airflow 2.9.0 (#44956)

  • Update DAG example links in multiple providers documents (#44034)

  • Add basic asyncio support (#43944)

5.14.0

Release Date: 2024-11-18

Features

  • Add AWS Redshift Serverless support to PostgresHook (#43669)

Bug Fixes

  • Fix PostgresHook bug when getting AWS Redshift Serverless credentials (#43807)

Misc

  • Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)

5.13.1

Release Date: 2024-10-14

Misc

  • Rename dataset related python variable names to asset (#41348)

5.13.0

Release Date: 2024-09-24

Features

  • feat: log client db messages for provider postgres (#40171)

Misc

  • Generalize caching of connection in DbApiHook to improve performance (#40751)

5.12.0

Release Date: 2024-08-22

Note

This release of provider is only available for Airflow 2.8+ as explained in the Apache Airflow providers support policy.

Misc

  • Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)

5.11.3

Release Date: 2024-08-06

Misc

  • Clean up remaining getattr connection DbApiHook (#40665)

5.11.2

Release Date: 2024-06-27

Misc

  • implement per-provider tests with lowest-direct dependency resolution (#39946)

5.11.1

Release Date: 2024-05-30

Bug Fixes

  • fix: use 'sqlalchemy_url' property in 'get_uri' for postgresql provider (#38831)

Misc

  • Faster 'airflow_version' imports (#39552)

  • Simplify 'airflow_version' imports (#39497)

5.11.0

Release Date: 2024-05-06

Note

This release of provider is only available for Airflow 2.7+ as explained in the Apache Airflow providers support policy.

Bug Fixes

  • Fix schema assigment in PostgresOperator (#39264)

Misc

  • Bump minimum Airflow version in providers to Airflow 2.7.0 (#39240)

  • Always use the executemany method when inserting rows in DbApiHook as it's way much faster (#38715)

5.10.2

Release Date: 2024-03-08

Misc

  • Implement AIP-60 Dataset URI formats (#37005)

5.10.1

Release Date: 2024-02-15

Misc

  • feat: Switch all class, functions, methods deprecations to decorators (#36876)

5.10.0

Release Date: 2023-12-27

Features

  • Make "placeholder" of ODBC configurable in UI (#36000)

Bug Fixes

  • Follow BaseHook connection fields method signature in child classes (#36086)

5.9.0

Release Date: 2023-12-12

Note

This release of provider is only available for Airflow 2.6+ as explained in the Apache Airflow providers support policy.

Misc

  • Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)

5.8.0

Release Date: 2023-11-12

Features

  • Refactor cursor retrieval in PostgresHook. (#35498)

5.7.1

Release Date: 2023-10-21

Bug Fixes

  • 'PostgresOperator' should not overwrite 'SQLExecuteQueryOperator.template_fields' (#34969)

5.7.0

Release Date: 2023-10-17

Note

This release of provider is only available for Airflow 2.5+ as explained in the Apache Airflow providers support policy.

Features

  • Add 'get_ui_field_behaviour()' method to PostgresHook (#34811)

Misc

  • Bump min airflow version of providers (#34728)

5.6.1

Release Date: 2023-09-12

Misc

  • Improve modules import in Airflow providers by some of them into a type-checking block (#33754)

  • Use a single  statement with multiple contexts instead of nested  statements in providers (#33768)

  • Use literal dict instead of calling dict() in providers (#33761)

5.6.0

Release Date: 2023-08-01

Features

  • openlineage, postgres: add OpenLineage support for Postgres (#31617)

Misc

  • Add deprecation info to the providers modules and classes docstring (#32536)

5.5.2

Release Date: 2023-07-09

Misc

  • Deprecate 'runtime_parameters' in favor of options in 'hook_params' (#32345)

5.5.1

Release Date: 2023-06-23

Note

This release dropped support for Python 3.7

Misc

  • Add note about dropping Python 3.7 for providers (#32015)

5.5.0

Release Date: 2023-05-22

Note

This release of provider is only available for Airflow 2.4+ as explained in the Apache Airflow providers support policy.

Misc

  • Bump minimum Airflow version in providers (#30917)

5.4.0

Release Date: 2023-01-05

Features

  • Bring back psycopg2-binary as dependency instead of psycopg (#28316)

5.3.1

Release Date: 2022-11-29

Bug Fixes

  • Bump common.sql provider to 1.3.1 (#27888)

5.3.0

Release Date: 2022-11-18

Note

This release of provider is only available for Airflow 2.3+ as explained in the Apache Airflow providers support policy.

Misc

  • Move min airflow version to 2.3.0 for all providers (#27196)

Features

  • PostgresHook: Added ON CONFLICT DO NOTHING statement when all target fields are primary keys (#26661)

  • Add SQLExecuteQueryOperator (#25717)

  • Rename schema to database in PostgresHook (#26744)

5.2.2

Release Date: 2022-10-01

Misc

  • Add common-sql lower bound for common-sql (#25789)

5.2.1

Release Date: 2022-09-08

Bug Fixes

  • Bump dep on common-sql to fix issue with SQLTableCheckOperator (#26143)

5.2.0

Release Date: 2022-08-14

Features

  • Use only public AwsHook's methods during IAM authorization (#25424)

  • Unify DbApiHook.run() method with the methods which override it (#23971)

5.1.0

Release Date: 2022-07-16

Features

  • Move all SQL classes to common-sql provider (#24836)

5.0.0

Release Date: 2022-06-13

Breaking changes

Note

This release of provider is only available for Airflow 2.2+ as explained in the Apache Airflow providers support policy.

4.1.0

Release Date: 2022-03-26

Features

  • adds ability to pass config params to postgres operator (#21551)

Bug Fixes

  • Fix mistakenly added install_requires for all providers (#22382)

4.0.1

Release Date: 2022-03-19

Misc

  • Add Trove classifiers in PyPI (Framework :: Apache Airflow :: Provider)

4.0.0

Release Date: 2022-03-10

The URIs returned by Postgres get_uri() returns postgresql:// instead of postgres:// prefix which is the only supported prefix for the SQLAlchemy 1.4.0+. Any usage of get_uri() where postgres:// prefix should be updated to reflect it.

Breaking changes

  • Replaces the usage of postgres:// with postgresql:// (#21205)

Features

  • Add more SQL template fields renderers (#21237)

  • Add conditional 'template_fields_renderers' check for new SQL lexers (#21403)

Misc

  • Support for Python 3.10

3.0.1

Misc

  • Make DbApiHook use get_uri from Connection (#21764)

2.4.0

Release Date: 2021-12-06

Features

  • 19489 - Pass client_encoding for postgres connections (#19827)

  • Amazon provider remove deprecation, second try (#19815)

Bug Fixes

2.3.0

Release Date: 2021-10-05

Features

  • Added upsert method on S3ToRedshift operator (#18027)

Bug Fixes

  • Fix example dag of PostgresOperator (#18236)

2.2.0

Release Date: 2021-09-03

Features

  • Make schema in DBApiHook private (#17423)

Misc

  • Optimise connection importing for Airflow 2.2.0

2.1.0 (YANKED)

Warning

This release has been yanked with a reason: The postgres operator seem to conflict with earlier versions of Airflow

Features

  • Add schema as DbApiHook instance attribute (#16521)

2.0.0

Release Date: 2021-06-23

Breaking changes

  • Auto-apply apply_default decorator (#15667)

Warning

Due to apply_default decorator removal, this version of the provider requires Airflow 2.1.0+. If your Airflow version is < 2.1.0, and you want to install this provider version, first upgrade Airflow to at least version 2.1.0. Otherwise your Airflow package version will be upgraded automatically and you will have to manually run airflow upgrade db to complete the migration.

Features

  • PostgresHook: deepcopy connection to avoid mutating connection obj (#15412)

  • postgres_hook_aws_conn_id (#16100)

1.0.2

Release Date: 2021-05-06

  • Do not forward cluster-identifier to psycopg2 (#15360)

1.0.1

Release Date: 2021-02-08

Updated documentation and readme files. Added HowTo guide for Postgres Operator.

1.0.0

Release Date: 2020-12-14

Initial version of the provider.

Was this entry helpful?