Skip to main content

Provider for Apache Airflow. Implements apache-airflow-providers-postgres package

Project description

Package apache-airflow-providers-postgres

Release: 5.3.0

PostgreSQL

Provider package

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

You can find package information and changelog for the provider in the documentation.

Installation

You can install this package on top of an existing Airflow 2 installation (see Requirements below for the minimum Airflow version supported) via pip install apache-airflow-providers-postgres

The package supports the following python versions: 3.7,3.8,3.9,3.10

Requirements

PIP package

Version required

apache-airflow

>=2.3.0

apache-airflow-providers-common-sql

>=1.3.0

psycopg2

>=2.8.0

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

apache-airflow-providers-common-sql

common.sql

Changelog

5.3.0

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

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

Features

  • Add schema as DbApiHook instance attribute (#16521)

2.0.0

Breaking changes

  • Auto-apply apply_default decorator (#15667)

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.

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

apache-airflow-providers-postgres-5.3.0.tar.gz (19.2 kB view hashes)

Uploaded Source

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page