better-postgres4cP/lib/Troglodyne/CpPostgreSQL.pm

package Troglodyne::CpPostgreSQL;

use strict;
use warnings;

our %REPO_RPM_URLS = (
    '8' => 'https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm',
    '7' => 'https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm',
    '6' => 'https://download.postgresql.org/pub/repos/yum/reporpms/EL-6-x86_64/pgdg-redhat-repo-latest.noarch.rpm',
);

# Repository entries will look like "pgdg$VERSION" -- ex. pgdg95
our $REPO_PREFIX = 'pgdg';
our $PKG_PREFIX = 'postgresql';
our $MINIMUM_SUPPORTED_VERSION = '9.5';

# Times are in seconds since epoch, as that allows easier localization.
our %SUPPORTED_VERSIONS_MAP = (
    '9.5' => {
        'release'  => 1452146400,
        'EOL'      => 1613023200,
        'features' => [ 'INSERTS with constraint conflicts can be turned into UPDATEs or ignored', 'Row-level security control', 'Adds Block Range Indexes' ],
    },
    '9.6' => {
        'release'  => 1475125200,
        'EOL'      => 1636610400,
        'features' => [ 'Synchronous replication now allows multiple standby servers', 'Full-text search can now search for phrases', 'Substantial performance improvements' ],
     },
    '10'  => {
        'release'  => 1507179600,
        'EOL'      => 1668060000,
        'features' => [ 'Logical replication using publish/subscribe', 'Significant general performance improvements', 'Stronger password authentication', 'Improved monitoring and control' ],
     },
    # Note -- The below can't actually be installed due to needing lvm-toolset-7-clang
    #'11'  => {
    #    'release'  => 1539838800,
    #    'EOL'      => 1699509600,
    #    'features' => [ 'Improvements to partitioning and parallelism', 'SQL stored procedures that support embedded transactions', 'Many other useful performance improvements' ]
    # },
    #'12'  => {
    #    'release'  => 1570078800,
    #    'EOL'      => 1731564000,
    #    'features' => [ 'General performance improvements', 'Stored generated columns', 'Support for the SQL/JSON path language', 'New authentication features' ]
    #},
);

# The BS that cPanel will be installing with /scripts/installpostgres
our %CP_UNSUPPORTED_VERSIONS_MAP = (
    '9.2' => { 'release' => 1347253200, 'EOL' => 1510207200 }, # Cent 7
    '8.4' => { 'release' => 1246424400, 'EOL' => 1406178000 }, # Cent 6
);

# The cPanel version is a joke. You have to further massage data.
sub get_version {
    require Cpanel::PostgresUtils;
    my @cur_ver = ( Cpanel::PostgresUtils::get_version() );
    if(!$cur_ver[0]) {

        # Chop off the bullshit error message -- "Failed to determine postgresql version: "
        # If we start at the end, that's 40 chars
        my $str = substr( $cur_ver[1], 40 );
        @cur_ver = $cur_ver[1] =~ m/(\d+)\.(\d+)$/;
    }
    return @cur_ver;
}

1;