You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by po...@apache.org on 2021/12/05 23:04:48 UTC

[airflow] branch main updated: Remove postgres 9.6 support (#19987)

This is an automated email from the ASF dual-hosted git repository.

potiuk pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/airflow.git


The following commit(s) were added to refs/heads/main by this push:
     new a299cbf  Remove postgres 9.6 support (#19987)
a299cbf is described below

commit a299cbf4ce95af49132a6c7b17cd6a0355544836
Author: raphaelauv <ra...@users.noreply.github.com>
AuthorDate: Mon Dec 6 00:04:01 2021 +0100

    Remove postgres 9.6 support (#19987)
---
 BREEZE.rst                                         |  4 ++--
 PULL_REQUEST_WORKFLOW.rst                          |  4 ++--
 README.md                                          | 16 ++++++++--------
 TESTING.rst                                        |  4 ++--
 breeze-complete                                    |  2 +-
 docs/apache-airflow/concepts/scheduler.rst         |  4 ++--
 docs/apache-airflow/howto/set-up-database.rst      |  2 +-
 docs/apache-airflow/installation/prerequisites.rst |  2 +-
 scripts/ci/libraries/_initialization.sh            |  2 +-
 9 files changed, 20 insertions(+), 20 deletions(-)

diff --git a/BREEZE.rst b/BREEZE.rst
index af032a6..c548bc2 100644
--- a/BREEZE.rst
+++ b/BREEZE.rst
@@ -1840,7 +1840,7 @@ This is the current syntax for  `./breeze <./breeze>`_:
   --postgres-version POSTGRES_VERSION
           Postgres version used. One of:
 
-                 9.6 10 11 12 13
+                 10 11 12 13
 
   --mysql-version MYSQL_VERSION
           MySql version used. One of:
@@ -2320,7 +2320,7 @@ This is the current syntax for  `./breeze <./breeze>`_:
   --postgres-version POSTGRES_VERSION
           Postgres version used. One of:
 
-                 9.6 10 11 12 13
+                 10 11 12 13
 
   --mysql-version MYSQL_VERSION
           MySql version used. One of:
diff --git a/PULL_REQUEST_WORKFLOW.rst b/PULL_REQUEST_WORKFLOW.rst
index b18b980..379ede8 100644
--- a/PULL_REQUEST_WORKFLOW.rst
+++ b/PULL_REQUEST_WORKFLOW.rst
@@ -60,10 +60,10 @@ We approached the problem by:
 
    * Python versions (currently 3.6, 3.7, 3.8, 3.9)
    * Backend types (currently MySQL/Postgres)
-   * Backed version (currently MySQL 5.7, MySQL 8, Postgres 9.6, Postgres 13
+   * Backed version (currently MySQL 5.7, MySQL 8, Postgres 13
 
    We've decided that instead of running all the combinations of parameters for all matrix component we will
-   only run default values (Python 3.6, Mysql 5.7, Postgres 9.6) for all PRs which are not approved yet by
+   only run default values (Python 3.6, Mysql 5.7, Postgres 13) for all PRs which are not approved yet by
    the committers. This has a nice effect, that full set of tests (though with limited combinations of
    the matrix) are still run in the CI for every Pull Request that needs tests at all - allowing the
    contributors to make sure that their PR is "good enough" to be reviewed.
diff --git a/README.md b/README.md
index 0f41586..60e923e 100644
--- a/README.md
+++ b/README.md
@@ -82,14 +82,14 @@ Airflow is not a streaming solution, but it is often used to process real-time d
 
 Apache Airflow is tested with:
 
-|                      | Main version (dev)        | Stable version (2.2.2)   |
-| -------------------- | ------------------------- | ------------------------ |
-| Python               | 3.6, 3.7, 3.8, 3.9        | 3.6, 3.7, 3.8, 3.9       |
-| Kubernetes           | 1.20, 1.21                | 1.18, 1.19, 1.20         |
-| PostgreSQL           | 9.6, 10, 11, 12, 13       | 9.6, 10, 11, 12, 13      |
-| MySQL                | 5.7, 8                    | 5.7, 8                   |
-| SQLite               | 3.15.0+                   | 3.15.0+                  |
-| MSSQL(Experimental)  | 2017, 2019                |                          |
+|                      | Main version (dev)   | Stable version (2.2.2)   |
+| -------------------- | -------------------- | ------------------------ |
+| Python               | 3.6, 3.7, 3.8, 3.9   | 3.6, 3.7, 3.8, 3.9       |
+| Kubernetes           | 1.20, 1.21           | 1.18, 1.19, 1.20         |
+| PostgreSQL           | 10, 11, 12, 13       | 9.6, 10, 11, 12, 13      |
+| MySQL                | 5.7, 8               | 5.7, 8                   |
+| SQLite               | 3.15.0+              | 3.15.0+                  |
+| MSSQL(Experimental)  | 2017, 2019           |                          |
 
 **Note**: MySQL 5.x versions are unable to or have limitations with
 running multiple schedulers -- please see the [Scheduler docs](https://airflow.apache.org/docs/apache-airflow/stable/scheduler.html).
diff --git a/TESTING.rst b/TESTING.rst
index 41545e6..fa826f4 100644
--- a/TESTING.rst
+++ b/TESTING.rst
@@ -758,7 +758,7 @@ The typical session for tests with Kubernetes looks like follows:
 
        Airflow source version:  2.0.0.dev0
        Python version:          3.7
-       Backend:                 postgres 9.6
+       Backend:                 postgres 10
 
     No kind clusters found.
 
@@ -798,7 +798,7 @@ The typical session for tests with Kubernetes looks like follows:
 
        Airflow source version:  2.0.0.dev0
        Python version:          3.7
-       Backend:                 postgres 9.6
+       Backend:                 postgres 10
 
     airflow-python-3.7-v1.17.0-control-plane
     airflow-python-3.7-v1.17.0-worker
diff --git a/breeze-complete b/breeze-complete
index 8606e60..a494ce2 100644
--- a/breeze-complete
+++ b/breeze-complete
@@ -33,7 +33,7 @@ _breeze_allowed_helm_versions="v3.6.3"
 _breeze_allowed_kind_versions="v0.11.1"
 _breeze_allowed_mysql_versions="5.7 8"
 _breeze_allowed_mssql_versions="2017-latest 2019-latest"
-_breeze_allowed_postgres_versions="9.6 10 11 12 13"
+_breeze_allowed_postgres_versions="10 11 12 13"
 _breeze_allowed_kind_operations="start stop restart status deploy test shell k9s"
 _breeze_allowed_executors="KubernetesExecutor CeleryExecutor LocalExecutor CeleryKubernetesExecutor"
 _breeze_allowed_test_types="All Always Core Providers API CLI Integration Other WWW Postgres MySQL Helm Quarantined"
diff --git a/docs/apache-airflow/concepts/scheduler.rst b/docs/apache-airflow/concepts/scheduler.rst
index a66a605..e96de09 100644
--- a/docs/apache-airflow/concepts/scheduler.rst
+++ b/docs/apache-airflow/concepts/scheduler.rst
@@ -130,7 +130,7 @@ This does however place some requirements on the Database.
 Database Requirements
 """""""""""""""""""""
 
-The short version is that users of PostgreSQL 9.6+ or MySQL 8+ are all ready to go -- you can start running as
+The short version is that users of PostgreSQL 10+ or MySQL 8+ are all ready to go -- you can start running as
 many copies of the scheduler as you like -- there is no further set up or config options needed. If you are
 using a different database please read on.
 
@@ -146,7 +146,7 @@ UPDATE NOWAIT`` but the exact query is slightly different).
 
 The following databases are fully supported and provide an "optimal" experience:
 
-- PostgreSQL 9.6+
+- PostgreSQL 10+
 - MySQL 8+
 
 .. warning::
diff --git a/docs/apache-airflow/howto/set-up-database.rst b/docs/apache-airflow/howto/set-up-database.rst
index d41fa3e..e2f49d9 100644
--- a/docs/apache-airflow/howto/set-up-database.rst
+++ b/docs/apache-airflow/howto/set-up-database.rst
@@ -32,7 +32,7 @@ By default, Airflow uses **SQLite**, which is intended for development purposes
 
 Airflow supports the following database engine versions, so make sure which version you have. Old versions may not support all SQL statements.
 
-* PostgreSQL:  9.6, 10, 11, 12, 13
+* PostgreSQL: 10, 11, 12, 13
 * MySQL: 5.7, 8
 * MsSQL: 2017, 2019
 * SQLite: 3.15.0+
diff --git a/docs/apache-airflow/installation/prerequisites.rst b/docs/apache-airflow/installation/prerequisites.rst
index 6b703bc..5b878ec 100644
--- a/docs/apache-airflow/installation/prerequisites.rst
+++ b/docs/apache-airflow/installation/prerequisites.rst
@@ -24,7 +24,7 @@ Airflow is tested with:
 
 * Databases:
 
-  * PostgreSQL:  9.6, 10, 11, 12, 13
+  * PostgreSQL: 10, 11, 12, 13
   * MySQL: 5.7, 8
   * SQLite: 3.15.0+
   * MSSQL(Experimental): 2017, 2019
diff --git a/scripts/ci/libraries/_initialization.sh b/scripts/ci/libraries/_initialization.sh
index c819bb4..6ef0559 100644
--- a/scripts/ci/libraries/_initialization.sh
+++ b/scripts/ci/libraries/_initialization.sh
@@ -115,7 +115,7 @@ function initialization::initialize_base_variables() {
     export CURRENT_PYTHON_MAJOR_MINOR_VERSIONS
 
     # Currently supported versions of Postgres
-    CURRENT_POSTGRES_VERSIONS+=("9.6" "13")
+    CURRENT_POSTGRES_VERSIONS+=("10" "13")
     export CURRENT_POSTGRES_VERSIONS
 
     # Currently supported versions of MySQL