NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI, #3991 most downloaded on PyPI
Provider package apache-airflow-providers-postgres for Apache Airflow
Latest stable
7.1.2
Last release 12 days ago
09 Nov 2026
Ships fairly regularly
a new release about every 2 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
1 version withdrawn
withdrawn after publishing
6 years old
154 releases · first in 2020
Drag across the ruler to compare, or tap a release to open it.
All deprecated classes, parameters and features have been removed from the Postgres provider package. The following breaking changes were introduced:
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 .
Warning
All deprecated classes, parameters and features have been removed from the Postgres provider package. The following breaking changes were introduced:
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.
Remove airflow.providers.postgres.operators.postgres.PostgresOperator . Please use airflow.providers.common.sql.operators.sql.SQLExecuteQueryOperator instead.
Remove Provider Deprecations in Postgres (#44705)
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)
Note
This release of provider is only available for Airflow 2.9+ as explained in the Apache Airflow providers support policy.
Warning
All deprecated classes, parameters and features have been removed from the Postgres provider package. The following breaking changes were introduced:
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.
Remove airflow.providers.postgres.operators.postgres.PostgresOperator. Please use airflow.providers.common.sql.operators.sql.SQLExecuteQueryOperator instead.
Remove Provider Deprecations in Postgres (#44705)
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)
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Nothing published for this version
Nothing published for this version
- Add AWS Redshift Serverless support to PostgresHook
Release Date: 2024-11-18
Add AWS Redshift Serverless support to PostgresHook (#43669)
Fix PostgresHook bug when getting AWS Redshift Serverless credentials (#43807)
Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)
Add AWS Redshift Serverless support to PostgresHook (#43669)
Fix PostgresHook bug when getting AWS Redshift Serverless credentials (#43807)
Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)
Nothing published for this version
- Rename dataset related python variable names to asset
Release Date: 2024-10-14
Rename dataset related python variable names to asset (#41348)
Nothing published for this version
- feat: log client db messages for provider postgres
Release Date: 2024-09-24
feat: log client db messages for provider postgres (#40171)
Generalize caching of connection in DbApiHook to improve performance (#40751)
feat: log client db messages for provider postgres (#40171)
Generalize caching of connection in DbApiHook to improve performance (#40751)
Nothing published for this version
This release of provider is only available for Airflow 2.8+ as explained in the Apache Airflow providers support policy .
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 .
Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)
Note
This release of provider is only available for Airflow 2.8+ as explained in the Apache Airflow providers support policy.
Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)
Nothing published for this version
- Clean up remaining getattr connection DbApiHook
Release Date: 2024-08-06
Clean up remaining getattr connection DbApiHook (#40665)
Nothing published for this version
- implement per-provider tests with lowest-direct dependency resolution
Release Date: 2024-06-27
implement per-provider tests with lowest-direct dependency resolution (#39946)
Nothing published for this version
- fix: use 'sqlalchemy_url' property in 'get_uri' for postgresql provider
Release Date: 2024-05-30
fix: use 'sqlalchemy_url' property in 'get_uri' for postgresql provider (#38831)
Faster 'airflow_version' imports (#39552)
Simplify 'airflow_version' imports (#39497)
fix: use 'sqlalchemy_url' property in 'get_uri' for postgresql provider (#38831)
Faster 'airflow_version' imports (#39552)
Simplify 'airflow_version' imports (#39497)
Nothing published for this version
This release of provider is only available for Airflow 2.7+ as explained in the Apache Airflow providers support policy .
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 .
Fix schema assigment in PostgresOperator (#39264)
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)
Note
This release of provider is only available for Airflow 2.7+ as explained in the Apache Airflow providers support policy.
Fix schema assigment in PostgresOperator (#39264)
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)
Nothing published for this version
- Implement AIP-60 Dataset URI formats
Release Date: 2024-03-08
Implement AIP-60 Dataset URI formats (#37005)
Nothing published for this version
- feat: Switch all class, functions, methods deprecations to decorators
Release Date: 2024-02-15
feat: Switch all class, functions, methods deprecations to decorators (#36876)
feat: Switch all class, functions, methods deprecations to decorators (#36876)
Nothing published for this version
- Make "placeholder" of ODBC configurable in UI
Release Date: 2023-12-27
Make "placeholder" of ODBC configurable in UI (#36000)
Follow BaseHook connection fields method signature in child classes (#36086)
Make "placeholder" of ODBC configurable in UI (#36000)
Follow BaseHook connection fields method signature in child classes (#36086)
Nothing published for this version
This release of provider is only available for Airflow 2.6+ as explained in the Apache Airflow providers support policy .
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 .
Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)
Note
This release of provider is only available for Airflow 2.6+ as explained in the Apache Airflow providers support policy.
Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)
Nothing published for this version
- Refactor cursor retrieval in PostgresHook.
Release Date: 2023-11-12
Refactor cursor retrieval in PostgresHook. (#35498)
Nothing published for this version
- 'PostgresOperator' should not overwrite 'SQLExecuteQueryOperator.template_fields'
Release Date: 2023-10-21
'PostgresOperator' should not overwrite 'SQLExecuteQueryOperator.template_fields' (#34969)
Nothing published for this version
This release of provider is only available for Airflow 2.5+ as explained in the Apache Airflow providers support policy .
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 .
Add 'get_ui_field_behaviour()' method to PostgresHook (#34811)
Bump min airflow version of providers (#34728)
Nothing published for this version
- Improve modules import in Airflow providers by some of them into a type-checking block
Release Date: 2023-09-12
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)
Nothing published for this version
- Add deprecation info to the providers modules and classes docstring
Release Date: 2023-08-01
openlineage, postgres: add OpenLineage support for Postgres (#31617)
Add deprecation info to the providers modules and classes docstring (#32536)
Nothing published for this version
- Deprecate 'runtime_parameters' in favor of options in 'hook_params'
Release Date: 2023-07-09
Deprecate 'runtime_parameters' in favor of options in 'hook_params' (#32345)
Deprecate 'runtime_parameters' in favor of options in 'hook_params' (#32345)
Nothing published for this version
This release dropped support for Python 3.7
Release Date: 2023-06-23
Note
This release dropped support for Python 3.7
Add note about dropping Python 3.7 for providers (#32015)
Note
This release dropped support for Python 3.7
Add note about dropping Python 3.7 for providers (#32015)
Nothing published for this version
This release of provider is only available for Airflow 2.4+ as explained in the Apache Airflow providers support policy .
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 .
Bump minimum Airflow version in providers (#30917)
Note
This release of provider is only available for Airflow 2.4+ as explained in the Apache Airflow providers support policy.
Bump minimum Airflow version in providers (#30917)
Nothing published for this version
Nothing published for this version
- Bring back psycopg2-binary as dependency instead of psycopg
Release Date: 2023-01-05
Bring back psycopg2-binary as dependency instead of psycopg (#28316)
Bring back psycopg2-binary as dependency instead of psycopg (#28316)
Nothing published for this version
Nothing published for this version
- Bump common.sql provider to 1.3.1
Release Date: 2022-11-29
Bump common.sql provider to 1.3.1 (#27888)
Nothing published for this version
Nothing published for this version
This release of provider is only available for Airflow 2.3+ as explained in the Apache Airflow providers support policy .
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 .
Move min airflow version to 2.3.0 for all providers (#27196)
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)
Note
This release of provider is only available for Airflow 2.3+ as explained in the Apache Airflow providers support policy.
Move min airflow version to 2.3.0 for all providers (#27196)
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)
Nothing published for this version
- Add common-sql lower bound for common-sql
Release Date: 2022-10-01
Add common-sql lower bound for common-sql (#25789)
Nothing published for this version
- Bump dep on common-sql to fix issue with SQLTableCheckOperator
Release Date: 2022-09-08
Bump dep on common-sql to fix issue with SQLTableCheckOperator (#26143)
Bump dep on common-sql to fix issue with SQLTableCheckOperator (#26143)
Nothing published for this version
- Use only public AwsHook's methods during IAM authorization
Release Date: 2022-08-14
Use only public AwsHook's methods during IAM authorization (#25424)
Unify DbApiHook.run() method with the methods which override it (#23971)
Nothing published for this version
Nothing published for this version
Nothing published for this version
One column per quarter.