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 afc9ea869e8 Move PGVECTOR provider to new structure (#46051)
afc9ea869e8 is described below

commit afc9ea869e8b9240a59afafc401fb28153aa334c
Author: vatsrahul1001 <[email protected]>
AuthorDate: Mon Jan 27 01:33:57 2025 +0530

    Move PGVECTOR provider to new structure (#46051)
---
 .github/boring-cyborg.yml                          |  10 +-
 dev/breeze/tests/test_selective_checks.py          |   7 +-
 docs/.gitignore                                    |   2 +
 .../changelog.rst                                  |  25 ---
 .../changelog.rst                                  |  25 ---
 providers/pgvector/README.rst                      |  83 +++++++++
 .../docs}/.latest-doc-only-change.txt              |   0
 .../CHANGELOG.rst => pgvector/docs/changelog.rst}  |   0
 .../pgvector/docs}/commits.rst                     |   0
 .../pgvector/docs}/connections.rst                 |   0
 .../pgvector/docs}/index.rst                       |   0
 .../docs}/installing-providers-from-sources.rst    |   0
 .../pgvector/docs}/operators/pgvector.rst          |   2 +-
 .../pgvector/docs}/security.rst                    |   0
 .../airflow/providers => }/pgvector/provider.yaml  |   7 -
 providers/pgvector/pyproject.toml                  |  88 +++++++++
 .../src/airflow/providers/pgvector/LICENSE         | 201 +++++++++++++++++++++
 .../src/airflow/providers/pgvector/__init__.py     |   0
 .../providers/pgvector/get_provider_info.py        |  55 ++++++
 .../airflow/providers/pgvector/hooks/__init__.py   |   0
 .../airflow/providers/pgvector/hooks/pgvector.py   |   0
 .../providers/pgvector/operators/__init__.py       |   0
 .../providers/pgvector/operators/pgvector.py       |   3 +-
 .../__init__.py => pgvector/tests/conftest.py}     |  24 ++-
 .../tests/provider_tests}/__init__.py              |   1 +
 .../tests/provider_tests/pgvector}/__init__.py     |   0
 .../provider_tests/pgvector/hooks}/__init__.py     |   0
 .../pgvector/hooks/test_pgvector.py                |   0
 .../provider_tests/pgvector/operators}/__init__.py |   0
 .../pgvector/operators/test_pgvector.py            |   0
 .../tests/system/pgvector}/__init__.py             |   0
 .../tests/system/pgvector/example_pgvector.py      |   0
 .../system/pgvector/example_pgvector_openai.py     |   0
 providers/postgres/README.rst                      |  85 +++++++++
 .../docs}/.latest-doc-only-change.txt              |   0
 .../CHANGELOG.rst => postgres/docs/changelog.rst}  |   0
 .../postgres/docs}/commits.rst                     |   0
 .../postgres/docs}/connections/postgres.rst        |   0
 .../postgres/docs}/dialects.rst                    |   0
 .../postgres/docs}/index.rst                       |   0
 .../docs}/installing-providers-from-sources.rst    |   0
 .../postgres/docs/integration-logos}/Postgres.png  | Bin
 .../operators/postgres_operator_howto_guide.rst    |   6 +-
 .../postgres/docs}/redirects.txt                   |   0
 .../postgres/docs}/security.rst                    |   0
 .../airflow/providers => }/postgres/provider.yaml  |  13 +-
 providers/postgres/pyproject.toml                  |  90 +++++++++
 .../src/airflow/providers/postgres/LICENSE         | 201 +++++++++++++++++++++
 .../src/airflow/providers/postgres/__init__.py     |   0
 .../airflow/providers/postgres/assets}/__init__.py |   0
 .../airflow/providers/postgres/assets/postgres.py  |   0
 .../providers/postgres/dialects}/__init__.py       |   0
 .../providers/postgres/dialects/postgres.py        |   0
 .../providers/postgres/get_provider_info.py        | 125 +++++++++++++
 .../airflow/providers/postgres/hooks/__init__.py   |   0
 .../airflow/providers/postgres/hooks/postgres.py   |   0
 .../__init__.py => postgres/tests/conftest.py}     |  24 ++-
 .../tests/provider_tests}/__init__.py              |   1 +
 .../tests/provider_tests}/postgres/__init__.py     |   0
 .../provider_tests/postgres/assets}/__init__.py    |   0
 .../postgres/assets/test_postgres.py               |   0
 .../provider_tests/postgres/dialects}/__init__.py  |   0
 .../postgres/dialects/test_postgres.py             |   0
 .../provider_tests}/postgres/hooks/__init__.py     |   0
 .../postgres/hooks/test_postgres.py                |   0
 .../tests/system/postgres/__init__.py              |   0
 .../tests/system/postgres/example_postgres.py      |   0
 pyproject.toml                                     |   6 +
 scripts/ci/docker-compose/remove-sources.yml       |   2 +
 scripts/ci/docker-compose/tests-sources.yml        |   2 +
 70 files changed, 985 insertions(+), 103 deletions(-)

diff --git a/.github/boring-cyborg.yml b/.github/boring-cyborg.yml
index c2e66c56e71..9fda5f5be99 100644
--- a/.github/boring-cyborg.yml
+++ b/.github/boring-cyborg.yml
@@ -377,19 +377,13 @@ labelPRBasedOnFilePath:
     - providers/tests/system/papermill/**/*
 
   provider:pgvector:
-    - providers/src/airflow/providers/pgvector/**/*
-    - docs/apache-airflow-providers-pgvector/**/*
-    - providers/tests/pgvector/**/*
-    - providers/tests/system/pgvector/**/*
+    - providers/pgvector/**
 
   provider:pinecone:
     - providers/pinecone/**
 
   provider:postgres:
-    - providers/src/airflow/providers/postgres/**/*
-    - docs/apache-airflow-providers-postgres/**/*
-    - providers/tests/postgres/**/*
-    - providers/tests/system/postgres/**/*
+    - providers/postgres/**
 
   provider:presto:
     - providers/src/airflow/providers/presto/**/*
