apache-airflow-providers-postgres

Changelog¶

6.0.0¶

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¶

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¶

Misc¶

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

5.13.0¶

Features¶

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

Misc¶

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

5.12.0¶

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¶

Misc¶

Clean up remaining getattr connection DbApiHook (#40665)

5.11.2¶

Misc¶

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

5.11.1¶

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¶

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¶

Misc¶

Implement AIP-60 Dataset URI formats (#37005)

5.10.1¶

Misc¶

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

5.10.0¶

Features¶

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

Bug Fixes¶

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

5.9.0¶

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¶

Features¶

Refactor cursor retrieval in PostgresHook. (#35498)

5.7.1¶

Bug Fixes¶

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

5.7.0¶

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¶

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¶

Features¶

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

Misc¶

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

5.5.2¶

Misc¶

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

5.5.1¶

Note

This release dropped support for Python 3.7

Misc¶

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

5.5.0¶

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¶

Features¶

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

5.3.1¶

Bug Fixes¶

Bump common.sql provider to 1.3.1 (#27888)

5.3.0¶

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¶

Misc¶

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

5.2.1¶

Bug Fixes¶

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

5.2.0¶

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¶

Features¶

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

5.0.0¶

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¶

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¶

Misc¶

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

4.0.0¶

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¶

Features¶

19489 - Pass client_encoding for postgres connections (#19827)
Amazon provider remove deprecation, second try (#19815)

Bug Fixes¶

2.3.0¶

Features¶

Added upsert method on S3ToRedshift operator (#18027)

Bug Fixes¶

Fix example dag of PostgresOperator (#18236)

2.2.0¶

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¶

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¶

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

1.0.1¶

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

1.0.0¶

Initial version of the provider.