PostgreSQL 7.4

End of life

7.4.30 Release notes ↗

Is PostgreSQL 7.4 still supported?

No

PostgreSQL 7.4 reached end of life on Oct 1, 2010 (16 years ago). It no longer gets updates, including security fixes. Upgrade to PostgreSQL 18 (latest 18.6), supported until Nov 14, 2030.

Released
Nov 17, 2003
End of life
Oct 1, 2010
16 years ago
Latest version
7.4.30
Oct 1, 2010

Upgrade path

The recommended upgrade is PostgreSQL 18, currently at 18.6 and supported until Nov 14, 2030.

Not sure? Run psql -c "SELECT version();"

How to upgrade from PostgreSQL 7.4 to PostgreSQL 18

Minor releases (e.g. 18.x to 18.6) never need a dump or pg_upgrade: install the packages and restart. A new major version does.

Ubuntu / Debian (PGDG repository)

sudo apt update
sudo apt install --only-upgrade postgresql-18
sudo systemctl restart postgresql

New major version on Ubuntu / Debian

sudo apt install postgresql-18
pg_lsclusters

Then run sudo pg_upgradecluster <old-version> main. It migrates the old cluster onto version 18.

Docker

docker pull postgres:18

Official upgrade guide ↗ Back up first, and test on a non-production machine when you move to a new branch.

Quick answers

Is PostgreSQL 7.4 still supported?
No. PostgreSQL 7.4 reached end of life on Oct 1, 2010 (16 years ago). It no longer gets updates, including security fixes. Upgrade to PostgreSQL 18 (latest 18.6), supported until Nov 14, 2030.
When is PostgreSQL 7.4 end of life?
PostgreSQL 7.4 reached end of life on Oct 1, 2010. It gets no more updates, including security fixes.
What is the latest version of PostgreSQL 7.4?
The latest PostgreSQL 7.4 release is 7.4.30, released on Oct 1, 2010.
When was PostgreSQL 7.4 released?
PostgreSQL 7.4 was released on Nov 17, 2003.
What should I upgrade PostgreSQL 7.4 to?
The recommended upgrade is PostgreSQL 18, currently at 18.6 and supported until Nov 14, 2030.
How do I check which PostgreSQL version I have?
Run psql -c "SELECT version();", then paste the result into the “Am I up to date?” box on this page.

Other PostgreSQL branches

All 29 →
  • 9.0 End of life
  • 8.4 End of life
  • 8.3 End of life
  • 8.2 End of life
  • 8.1 End of life
  • 8.0 End of life
  • 7.4 End of life
  • 7.3 End of life
  • 7.2 End of life
  • 7.1 End of life
  • 7.0 End of life
  • 6.5 End of life
  • 6.4 End of life

← PostgreSQL 7.3 PostgreSQL 8.0 →

PostgreSQL 7.4 release history

RSS

Release dates for 31 PostgreSQL 7.4 versions, newest first.

  1. 7.4.30
  2. 7.4.29
  3. 7.4.28
  4. 7.4.27
  5. 7.4.26
  6. 7.4.25
  7. 7.4.24
  8. 7.4.23
  9. 7.4.22
  10. 7.4.21
All 31 releases
  1. 7.4.20
  2. 7.4.19
  3. 7.4.18
  4. 7.4.17
  5. 7.4.16
  6. 7.4.15
  7. 7.4.14
  8. 7.4.13
  9. 7.4.12
  10. 7.4.11
  11. 7.4.10
  12. 7.4.9
  13. 7.4.8
  14. 7.4.7
  15. 7.4.6
  16. 7.4.5
  17. 7.4.4
  18. 7.4.3
  19. 7.4.2
  20. 7.4.1
  21. 7.4

Keep track

PostgreSQL 7.4 latest version badge

People who run PostgreSQL 7.4 also check

Official release policy · Checked 2 hours ago