if we look at this link : https://www.postgresql.org/download/linux/ubuntu/
I want to know if this means that the compatible version of postgresq with ubuntu is 12 or later ? so is postgresq 9.6 compatible withr ubuntu 20 ?
CodePudding user response：
PostgreSQL 9.6 is no longer supported officially. https://www.postgresql.org/support/versioning/.
However, you could still try to follow steps such as: https://www.howtodojo.com/install-postgresql-9-6-ubuntu-20-04/. Since this guide adds the source manually, it should work.
CodePudding user response：
There are two ways to get Postgres from apt on Ubuntu:
Use the Ubuntu repo's which will be restricted to the version of Postgres that was most current when the Ubuntu distro was released. That version will get the minor version updates over the life of the Ubuntu distro e.g. 12.0, 12.1, 12.3, etc.
Use the Postgres community repos PGDG repo Wiki as shown under PostgreSQL Apt Repository here PG Ubuntu downloads. Then you have the choice of downloading a variety of versions, with the supported ones listed at the Wiki link posted above. You can download 9.6 on Ubuntu 20 from here. It has no community support though, so there will be no bug/security fixes to it.