`apache-airflow-providers-postgres`¶

Content¶

Guides

References

Python API

Resources

Example DAGs

Resources

Commits

Detailed list of commits

Package apache-airflow-providers-postgres¶

PostgreSQL

Release: 4.0.0

Provider package¶

This is a provider package for postgres provider. All classes for this provider package are in airflow.providers.postgres python package.

Installation¶

You can install this package on top of an existing Airflow 2.1+ installation via pip install apache-airflow-providers-postgres

PIP requirements¶

PIP package	Version required
`apache-airflow`	`>=2.1.0`
`psycopg2-binary`	`>=2.7.4`

Cross provider package dependencies¶

Those are dependencies that might be needed in order to use all the features of the package. You need to install the specified provider packages in order to use them.

You can install such cross-provider dependencies when installing from PyPI. For example:

pip install apache-airflow-providers-postgres[amazon]

Dependent package	Extra
apache-airflow-providers-amazon	`amazon`

Downloading official packages¶

You can download officially released packages and verify their checksums and signatures from the Official Apache Download site

Changelog¶

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¶

Breaking changes¶

Features¶

Bug Fixes¶

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¶

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.