Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for newer version of Postgres #38182

Closed
czomo opened this issue May 14, 2024 · 7 comments
Closed

Support for newer version of Postgres #38182

czomo opened this issue May 14, 2024 · 7 comments
Labels
area/documentation Improvements or additions to documentation autoteam community team/deployments

Comments

@czomo
Copy link

czomo commented May 14, 2024

Topic

postgres platform 13 database

Relevant information

Currently, Airbyte requires connection to a Postgres 13 instance.

As docs states airbyte platform support only postgres13 as database backend. EOL for postgres 13 is 13 Nov 2025(Ends in 1 year and 6 months) https://endoflife.date/postgresql

Are there any plans for work on this field?

@marcosmarxm
Copy link
Member

@czomo, this feature is already supported, but the documentation hasn't been updated yet. @bgroff can you confirm this?

@marcosmarxm marcosmarxm added area/documentation Improvements or additions to documentation team/deployments and removed needs-triage team/use labels May 16, 2024
@mathetes87
Copy link

It would be great to know if newer versions are already supported. I've been trying to use neon.tech as the database and they only support versions 14 to 16. I was facing a number of errors originating from the airbyte-temporal container in a vanilla database and I assumed it was due to the postgres version!

@mathetes87
Copy link

Please, any information on this? @bgroff

@hongbo-miao
Copy link
Contributor

hongbo-miao commented Jun 30, 2024

It actually supports well. I have opened the pull request and removed the limitation in the doc #39510

I succeed with a clean Postgres 16.3, I have published all deployment codes using Terraform at hongbo-miao/hongbomiao.com#17463 (comment) 😃
And all issues I met and solutions as well in first comment 😉

The only thing is Airbyte copied temporalio/auto-setup old script instead of pointing to it, and it has not been updated to latest version yet, so current workaround solution is disabling rds.force_ssl (I posted details at #39636) Anyway my deployment codes mentioned this issue and covered it as well.

Hope it helps!

@mathetes87
Copy link

That is super useful to know! Thanks!

@joeybenamy
Copy link

Looking for info on Postgres 17 support.

@marcosmarxm
Copy link
Member

This discussion was solved as Airbyte now support Postgres+13. I created an issue to improve the documentation to inform min/max version supported as external database: #48542

@joeybenamy please add your comment there.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/documentation Improvements or additions to documentation autoteam community team/deployments
Projects
None yet
Development

No branches or pull requests

6 participants