diff --git a/dev/breeze/tests/test_selective_checks.py 
b/dev/breeze/tests/test_selective_checks.py
index e46371e374e..4c710006ea4 100644
--- a/dev/breeze/tests/test_selective_checks.py
+++ b/dev/breeze/tests/test_selective_checks.py
@@ -309,7 +309,7 @@ def assert_outputs_are_printed(expected_outputs: dict[str, 
str], stderr: str):
             pytest.param(
                 (
                     "airflow/api/file.py",
-                    "providers/tests/postgres/file.py",
+                    "providers/postgres/tests/provider_tests/postgres/file.py",
                 ),
                 {
                     "selected-providers-list-as-string": "amazon common.compat 
common.sql fab google openlineage "
@@ -530,11 +530,10 @@ def assert_outputs_are_printed(expected_outputs: 
dict[str, str], stderr: str):
             pytest.param(
                 (
                     "chart/aaaa.txt",
-                    "providers/tests/postgres/file.py",
+                    "providers/postgres/tests/provider_tests/postgres/file.py",
                 ),
                 {
-                    "selected-providers-list-as-string": "amazon common.sql 
google openlineage "
-                    "pgvector postgres",
+                    "selected-providers-list-as-string": "amazon common.sql 
google openlineage pgvector postgres",
                     "all-python-versions": "['3.9']",
                     "all-python-versions-list-as-string": "3.9",
                     "python-versions": "['3.9']",
diff --git a/docs/.gitignore b/docs/.gitignore
index 881049660cc..f0b105b3f65 100644
--- a/docs/.gitignore
+++ b/docs/.gitignore
@@ -7,7 +7,9 @@ apache-airflow-providers-celery
 apache-airflow-providers-cohere
 apache-airflow-providers-common-sql
 apache-airflow-providers-edge
+apache-airflow-providers-pgvector
 apache-airflow-providers-pinecone
+apache-airflow-providers-postgres
 apache-airflow-providers-standard
 apache-airflow-providers-telegram
 apache-airflow-providers-weaviate
diff --git a/docs/apache-airflow-providers-pgvector/changelog.rst 
b/docs/apache-airflow-providers-pgvector/changelog.rst
deleted file mode 100644
index 15c377d7cfc..00000000000
--- a/docs/apache-airflow-providers-pgvector/changelog.rst
+++ /dev/null
@@ -1,25 +0,0 @@
-
- .. Licensed to the Apache Software Foundation (ASF) under one
-    or more contributor license agreements.  See the NOTICE file
-    distributed with this work for additional information
-    regarding copyright ownership.  The ASF licenses this file
-    to you under the Apache License, Version 2.0 (the
-    "License"); you may not use this file except in compliance
-    with the License.  You may obtain a copy of the License at
-
- ..   http://www.apache.org/licenses/LICENSE-2.0
-
- .. Unless required by applicable law or agreed to in writing,
-    software distributed under the License is distributed on an
-    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-    KIND, either express or implied.  See the License for the
-    specific language governing permissions and limitations
-    under the License.
-
- ..  NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE
-     OVERWRITTEN WHEN PREPARING PACKAGES.
-
- ..  IF YOU WANT TO MODIFY THIS FILE, YOU SHOULD MODIFY THE TEMPLATE
-     `PROVIDER_CHANGELOG_TEMPLATE.rst.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
-
-.. include:: ../../providers/src/airflow/providers/pgvector/CHANGELOG.rst
diff --git a/docs/apache-airflow-providers-postgres/changelog.rst 
b/docs/apache-airflow-providers-postgres/changelog.rst
deleted file mode 100644
index d2d34f24db8..00000000000
--- a/docs/apache-airflow-providers-postgres/changelog.rst
+++ /dev/null
@@ -1,25 +0,0 @@
-
- .. Licensed to the Apache Software Foundation (ASF) under one
-    or more contributor license agreements.  See the NOTICE file
-    distributed with this work for additional information
-    regarding copyright ownership.  The ASF licenses this file
-    to you under the Apache License, Version 2.0 (the
-    "License"); you may not use this file except in compliance
-    with the License.  You may obtain a copy of the License at
-
- ..   http://www.apache.org/licenses/LICENSE-2.0
-
- .. Unless required by applicable law or agreed to in writing,
-    software distributed under the License is distributed on an
-    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-    KIND, either express or implied.  See the License for the
-    specific language governing permissions and limitations
-    under the License.
-
- ..  NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE
-     OVERWRITTEN WHEN PREPARING PACKAGES.
-
- ..  IF YOU WANT TO MODIFY THIS FILE, YOU SHOULD MODIFY THE TEMPLATE
-     `PROVIDER_CHANGELOG_TEMPLATE.rst.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
-
-.. include:: ../../providers/src/airflow/providers/postgres/CHANGELOG.rst
diff --git a/providers/pgvector/README.rst b/providers/pgvector/README.rst
new file mode 100644
index 00000000000..f1c6cf88013
--- /dev/null
+++ b/providers/pgvector/README.rst
@@ -0,0 +1,83 @@
+
+ .. Licensed to the Apache Software Foundation (ASF) under one
+    or more contributor license agreements.  See the NOTICE file
+    distributed with this work for additional information
+    regarding copyright ownership.  The ASF licenses this file
+    to you under the Apache License, Version 2.0 (the
+    "License"); you may not use this file except in compliance
+    with the License.  You may obtain a copy of the License at
+
+ ..   http://www.apache.org/licenses/LICENSE-2.0
+
+ .. Unless required by applicable law or agreed to in writing,
+    software distributed under the License is distributed on an
+    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+    KIND, either express or implied.  See the License for the
+    specific language governing permissions and limitations
+    under the License.
+
+ .. NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE OVERWRITTEN!
+
+ .. IF YOU WANT TO MODIFY TEMPLATE FOR THIS FILE, YOU SHOULD MODIFY THE 
TEMPLATE
+    `PROVIDER_README_TEMPLATE.rst.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
+
+
+Package ``apache-airflow-providers-pgvector``
+
+Release: ``1.4.0``
+
+
+`pgvector <https://github.com/pgvector/pgvector>`__
+
+
+Provider package
+----------------
+
+This is a provider package for ``pgvector`` provider. All classes for this 
provider package
+are in ``airflow.providers.pgvector`` python package.
+
+You can find package information and changelog for the provider
+in the `documentation 
<https://airflow.apache.org/docs/apache-airflow-providers-pgvector/1.4.0/>`_.
+
+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-pgvector``
+
+The package supports the following python versions: 3.9,3.10,3.11,3.12
+
+Requirements
+------------
+
+=====================================  ==================
+PIP package                            Version required
+=====================================  ==================
+``apache-airflow``                     ``>=2.9.0``
+``apache-airflow-providers-postgres``  ``>=5.7.1``
+``pgvector``                           ``!=0.3.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:
+
+.. code-block:: bash
+
+    pip install apache-airflow-providers-pgvector[common.sql]
+
+
+============================================================================================================
  ==============
+Dependent package                                                              
                               Extra
+============================================================================================================
  ==============
+`apache-airflow-providers-common-sql 
<https://airflow.apache.org/docs/apache-airflow-providers-common-sql>`_  
``common.sql``
+`apache-airflow-providers-postgres 
<https://airflow.apache.org/docs/apache-airflow-providers-postgres>`_      
``postgres``
+============================================================================================================
  ==============
+
+The changelog for the provider package can be found in the
+`changelog 
<https://airflow.apache.org/docs/apache-airflow-providers-pgvector/1.4.0/changelog.html>`_.
diff --git 
a/providers/src/airflow/providers/pgvector/.latest-doc-only-change.txt 
b/providers/pgvector/docs/.latest-doc-only-change.txt
similarity index 100%
rename from providers/src/airflow/providers/pgvector/.latest-doc-only-change.txt
rename to providers/pgvector/docs/.latest-doc-only-change.txt
diff --git a/providers/src/airflow/providers/pgvector/CHANGELOG.rst 
b/providers/pgvector/docs/changelog.rst
similarity index 100%
rename from providers/src/airflow/providers/pgvector/CHANGELOG.rst
rename to providers/pgvector/docs/changelog.rst
diff --git a/docs/apache-airflow-providers-pgvector/commits.rst 
b/providers/pgvector/docs/commits.rst
similarity index 100%
rename from docs/apache-airflow-providers-pgvector/commits.rst
rename to providers/pgvector/docs/commits.rst
diff --git a/docs/apache-airflow-providers-pgvector/connections.rst 
b/providers/pgvector/docs/connections.rst
similarity index 100%
rename from docs/apache-airflow-providers-pgvector/connections.rst
rename to providers/pgvector/docs/connections.rst
diff --git a/docs/apache-airflow-providers-pgvector/index.rst 
b/providers/pgvector/docs/index.rst
similarity index 100%
rename from docs/apache-airflow-providers-pgvector/index.rst
rename to providers/pgvector/docs/index.rst
diff --git 
a/docs/apache-airflow-providers-pgvector/installing-providers-from-sources.rst 
b/providers/pgvector/docs/installing-providers-from-sources.rst
similarity index 100%
rename from 
docs/apache-airflow-providers-pgvector/installing-providers-from-sources.rst
rename to providers/pgvector/docs/installing-providers-from-sources.rst
diff --git a/docs/apache-airflow-providers-pgvector/operators/pgvector.rst 
b/providers/pgvector/docs/operators/pgvector.rst
similarity index 95%
rename from docs/apache-airflow-providers-pgvector/operators/pgvector.rst
rename to providers/pgvector/docs/operators/pgvector.rst
index b8ef6b27fcc..4dca13fea1c 100644
--- a/docs/apache-airflow-providers-pgvector/operators/pgvector.rst
+++ b/providers/pgvector/docs/operators/pgvector.rst
@@ -36,7 +36,7 @@ See https://github.com/pgvector/pgvector#installation for 
installation instructi
 
 An example using the operator to ingest data is shown below:
 
-.. exampleinclude:: /../../providers/tests/system/pgvector/example_pgvector.py
+.. exampleinclude:: 
/../../providers/pgvector/tests/system/pgvector/example_pgvector.py
     :language: python
     :start-after: [START howto_operator_pgvector_ingest]
     :end-before: [END howto_operator_pgvector_ingest]
diff --git a/docs/apache-airflow-providers-pgvector/security.rst 
b/providers/pgvector/docs/security.rst
similarity index 100%
rename from docs/apache-airflow-providers-pgvector/security.rst
rename to providers/pgvector/docs/security.rst
diff --git a/providers/src/airflow/providers/pgvector/provider.yaml 
b/providers/pgvector/provider.yaml
similarity index 87%
rename from providers/src/airflow/providers/pgvector/provider.yaml
rename to providers/pgvector/provider.yaml
index 4446db170c9..0fd20e0416b 100644
--- a/providers/src/airflow/providers/pgvector/provider.yaml
+++ b/providers/pgvector/provider.yaml
@@ -43,13 +43,6 @@ integrations:
       - /docs/apache-airflow-providers-pgvector/operators/pgvector.rst
     tags: [software]
 
-dependencies:
-  - apache-airflow>=2.9.0
-  - apache-airflow-providers-postgres>=5.7.1
-  # setting !=0.3.0 version due to 
https://github.com/pgvector/pgvector-python/issues/79
-  # observed in 0.3.0.
-  - pgvector!=0.3.0
-
 hooks:
   - integration-name: pgvector
     python-modules:
diff --git a/providers/pgvector/pyproject.toml 
b/providers/pgvector/pyproject.toml
new file mode 100644
index 00000000000..8e1a7c0522d
--- /dev/null
+++ b/providers/pgvector/pyproject.toml
@@ -0,0 +1,88 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+
+# NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE OVERWRITTEN!
+
+# IF YOU WANT TO MODIFY THIS FILE EXCEPT DEPENDENCIES, YOU SHOULD MODIFY THE 
TEMPLATE
+# `pyproject_TEMPLATE.toml.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
+[build-system]
+requires = ["flit_core==3.10.1"]
+build-backend = "flit_core.buildapi"
+
+[project]
+name = "apache-airflow-providers-pgvector"
+version = "1.4.0"
+description = "Provider package apache-airflow-providers-pgvector for Apache 
Airflow"
+readme = "README.rst"
+authors = [
+    {name="Apache Software Foundation", email="[email protected]"},
+]
+maintainers = [
+    {name="Apache Software Foundation", email="[email protected]"},
+]
+keywords = [ "airflow-provider", "pgvector", "airflow", "integration" ]
+classifiers = [
+    "Development Status :: 5 - Production/Stable",
+    "Environment :: Console",
+    "Environment :: Web Environment",
+    "Intended Audience :: Developers",
+    "Intended Audience :: System Administrators",
+    "Framework :: Apache Airflow",
+    "Framework :: Apache Airflow :: Provider",
+    "License :: OSI Approved :: Apache Software License",
+    "Programming Language :: Python :: 3.9",
+    "Programming Language :: Python :: 3.10",
+    "Programming Language :: Python :: 3.11",
+    "Programming Language :: Python :: 3.12",
+    "Topic :: System :: Monitoring",
+]
+requires-python = "~=3.9"
+
+# The dependencies should be modified in place in the generated file
+# Any change in the dependencies is preserved when the file is regenerated
+dependencies = [
+    "apache-airflow>=2.9.0",
+    "apache-airflow-providers-postgres>=5.7.1",
+    # setting !=0.3.0 version due to 
https://github.com/pgvector/pgvector-python/issues/79
+    # observed in 0.3.0.
+    "pgvector!=0.3.0",
+]
+
+# The optional dependencies should be modified in place in the generated file
+# Any change in the dependencies is preserved when the file is regenerated
+[project.optional-dependencies]
+"common.sql" = [
+    "apache-airflow-providers-common-sql"
+]
+
+[project.urls]
+"Documentation" = 
"https://airflow.apache.org/docs/apache-airflow-providers-pgvector/1.4.0";
+"Changelog" = 
"https://airflow.apache.org/docs/apache-airflow-providers-pgvector/1.4.0/changelog.html";
+"Bug Tracker" = "https://github.com/apache/airflow/issues";
+"Source Code" = "https://github.com/apache/airflow";
+"Slack Chat" = "https://s.apache.org/airflow-slack";
+"Twitter" = "https://x.com/ApacheAirflow";
+"YouTube" = "https://www.youtube.com/channel/UCSXwxpWZQ7XZ1WL3wqevChA/";
+
+[project.entry-points."apache_airflow_provider"]
+provider_info = 
"airflow.providers.pgvector.get_provider_info:get_provider_info"
+
+[tool.flit.module]
+name = "airflow.providers.pgvector"
+
+[tool.pytest.ini_options]
+ignore = "tests/system/"
diff --git a/providers/pgvector/src/airflow/providers/pgvector/LICENSE 
b/providers/pgvector/src/airflow/providers/pgvector/LICENSE
new file mode 100644
index 00000000000..11069edd790
--- /dev/null
+++ b/providers/pgvector/src/airflow/providers/pgvector/LICENSE
@@ -0,0 +1,201 @@
+                              Apache License
+                        Version 2.0, January 2004
+                     http://www.apache.org/licenses/
+
+TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
+
+1. Definitions.
+
+   "License" shall mean the terms and conditions for use, reproduction,
+   and distribution as defined by Sections 1 through 9 of this document.
+
+   "Licensor" shall mean the copyright owner or entity authorized by
+   the copyright owner that is granting the License.
+
+   "Legal Entity" shall mean the union of the acting entity and all
+   other entities that control, are controlled by, or are under common
+   control with that entity. For the purposes of this definition,
+   "control" means (i) the power, direct or indirect, to cause the
+   direction or management of such entity, whether by contract or
+   otherwise, or (ii) ownership of fifty percent (50%) or more of the
+   outstanding shares, or (iii) beneficial ownership of such entity.
+
+   "You" (or "Your") shall mean an individual or Legal Entity
+   exercising permissions granted by this License.
+
+   "Source" form shall mean the preferred form for making modifications,
+   including but not limited to software source code, documentation
+   source, and configuration files.
+
+   "Object" form shall mean any form resulting from mechanical
+   transformation or translation of a Source form, including but
+   not limited to compiled object code, generated documentation,
+   and conversions to other media types.
+
+   "Work" shall mean the work of authorship, whether in Source or
+   Object form, made available under the License, as indicated by a
+   copyright notice that is included in or attached to the work
+   (an example is provided in the Appendix below).
+
+   "Derivative Works" shall mean any work, whether in Source or Object
+   form, that is based on (or derived from) the Work and for which the
+   editorial revisions, annotations, elaborations, or other modifications
+   represent, as a whole, an original work of authorship. For the purposes
+   of this License, Derivative Works shall not include works that remain
+   separable from, or merely link (or bind by name) to the interfaces of,
+   the Work and Derivative Works thereof.
+
+   "Contribution" shall mean any work of authorship, including
+   the original version of the Work and any modifications or additions
+   to that Work or Derivative Works thereof, that is intentionally
+   submitted to Licensor for inclusion in the Work by the copyright owner
+   or by an individual or Legal Entity authorized to submit on behalf of
+   the copyright owner. For the purposes of this definition, "submitted"
+   means any form of electronic, verbal, or written communication sent
+   to the Licensor or its representatives, including but not limited to
+   communication on electronic mailing lists, source code control systems,
+   and issue tracking systems that are managed by, or on behalf of, the
+   Licensor for the purpose of discussing and improving the Work, but
+   excluding communication that is conspicuously marked or otherwise
+   designated in writing by the copyright owner as "Not a Contribution."
+
+   "Contributor" shall mean Licensor and any individual or Legal Entity
+   on behalf of whom a Contribution has been received by Licensor and
+   subsequently incorporated within the Work.
+
+2. Grant of Copyright License. Subject to the terms and conditions of
+   this License, each Contributor hereby grants to You a perpetual,
+   worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+   copyright license to reproduce, prepare Derivative Works of,
+   publicly display, publicly perform, sublicense, and distribute the
+   Work and such Derivative Works in Source or Object form.
+
+3. Grant of Patent License. Subject to the terms and conditions of
+   this License, each Contributor hereby grants to You a perpetual,
+   worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+   (except as stated in this section) patent license to make, have made,
+   use, offer to sell, sell, import, and otherwise transfer the Work,
+   where such license applies only to those patent claims licensable
+   by such Contributor that are necessarily infringed by their
+   Contribution(s) alone or by combination of their Contribution(s)
+   with the Work to which such Contribution(s) was submitted. If You
+   institute patent litigation against any entity (including a
+   cross-claim or counterclaim in a lawsuit) alleging that the Work
+   or a Contribution incorporated within the Work constitutes direct
+   or contributory patent infringement, then any patent licenses
+   granted to You under this License for that Work shall terminate
+   as of the date such litigation is filed.
+
+4. Redistribution. You may reproduce and distribute copies of the
+   Work or Derivative Works thereof in any medium, with or without
+   modifications, and in Source or Object form, provided that You
+   meet the following conditions:
+
+   (a) You must give any other recipients of the Work or
+       Derivative Works a copy of this License; and
+
+   (b) You must cause any modified files to carry prominent notices
+       stating that You changed the files; and
+
+   (c) You must retain, in the Source form of any Derivative Works
+       that You distribute, all copyright, patent, trademark, and
+       attribution notices from the Source form of the Work,
+       excluding those notices that do not pertain to any part of
+       the Derivative Works; and
+
+   (d) If the Work includes a "NOTICE" text file as part of its
+       distribution, then any Derivative Works that You distribute must
+       include a readable copy of the attribution notices contained
+       within such NOTICE file, excluding those notices that do not
+       pertain to any part of the Derivative Works, in at least one
+       of the following places: within a NOTICE text file distributed
+       as part of the Derivative Works; within the Source form or
+       documentation, if provided along with the Derivative Works; or,
+       within a display generated by the Derivative Works, if and
+       wherever such third-party notices normally appear. The contents
+       of the NOTICE file are for informational purposes only and
+       do not modify the License. You may add Your own attribution
+       notices within Derivative Works that You distribute, alongside
+       or as an addendum to the NOTICE text from the Work, provided
+       that such additional attribution notices cannot be construed
+       as modifying the License.
+
+   You may add Your own copyright statement to Your modifications and
+   may provide additional or different license terms and conditions
+   for use, reproduction, or distribution of Your modifications, or
+   for any such Derivative Works as a whole, provided Your use,
+   reproduction, and distribution of the Work otherwise complies with
+   the conditions stated in this License.
+
+5. Submission of Contributions. Unless You explicitly state otherwise,
+   any Contribution intentionally submitted for inclusion in the Work
+   by You to the Licensor shall be under the terms and conditions of
+   this License, without any additional terms or conditions.
+   Notwithstanding the above, nothing herein shall supersede or modify
+   the terms of any separate license agreement you may have executed
+   with Licensor regarding such Contributions.
+
+6. Trademarks. This License does not grant permission to use the trade
+   names, trademarks, service marks, or product names of the Licensor,
+   except as required for reasonable and customary use in describing the
+   origin of the Work and reproducing the content of the NOTICE file.
+
+7. Disclaimer of Warranty. Unless required by applicable law or
+   agreed to in writing, Licensor provides the Work (and each
+   Contributor provides its Contributions) on an "AS IS" BASIS,
+   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+   implied, including, without limitation, any warranties or conditions
+   of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
+   PARTICULAR PURPOSE. You are solely responsible for determining the
+   appropriateness of using or redistributing the Work and assume any
+   risks associated with Your exercise of permissions under this License.
+
+8. Limitation of Liability. In no event and under no legal theory,
+   whether in tort (including negligence), contract, or otherwise,
+   unless required by applicable law (such as deliberate and grossly
+   negligent acts) or agreed to in writing, shall any Contributor be
+   liable to You for damages, including any direct, indirect, special,
+   incidental, or consequential damages of any character arising as a
+   result of this License or out of the use or inability to use the
+   Work (including but not limited to damages for loss of goodwill,
+   work stoppage, computer failure or malfunction, or any and all
+   other commercial damages or losses), even if such Contributor
+   has been advised of the possibility of such damages.
+
+9. Accepting Warranty or Additional Liability. While redistributing
+   the Work or Derivative Works thereof, You may choose to offer,
+   and charge a fee for, acceptance of support, warranty, indemnity,
+   or other liability obligations and/or rights consistent with this
+   License. However, in accepting such obligations, You may act only
+   on Your own behalf and on Your sole responsibility, not on behalf
+   of any other Contributor, and only if You agree to indemnify,
+   defend, and hold each Contributor harmless for any liability
+   incurred by, or claims asserted against, such Contributor by reason
+   of your accepting any such warranty or additional liability.
+
+END OF TERMS AND CONDITIONS
+
+APPENDIX: How to apply the Apache License to your work.
+
+   To apply the Apache License to your work, attach the following
+   boilerplate notice, with the fields enclosed by brackets "[]"
+   replaced with your own identifying information. (Don't include
+   the brackets!)  The text should be enclosed in the appropriate
+   comment syntax for the file format. We also recommend that a
+   file or class name and description of purpose be included on the
+   same "printed page" as the copyright notice for easier
+   identification within third-party archives.
+
+Copyright [yyyy] [name of copyright owner]
+
+Licensed under the Apache License, Version 2.0 (the "License");
+you may not use this file except in compliance with the License.
+You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
diff --git a/providers/src/airflow/providers/pgvector/__init__.py 
b/providers/pgvector/src/airflow/providers/pgvector/__init__.py
similarity index 100%
rename from providers/src/airflow/providers/pgvector/__init__.py
rename to providers/pgvector/src/airflow/providers/pgvector/__init__.py
diff --git 
a/providers/pgvector/src/airflow/providers/pgvector/get_provider_info.py 
b/providers/pgvector/src/airflow/providers/pgvector/get_provider_info.py
new file mode 100644
index 00000000000..bcad3cf40a5
--- /dev/null
+++ b/providers/pgvector/src/airflow/providers/pgvector/get_provider_info.py
@@ -0,0 +1,55 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+
+# NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE OVERWRITTEN!
+#
+# IF YOU WANT TO MODIFY THIS FILE, YOU SHOULD MODIFY THE TEMPLATE
+# `get_provider_info_TEMPLATE.py.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
+
+
+def get_provider_info():
+    return {
+        "package-name": "apache-airflow-providers-pgvector",
+        "name": "pgvector",
+        "description": "`pgvector <https://github.com/pgvector/pgvector>`__\n",
+        "state": "ready",
+        "source-date-epoch": 1734536254,
+        "versions": ["1.4.0", "1.3.0", "1.2.2", "1.2.1", "1.2.0", "1.1.0", 
"1.0.0"],
+        "integrations": [
+            {
+                "integration-name": "pgvector",
+                "external-doc-url": "https://github.com/pgvector/pgvector";,
+                "how-to-guide": 
["/docs/apache-airflow-providers-pgvector/operators/pgvector.rst"],
+                "tags": ["software"],
+            }
+        ],
+        "hooks": [
+            {"integration-name": "pgvector", "python-modules": 
["airflow.providers.pgvector.hooks.pgvector"]}
+        ],
+        "operators": [
+            {
+                "integration-name": "pgvector",
+                "python-modules": 
["airflow.providers.pgvector.operators.pgvector"],
+            }
+        ],
+        "dependencies": [
+            "apache-airflow>=2.9.0",
+            "apache-airflow-providers-postgres>=5.7.1",
+            "pgvector!=0.3.0",
+        ],
+        "optional-dependencies": {"common.sql": 
["apache-airflow-providers-common-sql"]},
+    }
diff --git a/providers/src/airflow/providers/pgvector/hooks/__init__.py 
b/providers/pgvector/src/airflow/providers/pgvector/hooks/__init__.py
similarity index 100%
copy from providers/src/airflow/providers/pgvector/hooks/__init__.py
copy to providers/pgvector/src/airflow/providers/pgvector/hooks/__init__.py
diff --git a/providers/src/airflow/providers/pgvector/hooks/pgvector.py 
b/providers/pgvector/src/airflow/providers/pgvector/hooks/pgvector.py
similarity index 100%
rename from providers/src/airflow/providers/pgvector/hooks/pgvector.py
rename to providers/pgvector/src/airflow/providers/pgvector/hooks/pgvector.py
diff --git a/providers/src/airflow/providers/pgvector/operators/__init__.py 
b/providers/pgvector/src/airflow/providers/pgvector/operators/__init__.py
similarity index 100%
rename from providers/src/airflow/providers/pgvector/operators/__init__.py
rename to 
providers/pgvector/src/airflow/providers/pgvector/operators/__init__.py
diff --git a/providers/src/airflow/providers/pgvector/operators/pgvector.py 
b/providers/pgvector/src/airflow/providers/pgvector/operators/pgvector.py
similarity index 99%
rename from providers/src/airflow/providers/pgvector/operators/pgvector.py
rename to 
providers/pgvector/src/airflow/providers/pgvector/operators/pgvector.py
index ae48a377ea7..c9f1daed1fe 100644
--- a/providers/src/airflow/providers/pgvector/operators/pgvector.py
+++ b/providers/pgvector/src/airflow/providers/pgvector/operators/pgvector.py
@@ -17,9 +17,8 @@
 # under the License.
 from __future__ import annotations
 
-from pgvector.psycopg2 import register_vector
-
 from airflow.providers.common.sql.operators.sql import SQLExecuteQueryOperator
+from pgvector.psycopg2 import register_vector
 
 
 class PgVectorIngestOperator(SQLExecuteQueryOperator):
diff --git a/providers/src/airflow/providers/pgvector/hooks/__init__.py 
b/providers/pgvector/tests/conftest.py
similarity index 58%
copy from providers/src/airflow/providers/pgvector/hooks/__init__.py
copy to providers/pgvector/tests/conftest.py
index c88b314548b..068fe6bbf5a 100644
--- a/providers/src/airflow/providers/pgvector/hooks/__init__.py
+++ b/providers/pgvector/tests/conftest.py
@@ -1,4 +1,3 @@
-#
 # Licensed to the Apache Software Foundation (ASF) under one
 # or more contributor license agreements.  See the NOTICE file
 # distributed with this work for additional information
@@ -15,10 +14,19 @@
 # KIND, either express or implied.  See the License for the
 # specific language governing permissions and limitations
 # under the License.
-#
-# NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE
-# OVERWRITTEN WHEN PREPARING DOCUMENTATION FOR THE PACKAGES.
-#
-# IF YOU WANT TO MODIFY IT, YOU SHOULD MODIFY THE TEMPLATE
-# `PROVIDER__INIT__PY_TEMPLATE.py.jinja2` IN the `dev/provider_packages` 
DIRECTORY
-#
+from __future__ import annotations
+
+import pathlib
+
+import pytest
+
+pytest_plugins = "tests_common.pytest_plugin"
+
+
[email protected](tryfirst=True)
+def pytest_configure(config: pytest.Config) -> None:
+    deprecations_ignore_path = 
pathlib.Path(__file__).parent.joinpath("deprecations_ignore.yml")
+    dep_path = [deprecations_ignore_path] if deprecations_ignore_path.exists() 
else []
+    config.inicfg["airflow_deprecations_ignore"] = (
+        config.inicfg.get("airflow_deprecations_ignore", []) + dep_path  # 
type: ignore[assignment,operator]
+    )
diff --git a/providers/src/airflow/providers/postgres/assets/__init__.py 
b/providers/pgvector/tests/provider_tests/__init__.py
similarity index 90%
copy from providers/src/airflow/providers/postgres/assets/__init__.py
copy to providers/pgvector/tests/provider_tests/__init__.py
index 13a83393a91..e8fd2285643 100644
--- a/providers/src/airflow/providers/postgres/assets/__init__.py
+++ b/providers/pgvector/tests/provider_tests/__init__.py
@@ -14,3 +14,4 @@
 # KIND, either express or implied.  See the License for the
 # specific language governing permissions and limitations
 # under the License.
+__path__ = __import__("pkgutil").extend_path(__path__, __name__)  # type: 
ignore
diff --git a/providers/src/airflow/providers/postgres/assets/__init__.py 
b/providers/pgvector/tests/provider_tests/pgvector/__init__.py
similarity index 100%
copy from providers/src/airflow/providers/postgres/assets/__init__.py
copy to providers/pgvector/tests/provider_tests/pgvector/__init__.py
diff --git a/providers/src/airflow/providers/postgres/dialects/__init__.py 
b/providers/pgvector/tests/provider_tests/pgvector/hooks/__init__.py
similarity index 100%
rename from providers/src/airflow/providers/postgres/dialects/__init__.py
rename to providers/pgvector/tests/provider_tests/pgvector/hooks/__init__.py
diff --git a/providers/tests/pgvector/hooks/test_pgvector.py 
b/providers/pgvector/tests/provider_tests/pgvector/hooks/test_pgvector.py
similarity index 100%
rename from providers/tests/pgvector/hooks/test_pgvector.py
rename to 
providers/pgvector/tests/provider_tests/pgvector/hooks/test_pgvector.py
diff --git a/providers/tests/pgvector/__init__.py 
b/providers/pgvector/tests/provider_tests/pgvector/operators/__init__.py
similarity index 100%
rename from providers/tests/pgvector/__init__.py
rename to providers/pgvector/tests/provider_tests/pgvector/operators/__init__.py
diff --git a/providers/tests/pgvector/operators/test_pgvector.py 
b/providers/pgvector/tests/provider_tests/pgvector/operators/test_pgvector.py
similarity index 100%
rename from providers/tests/pgvector/operators/test_pgvector.py
rename to 
providers/pgvector/tests/provider_tests/pgvector/operators/test_pgvector.py
diff --git a/providers/tests/pgvector/hooks/__init__.py 
b/providers/pgvector/tests/system/pgvector/__init__.py
similarity index 100%
rename from providers/tests/pgvector/hooks/__init__.py
rename to providers/pgvector/tests/system/pgvector/__init__.py
diff --git a/providers/tests/system/pgvector/example_pgvector.py 
b/providers/pgvector/tests/system/pgvector/example_pgvector.py
similarity index 100%
rename from providers/tests/system/pgvector/example_pgvector.py
rename to providers/pgvector/tests/system/pgvector/example_pgvector.py
diff --git a/providers/tests/system/pgvector/example_pgvector_openai.py 
b/providers/pgvector/tests/system/pgvector/example_pgvector_openai.py
similarity index 100%
rename from providers/tests/system/pgvector/example_pgvector_openai.py
rename to providers/pgvector/tests/system/pgvector/example_pgvector_openai.py
diff --git a/providers/postgres/README.rst b/providers/postgres/README.rst
new file mode 100644
index 00000000000..fc5dcd1f85f
--- /dev/null
+++ b/providers/postgres/README.rst
@@ -0,0 +1,85 @@
+
+ .. Licensed to the Apache Software Foundation (ASF) under one
+    or more contributor license agreements.  See the NOTICE file
+    distributed with this work for additional information
+    regarding copyright ownership.  The ASF licenses this file
+    to you under the Apache License, Version 2.0 (the
+    "License"); you may not use this file except in compliance
+    with the License.  You may obtain a copy of the License at
+
+ ..   http://www.apache.org/licenses/LICENSE-2.0
+
+ .. Unless required by applicable law or agreed to in writing,
+    software distributed under the License is distributed on an
+    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+    KIND, either express or implied.  See the License for the
+    specific language governing permissions and limitations
+    under the License.
+
+ .. NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE OVERWRITTEN!
+
+ .. IF YOU WANT TO MODIFY TEMPLATE FOR THIS FILE, YOU SHOULD MODIFY THE 
TEMPLATE
+    `PROVIDER_README_TEMPLATE.rst.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
+
+
+Package ``apache-airflow-providers-postgres``
+
+Release: ``6.0.0``
+
+
+`PostgreSQL <https://www.postgresql.org/>`__
+
+
+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 
<https://airflow.apache.org/docs/apache-airflow-providers-postgres/6.0.0/>`_.
+
+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.9,3.10,3.11,3.12
+
+Requirements
+------------
+
+=======================================  ==================
+PIP package                              Version required
+=======================================  ==================
+``apache-airflow``                       ``>=2.9.0``
+``apache-airflow-providers-common-sql``  ``>=1.20.0``
+``psycopg2-binary``                      ``>=2.9.7``
+``asyncpg``                              ``>=0.30.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:
+
+.. code-block:: bash
+
+    pip install apache-airflow-providers-postgres[amazon]
+
+
+==============================================================================================================
  ===============
+Dependent package                                                              
                                 Extra
+==============================================================================================================
  ===============
+`apache-airflow-providers-amazon 
<https://airflow.apache.org/docs/apache-airflow-providers-amazon>`_            
``amazon``
+`apache-airflow-providers-common-sql 
<https://airflow.apache.org/docs/apache-airflow-providers-common-sql>`_    
``common.sql``
+`apache-airflow-providers-openlineage 
<https://airflow.apache.org/docs/apache-airflow-providers-openlineage>`_  
``openlineage``
+==============================================================================================================
  ===============
+
+The changelog for the provider package can be found in the
+`changelog 
<https://airflow.apache.org/docs/apache-airflow-providers-postgres/6.0.0/changelog.html>`_.
diff --git 
a/providers/src/airflow/providers/postgres/.latest-doc-only-change.txt 
b/providers/postgres/docs/.latest-doc-only-change.txt
similarity index 100%
rename from providers/src/airflow/providers/postgres/.latest-doc-only-change.txt
rename to providers/postgres/docs/.latest-doc-only-change.txt
diff --git a/providers/src/airflow/providers/postgres/CHANGELOG.rst 
b/providers/postgres/docs/changelog.rst
similarity index 100%
rename from providers/src/airflow/providers/postgres/CHANGELOG.rst
rename to providers/postgres/docs/changelog.rst
diff --git a/docs/apache-airflow-providers-postgres/commits.rst 
b/providers/postgres/docs/commits.rst
similarity index 100%
rename from docs/apache-airflow-providers-postgres/commits.rst
rename to providers/postgres/docs/commits.rst
diff --git a/docs/apache-airflow-providers-postgres/connections/postgres.rst 
b/providers/postgres/docs/connections/postgres.rst
similarity index 100%
rename from docs/apache-airflow-providers-postgres/connections/postgres.rst
rename to providers/postgres/docs/connections/postgres.rst
diff --git a/docs/apache-airflow-providers-postgres/dialects.rst 
b/providers/postgres/docs/dialects.rst
similarity index 100%
rename from docs/apache-airflow-providers-postgres/dialects.rst
rename to providers/postgres/docs/dialects.rst
diff --git a/docs/apache-airflow-providers-postgres/index.rst 
b/providers/postgres/docs/index.rst
similarity index 100%
rename from docs/apache-airflow-providers-postgres/index.rst
rename to providers/postgres/docs/index.rst
diff --git 
a/docs/apache-airflow-providers-postgres/installing-providers-from-sources.rst 
b/providers/postgres/docs/installing-providers-from-sources.rst
similarity index 100%
rename from 
docs/apache-airflow-providers-postgres/installing-providers-from-sources.rst
rename to providers/postgres/docs/installing-providers-from-sources.rst
diff --git a/docs/integration-logos/postgres/Postgres.png 
b/providers/postgres/docs/integration-logos/Postgres.png
similarity index 100%
rename from docs/integration-logos/postgres/Postgres.png
rename to providers/postgres/docs/integration-logos/Postgres.png
diff --git 
a/docs/apache-airflow-providers-postgres/operators/postgres_operator_howto_guide.rst
 b/providers/postgres/docs/operators/postgres_operator_howto_guide.rst
similarity index 96%
rename from 
docs/apache-airflow-providers-postgres/operators/postgres_operator_howto_guide.rst
rename to providers/postgres/docs/operators/postgres_operator_howto_guide.rst
index da7f8252c0e..0aa0a9c5559 100644
--- 
a/docs/apache-airflow-providers-postgres/operators/postgres_operator_howto_guide.rst
+++ b/providers/postgres/docs/operators/postgres_operator_howto_guide.rst
@@ -45,7 +45,7 @@ Creating a Postgres database table
 
 The code snippets below are based on Airflow-2.0
 
-.. exampleinclude:: /../../providers/tests/system/postgres/example_postgres.py
+.. exampleinclude:: 
/../../providers/postgres/tests/system/postgres/example_postgres.py
     :language: python
     :start-after: [START postgres_sql_execute_query_operator_howto_guide]
     :end-before: [END 
postgres_sql_execute_query_operator_howto_guide_create_pet_table]
@@ -181,7 +181,7 @@ SQLExecuteQueryOperator provides ``hook_params`` attribute 
that allows you to pa
 You can pass ``options`` argument this way so that you specify `command-line 
options 
<https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNECT-OPTIONS>`_
 sent to the server at connection start.
 
-.. exampleinclude:: /../../providers/tests/system/postgres/example_postgres.py
+.. exampleinclude:: 
/../../providers/postgres/tests/system/postgres/example_postgres.py
     :language: python
     :start-after: [START 
postgres_sql_execute_query_operator_howto_guide_get_birth_date]
     :end-before: [END 
postgres_sql_execute_query_operator_howto_guide_get_birth_date]
@@ -192,7 +192,7 @@ The complete Postgres Operator DAG
 
 When we put everything together, our DAG should look like this:
 
-.. exampleinclude:: /../../providers/tests/system/postgres/example_postgres.py
+.. exampleinclude:: 
/../../providers/postgres/tests/system/postgres/example_postgres.py
     :language: python
     :start-after: [START postgres_sql_execute_query_operator_howto_guide]
     :end-before: [END postgres_sql_execute_query_operator_howto_guide]
diff --git a/docs/apache-airflow-providers-postgres/redirects.txt 
b/providers/postgres/docs/redirects.txt
similarity index 100%
rename from docs/apache-airflow-providers-postgres/redirects.txt
rename to providers/postgres/docs/redirects.txt
diff --git a/docs/apache-airflow-providers-postgres/security.rst 
b/providers/postgres/docs/security.rst
similarity index 100%
rename from docs/apache-airflow-providers-postgres/security.rst
rename to providers/postgres/docs/security.rst
diff --git a/providers/src/airflow/providers/postgres/provider.yaml 
b/providers/postgres/provider.yaml
similarity index 89%
rename from providers/src/airflow/providers/postgres/provider.yaml
rename to providers/postgres/provider.yaml
index b668bba0624..e1c3ea1ae73 100644
--- a/providers/src/airflow/providers/postgres/provider.yaml
+++ b/providers/postgres/provider.yaml
@@ -67,23 +67,12 @@ versions:
   - 1.0.1
   - 1.0.0
 
-dependencies:
-  - apache-airflow>=2.9.0
-  - apache-airflow-providers-common-sql>=1.20.0
-  - psycopg2-binary>=2.9.7
-  - asyncpg>=0.30.0
-
-additional-extras:
-  - name: amazon
-    dependencies:
-      - apache-airflow-providers-amazon>=2.6.0
-
 integrations:
   - integration-name: PostgreSQL
     external-doc-url: https://www.postgresql.org/
     how-to-guide:
       - 
/docs/apache-airflow-providers-postgres/operators/postgres_operator_howto_guide.rst
-    logo: /integration-logos/postgres/Postgres.png
+    logo: /docs/integration-logos/Postgres.png
     tags: [software]
 
 dialects:
diff --git a/providers/postgres/pyproject.toml 
b/providers/postgres/pyproject.toml
new file mode 100644
index 00000000000..dfefe498eb4
--- /dev/null
+++ b/providers/postgres/pyproject.toml
@@ -0,0 +1,90 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+
+# NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE OVERWRITTEN!
+
+# IF YOU WANT TO MODIFY THIS FILE EXCEPT DEPENDENCIES, YOU SHOULD MODIFY THE 
TEMPLATE
+# `pyproject_TEMPLATE.toml.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
+[build-system]
+requires = ["flit_core==3.10.1"]
+build-backend = "flit_core.buildapi"
+
+[project]
+name = "apache-airflow-providers-postgres"
+version = "6.0.0"
+description = "Provider package apache-airflow-providers-postgres for Apache 
Airflow"
+readme = "README.rst"
+authors = [
+    {name="Apache Software Foundation", email="[email protected]"},
+]
+maintainers = [
+    {name="Apache Software Foundation", email="[email protected]"},
+]
+keywords = [ "airflow-provider", "postgres", "airflow", "integration" ]
+classifiers = [
+    "Development Status :: 5 - Production/Stable",
+    "Environment :: Console",
+    "Environment :: Web Environment",
+    "Intended Audience :: Developers",
+    "Intended Audience :: System Administrators",
+    "Framework :: Apache Airflow",
+    "Framework :: Apache Airflow :: Provider",
+    "License :: OSI Approved :: Apache Software License",
+    "Programming Language :: Python :: 3.9",
+    "Programming Language :: Python :: 3.10",
+    "Programming Language :: Python :: 3.11",
+    "Programming Language :: Python :: 3.12",
+    "Topic :: System :: Monitoring",
+]
+requires-python = "~=3.9"
+
+# The dependencies should be modified in place in the generated file
+# Any change in the dependencies is preserved when the file is regenerated
+dependencies = [
+    "apache-airflow>=2.9.0",
+    "apache-airflow-providers-common-sql>=1.20.0",
+    "psycopg2-binary>=2.9.7",
+    "asyncpg>=0.30.0",
+]
+
+# The optional dependencies should be modified in place in the generated file
+# Any change in the dependencies is preserved when the file is regenerated
+[project.optional-dependencies]
+"amazon" = [
+    "apache-airflow-providers-amazon>=2.6.0",
+]
+"openlineage" = [
+    "apache-airflow-providers-openlineage"
+]
+
+[project.urls]
+"Documentation" = 
"https://airflow.apache.org/docs/apache-airflow-providers-postgres/6.0.0";
+"Changelog" = 
"https://airflow.apache.org/docs/apache-airflow-providers-postgres/6.0.0/changelog.html";
+"Bug Tracker" = "https://github.com/apache/airflow/issues";
+"Source Code" = "https://github.com/apache/airflow";
+"Slack Chat" = "https://s.apache.org/airflow-slack";
+"Twitter" = "https://x.com/ApacheAirflow";
+"YouTube" = "https://www.youtube.com/channel/UCSXwxpWZQ7XZ1WL3wqevChA/";
+
+[project.entry-points."apache_airflow_provider"]
+provider_info = 
"airflow.providers.postgres.get_provider_info:get_provider_info"
+
+[tool.flit.module]
+name = "airflow.providers.postgres"
+
+[tool.pytest.ini_options]
+ignore = "tests/system/"
diff --git a/providers/postgres/src/airflow/providers/postgres/LICENSE 
b/providers/postgres/src/airflow/providers/postgres/LICENSE
new file mode 100644
index 00000000000..11069edd790
--- /dev/null
+++ b/providers/postgres/src/airflow/providers/postgres/LICENSE
@@ -0,0 +1,201 @@
+                              Apache License
+                        Version 2.0, January 2004
+                     http://www.apache.org/licenses/
+
+TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
+
+1. Definitions.
+
+   "License" shall mean the terms and conditions for use, reproduction,
+   and distribution as defined by Sections 1 through 9 of this document.
+
+   "Licensor" shall mean the copyright owner or entity authorized by
+   the copyright owner that is granting the License.
+
+   "Legal Entity" shall mean the union of the acting entity and all
+   other entities that control, are controlled by, or are under common
+   control with that entity. For the purposes of this definition,
+   "control" means (i) the power, direct or indirect, to cause the
+   direction or management of such entity, whether by contract or
+   otherwise, or (ii) ownership of fifty percent (50%) or more of the
+   outstanding shares, or (iii) beneficial ownership of such entity.
+
+   "You" (or "Your") shall mean an individual or Legal Entity
+   exercising permissions granted by this License.
+
+   "Source" form shall mean the preferred form for making modifications,
+   including but not limited to software source code, documentation
+   source, and configuration files.
+
+   "Object" form shall mean any form resulting from mechanical
+   transformation or translation of a Source form, including but
+   not limited to compiled object code, generated documentation,
+   and conversions to other media types.
+
+   "Work" shall mean the work of authorship, whether in Source or
+   Object form, made available under the License, as indicated by a
+   copyright notice that is included in or attached to the work
+   (an example is provided in the Appendix below).
+
+   "Derivative Works" shall mean any work, whether in Source or Object
+   form, that is based on (or derived from) the Work and for which the
+   editorial revisions, annotations, elaborations, or other modifications
+   represent, as a whole, an original work of authorship. For the purposes
+   of this License, Derivative Works shall not include works that remain
+   separable from, or merely link (or bind by name) to the interfaces of,
+   the Work and Derivative Works thereof.
+
+   "Contribution" shall mean any work of authorship, including
+   the original version of the Work and any modifications or additions
+   to that Work or Derivative Works thereof, that is intentionally
+   submitted to Licensor for inclusion in the Work by the copyright owner
+   or by an individual or Legal Entity authorized to submit on behalf of
+   the copyright owner. For the purposes of this definition, "submitted"
+   means any form of electronic, verbal, or written communication sent
+   to the Licensor or its representatives, including but not limited to
+   communication on electronic mailing lists, source code control systems,
+   and issue tracking systems that are managed by, or on behalf of, the
+   Licensor for the purpose of discussing and improving the Work, but
+   excluding communication that is conspicuously marked or otherwise
+   designated in writing by the copyright owner as "Not a Contribution."
+
+   "Contributor" shall mean Licensor and any individual or Legal Entity
+   on behalf of whom a Contribution has been received by Licensor and
+   subsequently incorporated within the Work.
+
+2. Grant of Copyright License. Subject to the terms and conditions of
+   this License, each Contributor hereby grants to You a perpetual,
+   worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+   copyright license to reproduce, prepare Derivative Works of,
+   publicly display, publicly perform, sublicense, and distribute the
+   Work and such Derivative Works in Source or Object form.
+
+3. Grant of Patent License. Subject to the terms and conditions of
+   this License, each Contributor hereby grants to You a perpetual,
+   worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+   (except as stated in this section) patent license to make, have made,
+   use, offer to sell, sell, import, and otherwise transfer the Work,
+   where such license applies only to those patent claims licensable
+   by such Contributor that are necessarily infringed by their
+   Contribution(s) alone or by combination of their Contribution(s)
+   with the Work to which such Contribution(s) was submitted. If You
+   institute patent litigation against any entity (including a
+   cross-claim or counterclaim in a lawsuit) alleging that the Work
+   or a Contribution incorporated within the Work constitutes direct
+   or contributory patent infringement, then any patent licenses
+   granted to You under this License for that Work shall terminate
+   as of the date such litigation is filed.
+
+4. Redistribution. You may reproduce and distribute copies of the
+   Work or Derivative Works thereof in any medium, with or without
+   modifications, and in Source or Object form, provided that You
+   meet the following conditions:
+
+   (a) You must give any other recipients of the Work or
+       Derivative Works a copy of this License; and
+
+   (b) You must cause any modified files to carry prominent notices
+       stating that You changed the files; and
+
+   (c) You must retain, in the Source form of any Derivative Works
+       that You distribute, all copyright, patent, trademark, and
+       attribution notices from the Source form of the Work,
+       excluding those notices that do not pertain to any part of
+       the Derivative Works; and
+
+   (d) If the Work includes a "NOTICE" text file as part of its
+       distribution, then any Derivative Works that You distribute must
+       include a readable copy of the attribution notices contained
+       within such NOTICE file, excluding those notices that do not
+       pertain to any part of the Derivative Works, in at least one
+       of the following places: within a NOTICE text file distributed
+       as part of the Derivative Works; within the Source form or
+       documentation, if provided along with the Derivative Works; or,
+       within a display generated by the Derivative Works, if and
+       wherever such third-party notices normally appear. The contents
+       of the NOTICE file are for informational purposes only and
+       do not modify the License. You may add Your own attribution
+       notices within Derivative Works that You distribute, alongside
+       or as an addendum to the NOTICE text from the Work, provided
+       that such additional attribution notices cannot be construed
+       as modifying the License.
+
+   You may add Your own copyright statement to Your modifications and
+   may provide additional or different license terms and conditions
+   for use, reproduction, or distribution of Your modifications, or
+   for any such Derivative Works as a whole, provided Your use,
+   reproduction, and distribution of the Work otherwise complies with
+   the conditions stated in this License.
+
+5. Submission of Contributions. Unless You explicitly state otherwise,
+   any Contribution intentionally submitted for inclusion in the Work
+   by You to the Licensor shall be under the terms and conditions of
+   this License, without any additional terms or conditions.
+   Notwithstanding the above, nothing herein shall supersede or modify
+   the terms of any separate license agreement you may have executed
+   with Licensor regarding such Contributions.
+
+6. Trademarks. This License does not grant permission to use the trade
+   names, trademarks, service marks, or product names of the Licensor,
+   except as required for reasonable and customary use in describing the
+   origin of the Work and reproducing the content of the NOTICE file.
+
+7. Disclaimer of Warranty. Unless required by applicable law or
+   agreed to in writing, Licensor provides the Work (and each
+   Contributor provides its Contributions) on an "AS IS" BASIS,
+   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+   implied, including, without limitation, any warranties or conditions
+   of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
+   PARTICULAR PURPOSE. You are solely responsible for determining the
+   appropriateness of using or redistributing the Work and assume any
+   risks associated with Your exercise of permissions under this License.
+
+8. Limitation of Liability. In no event and under no legal theory,
+   whether in tort (including negligence), contract, or otherwise,
+   unless required by applicable law (such as deliberate and grossly
+   negligent acts) or agreed to in writing, shall any Contributor be
+   liable to You for damages, including any direct, indirect, special,
+   incidental, or consequential damages of any character arising as a
+   result of this License or out of the use or inability to use the
+   Work (including but not limited to damages for loss of goodwill,
+   work stoppage, computer failure or malfunction, or any and all
+   other commercial damages or losses), even if such Contributor
+   has been advised of the possibility of such damages.
+
+9. Accepting Warranty or Additional Liability. While redistributing
+   the Work or Derivative Works thereof, You may choose to offer,
+   and charge a fee for, acceptance of support, warranty, indemnity,
+   or other liability obligations and/or rights consistent with this
+   License. However, in accepting such obligations, You may act only
+   on Your own behalf and on Your sole responsibility, not on behalf
+   of any other Contributor, and only if You agree to indemnify,
+   defend, and hold each Contributor harmless for any liability
+   incurred by, or claims asserted against, such Contributor by reason
+   of your accepting any such warranty or additional liability.
+
+END OF TERMS AND CONDITIONS
+
+APPENDIX: How to apply the Apache License to your work.
+
+   To apply the Apache License to your work, attach the following
+   boilerplate notice, with the fields enclosed by brackets "[]"
+   replaced with your own identifying information. (Don't include
+   the brackets!)  The text should be enclosed in the appropriate
+   comment syntax for the file format. We also recommend that a
+   file or class name and description of purpose be included on the
+   same "printed page" as the copyright notice for easier
+   identification within third-party archives.
+
+Copyright [yyyy] [name of copyright owner]
+
+Licensed under the Apache License, Version 2.0 (the "License");
+you may not use this file except in compliance with the License.
+You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
diff --git a/providers/src/airflow/providers/postgres/__init__.py 
b/providers/postgres/src/airflow/providers/postgres/__init__.py
similarity index 100%
rename from providers/src/airflow/providers/postgres/__init__.py
rename to providers/postgres/src/airflow/providers/postgres/__init__.py
diff --git a/providers/tests/pgvector/operators/__init__.py 
b/providers/postgres/src/airflow/providers/postgres/assets/__init__.py
similarity index 100%
rename from providers/tests/pgvector/operators/__init__.py
rename to providers/postgres/src/airflow/providers/postgres/assets/__init__.py
diff --git a/providers/src/airflow/providers/postgres/assets/postgres.py 
b/providers/postgres/src/airflow/providers/postgres/assets/postgres.py
similarity index 100%
rename from providers/src/airflow/providers/postgres/assets/postgres.py
rename to providers/postgres/src/airflow/providers/postgres/assets/postgres.py
diff --git a/providers/tests/postgres/assets/__init__.py 
b/providers/postgres/src/airflow/providers/postgres/dialects/__init__.py
similarity index 100%
rename from providers/tests/postgres/assets/__init__.py
rename to providers/postgres/src/airflow/providers/postgres/dialects/__init__.py
diff --git a/providers/src/airflow/providers/postgres/dialects/postgres.py 
b/providers/postgres/src/airflow/providers/postgres/dialects/postgres.py
similarity index 100%
rename from providers/src/airflow/providers/postgres/dialects/postgres.py
rename to providers/postgres/src/airflow/providers/postgres/dialects/postgres.py
diff --git 
a/providers/postgres/src/airflow/providers/postgres/get_provider_info.py 
b/providers/postgres/src/airflow/providers/postgres/get_provider_info.py
new file mode 100644
index 00000000000..00b4d5e6265
--- /dev/null
+++ b/providers/postgres/src/airflow/providers/postgres/get_provider_info.py
@@ -0,0 +1,125 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+
+# NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE OVERWRITTEN!
+#
+# IF YOU WANT TO MODIFY THIS FILE, YOU SHOULD MODIFY THE TEMPLATE
+# `get_provider_info_TEMPLATE.py.jinja2` IN the 
`dev/breeze/src/airflow_breeze/templates` DIRECTORY
+
+
+def get_provider_info():
+    return {
+        "package-name": "apache-airflow-providers-postgres",
+        "name": "PostgreSQL",
+        "description": "`PostgreSQL <https://www.postgresql.org/>`__\n",
+        "state": "ready",
+        "source-date-epoch": 1734536300,
+        "versions": [
+            "6.0.0",
+            "5.14.0",
+            "5.13.1",
+            "5.13.0",
+            "5.12.0",
+            "5.11.3",
+            "5.11.2",
+            "5.11.1",
+            "5.11.0",
+            "5.10.2",
+            "5.10.1",
+            "5.10.0",
+            "5.9.0",
+            "5.8.0",
+            "5.7.1",
+            "5.7.0",
+            "5.6.1",
+            "5.6.0",
+            "5.5.2",
+            "5.5.1",
+            "5.5.0",
+            "5.4.0",
+            "5.3.1",
+            "5.3.0",
+            "5.2.2",
+            "5.2.1",
+            "5.2.0",
+            "5.1.0",
+            "5.0.0",
+            "4.1.0",
+            "4.0.1",
+            "4.0.0",
+            "3.0.0",
+            "2.4.0",
+            "2.3.0",
+            "2.2.0",
+            "2.1.0",
+            "2.0.0",
+            "1.0.2",
+            "1.0.1",
+            "1.0.0",
+        ],
+        "integrations": [
+            {
+                "integration-name": "PostgreSQL",
+                "external-doc-url": "https://www.postgresql.org/";,
+                "how-to-guide": [
+                    
"/docs/apache-airflow-providers-postgres/operators/postgres_operator_howto_guide.rst"
+                ],
+                "logo": "/docs/integration-logos/Postgres.png",
+                "tags": ["software"],
+            }
+        ],
+        "dialects": [
+            {
+                "dialect-type": "postgresql",
+                "dialect-class-name": 
"airflow.providers.postgres.dialects.postgres.PostgresDialect",
+            }
+        ],
+        "hooks": [
+            {
+                "integration-name": "PostgreSQL",
+                "python-modules": 
["airflow.providers.postgres.hooks.postgres"],
+            }
+        ],
+        "connection-types": [
+            {
+                "hook-class-name": 
"airflow.providers.postgres.hooks.postgres.PostgresHook",
+                "connection-type": "postgres",
+            }
+        ],
+        "asset-uris": [
+            {
+                "schemes": ["postgres", "postgresql"],
+                "handler": 
"airflow.providers.postgres.assets.postgres.sanitize_uri",
+            }
+        ],
+        "dataset-uris": [
+            {
+                "schemes": ["postgres", "postgresql"],
+                "handler": 
"airflow.providers.postgres.assets.postgres.sanitize_uri",
+            }
+        ],
+        "dependencies": [
+            "apache-airflow>=2.9.0",
+            "apache-airflow-providers-common-sql>=1.20.0",
+            "psycopg2-binary>=2.9.7",
+            "asyncpg>=0.30.0",
+        ],
+        "optional-dependencies": {
+            "amazon": ["apache-airflow-providers-amazon>=2.6.0"],
+            "openlineage": ["apache-airflow-providers-openlineage"],
+        },
+    }
diff --git a/providers/src/airflow/providers/postgres/hooks/__init__.py 
b/providers/postgres/src/airflow/providers/postgres/hooks/__init__.py
similarity index 100%
rename from providers/src/airflow/providers/postgres/hooks/__init__.py
rename to providers/postgres/src/airflow/providers/postgres/hooks/__init__.py
diff --git a/providers/src/airflow/providers/postgres/hooks/postgres.py 
b/providers/postgres/src/airflow/providers/postgres/hooks/postgres.py
similarity index 100%
rename from providers/src/airflow/providers/postgres/hooks/postgres.py
rename to providers/postgres/src/airflow/providers/postgres/hooks/postgres.py
diff --git a/providers/src/airflow/providers/pgvector/hooks/__init__.py 
b/providers/postgres/tests/conftest.py
similarity index 58%
rename from providers/src/airflow/providers/pgvector/hooks/__init__.py
rename to providers/postgres/tests/conftest.py
index c88b314548b..068fe6bbf5a 100644
--- a/providers/src/airflow/providers/pgvector/hooks/__init__.py
+++ b/providers/postgres/tests/conftest.py
@@ -1,4 +1,3 @@
-#
 # Licensed to the Apache Software Foundation (ASF) under one
 # or more contributor license agreements.  See the NOTICE file
 # distributed with this work for additional information
@@ -15,10 +14,19 @@
 # KIND, either express or implied.  See the License for the
 # specific language governing permissions and limitations
 # under the License.
-#
-# NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE
-# OVERWRITTEN WHEN PREPARING DOCUMENTATION FOR THE PACKAGES.
-#
-# IF YOU WANT TO MODIFY IT, YOU SHOULD MODIFY THE TEMPLATE
-# `PROVIDER__INIT__PY_TEMPLATE.py.jinja2` IN the `dev/provider_packages` 
DIRECTORY
-#
+from __future__ import annotations
+
+import pathlib
+
+import pytest
+
+pytest_plugins = "tests_common.pytest_plugin"
+
+
[email protected](tryfirst=True)
+def pytest_configure(config: pytest.Config) -> None:
+    deprecations_ignore_path = 
pathlib.Path(__file__).parent.joinpath("deprecations_ignore.yml")
+    dep_path = [deprecations_ignore_path] if deprecations_ignore_path.exists() 
else []
+    config.inicfg["airflow_deprecations_ignore"] = (
+        config.inicfg.get("airflow_deprecations_ignore", []) + dep_path  # 
type: ignore[assignment,operator]
+    )
diff --git a/providers/src/airflow/providers/postgres/assets/__init__.py 
b/providers/postgres/tests/provider_tests/__init__.py
similarity index 90%
rename from providers/src/airflow/providers/postgres/assets/__init__.py
rename to providers/postgres/tests/provider_tests/__init__.py
index 13a83393a91..e8fd2285643 100644
--- a/providers/src/airflow/providers/postgres/assets/__init__.py
+++ b/providers/postgres/tests/provider_tests/__init__.py
@@ -14,3 +14,4 @@
 # KIND, either express or implied.  See the License for the
 # specific language governing permissions and limitations
 # under the License.
+__path__ = __import__("pkgutil").extend_path(__path__, __name__)  # type: 
ignore
diff --git a/providers/tests/postgres/__init__.py 
b/providers/postgres/tests/provider_tests/postgres/__init__.py
similarity index 100%
rename from providers/tests/postgres/__init__.py
rename to providers/postgres/tests/provider_tests/postgres/__init__.py
diff --git a/providers/tests/postgres/dialects/__init__.py 
b/providers/postgres/tests/provider_tests/postgres/assets/__init__.py
similarity index 100%
rename from providers/tests/postgres/dialects/__init__.py
rename to providers/postgres/tests/provider_tests/postgres/assets/__init__.py
diff --git a/providers/tests/postgres/assets/test_postgres.py 
b/providers/postgres/tests/provider_tests/postgres/assets/test_postgres.py
similarity index 100%
rename from providers/tests/postgres/assets/test_postgres.py
rename to 
providers/postgres/tests/provider_tests/postgres/assets/test_postgres.py
diff --git a/providers/tests/system/pgvector/__init__.py 
b/providers/postgres/tests/provider_tests/postgres/dialects/__init__.py
similarity index 100%
rename from providers/tests/system/pgvector/__init__.py
rename to providers/postgres/tests/provider_tests/postgres/dialects/__init__.py
diff --git a/providers/tests/postgres/dialects/test_postgres.py 
b/providers/postgres/tests/provider_tests/postgres/dialects/test_postgres.py
similarity index 100%
rename from providers/tests/postgres/dialects/test_postgres.py
rename to 
providers/postgres/tests/provider_tests/postgres/dialects/test_postgres.py
diff --git a/providers/tests/postgres/hooks/__init__.py 
b/providers/postgres/tests/provider_tests/postgres/hooks/__init__.py
similarity index 100%
rename from providers/tests/postgres/hooks/__init__.py
rename to providers/postgres/tests/provider_tests/postgres/hooks/__init__.py
diff --git a/providers/tests/postgres/hooks/test_postgres.py 
b/providers/postgres/tests/provider_tests/postgres/hooks/test_postgres.py
similarity index 100%
rename from providers/tests/postgres/hooks/test_postgres.py
rename to 
providers/postgres/tests/provider_tests/postgres/hooks/test_postgres.py
diff --git a/providers/tests/system/postgres/__init__.py 
b/providers/postgres/tests/system/postgres/__init__.py
similarity index 100%
rename from providers/tests/system/postgres/__init__.py
rename to providers/postgres/tests/system/postgres/__init__.py
diff --git a/providers/tests/system/postgres/example_postgres.py 
b/providers/postgres/tests/system/postgres/example_postgres.py
similarity index 100%
rename from providers/tests/system/postgres/example_postgres.py
rename to providers/postgres/tests/system/postgres/example_postgres.py
diff --git a/pyproject.toml b/pyproject.toml
index e853e5f610a..c6448b61e84 100644
--- a/pyproject.toml
+++ b/pyproject.toml
@@ -621,7 +621,9 @@ dev = [
   "apache-airflow-providers-cohere",
   "apache-airflow-providers-common-sql",
   "apache-airflow-providers-edge",
+  "apache-airflow-providers-pgvector",
   "apache-airflow-providers-pinecone",
+  "apache-airflow-providers-postgres",
   "apache-airflow-providers-standard",
   "apache-airflow-providers-telegram",
   "apache-airflow-providers-weaviate",
@@ -641,6 +643,8 @@ apache-airflow-providers-cohere = { workspace = true }
 apache-airflow-providers-common-sql = { workspace = true }
 apache-airflow-providers-edge = {workspace = true}
 apache-airflow-providers-pinecone = { workspace = true }
+apache-airflow-providers-postgres = { workspace = true }
+apache-airflow-providers-pgvector = { workspace = true }
 apache-airflow-providers-standard = { workspace = true }
 apache-airflow-providers-telegram = { workspace = true }
 apache-airflow-providers-weaviate = { workspace = true }
@@ -658,6 +662,8 @@ members = [
     "providers/common/sql",
     "providers/edge",
     "providers/pinecone",
+    "providers/postgres",
+    "providers/pgvector",
     "providers/standard",
     "providers/telegram",
     "providers/weaviate",
diff --git a/scripts/ci/docker-compose/remove-sources.yml 
b/scripts/ci/docker-compose/remove-sources.yml
index 748b783bcab..a0d7e9c8649 100644
--- a/scripts/ci/docker-compose/remove-sources.yml
+++ b/scripts/ci/docker-compose/remove-sources.yml
@@ -39,7 +39,9 @@ services:
       - ../../../empty:/opt/airflow/providers/cohere/src
       - ../../../empty:/opt/airflow/providers/common/sql/src
       - ../../../empty:/opt/airflow/providers/edge/src
+      - ../../../empty:/opt/airflow/providers/pgvector/src
       - ../../../empty:/opt/airflow/providers/pinecone/src
+      - ../../../empty:/opt/airflow/providers/postgres/src
       - ../../../empty:/opt/airflow/providers/standard/src
       - ../../../empty:/opt/airflow/providers/telegram/src
       - ../../../empty:/opt/airflow/providers/weaviate/src
diff --git a/scripts/ci/docker-compose/tests-sources.yml 
b/scripts/ci/docker-compose/tests-sources.yml
index e0593c48c1c..e0a91484162 100644
--- a/scripts/ci/docker-compose/tests-sources.yml
+++ b/scripts/ci/docker-compose/tests-sources.yml
@@ -46,7 +46,9 @@ services:
       - ../../../providers/cohere/tests:/opt/airflow/providers/cohere/tests
       - 
../../../providers/common/sql/tests:/opt/airflow/providers/common/sql/tests
       - ../../../providers/edge/tests:/opt/airflow/providers/edge/tests
+      - ../../../providers/pgvector/tests:/opt/airflow/providers/pgvector/tests
       - ../../../providers/pinecone/tests:/opt/airflow/providers/pinecone/tests
+      - ../../../providers/postgres/tests:/opt/airflow/providers/postgres/tests
       - ../../../providers/standard/tests:/opt/airflow/providers/standard/tests
       - ../../../providers/telegram/tests:/opt/airflow/providers/telegram/tests
       - ../../../providers/weaviate/tests:/opt/airflow/providers/weaviate/tests

Reply via email to