1. 5
  1.  

  2. 4

    PostgreSQL 8.4.1 on CentOS Linux

    This post is either old, or examining outdated technology. Postgresql has had sql-92-style updatable views since 9.3 (three years ago), and more complicated updatable views since 9.4 (two years ago). The version they’re examining was released in 2009.

    (Edit: obviously, there are other differences, too, but since that was first on the page, it’s what made me go back and check their versions)

    1. 1

      Well, some of us are stuck with the Windows NT 4.0 version of CentOS (aka CentOS 6.6, the last release that didn’t have systemd) and yeah it packages PostgreSQL 8.4.20

      1. 4

        That’s fine, but it’s not timely. Current postgres is 9.5. The 8 series is no longer supported, and hasn’t been for a year or more.

        1. 4

          Where possible (which it might not always be, I know) you should migrate to using the releases from http://yum.postgresql.org/ which provides all non-EOL releases of PostgreSQL for CentOS5, 6 and 7.