<h2>Edit File - installpostgres</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/usr/local/cpanel/scripts/installpostgres">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">#!/usr/local/cpanel/3rdparty/bin/perl

#                                      Copyright 2025 WebPros International, LLC
#                                                           All rights reserved.
# copyright@cpanel.net                                         http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited.

package scripts::installpostgres;

use strict;
use warnings;

use Cpanel::Debug                 ();
use Cpanel::OS                    ();
use Cpanel::SafeRun::Simple       ();
use Cpanel::SysPkgs               ();
use Cpanel::Chkservd::Manage      ();
use Cpanel::PostgresUtils         ();
use Cpanel::PostgresUtils::PgPass ();
use Cpanel::ServerTasks           ();
use Whostmgr::Postgres            ();

exit( run(@ARGV) // 0 ) unless caller();

sub help {
    my $msg = &lt;&lt;EOF;
Usage: installpostgres [--help] [--yes]

    Installs the supported version of PostgreSQL.

Options:

    --help          This message.
    --yes           Bypass confirmation prompt.

EOF

    print $msg;

    return 0;
}

sub prompt {
    my ( $message, @args ) = @_;

    chomp $message;
    print $message;

    if ( !@args || $args[0] !~ /\-\-yes/ ) {
        my $res = &lt;STDIN&gt;;
        if ( $res !~ /^y/i ) {
            print &quot;Exiting...\n&quot;;
            exit();
        }
    }

    return;
}

# replace system calls
sub _run_and_log_cmd {    ## no critic(RequireArgUnpacking) # doesn&#039;t make sense in this case
    Cpanel::Debug::log_debug( &#039;[EXEC] &#039; . join( &quot; &quot;, @_ ) );
    my $out = Cpanel::SafeRun::Simple::saferunallerrors(@_);
    chomp($out);
    Cpanel::Debug::log_info($out);
    return $out;
}

# Get more info with CPANEL_DEBUG_LEVEL set
sub _debug_run_and_log_cmd {    ## no critic(RequireArgUnpacking) # doesn&#039;t make sense in this case
    Cpanel::Debug::log_debug( &#039;[EXEC] &#039; . join( &quot; &quot;, @_ ) ) if $Cpanel::Debug::level;
    my $out = Cpanel::SafeRun::Simple::saferunallerrors(@_);
    chomp($out);
    Cpanel::Debug::log_debug($out) if $Cpanel::Debug::level;
    return $out;
}

sub run {
    my @args = @_;

    return help() if grep { $_ eq &#039;--help&#039; } @args;

    die &quot;cPanel does not support PostgreSQL on this system at this time!&quot; unless Cpanel::OS::supports_postgresql();

    my $restart_instruction = &quot;\tsystemctl restart postgresql&quot;;
    my $minversion          = Cpanel::OS::postgresql_minimum_supported_version() . &#039;.x&#039;;

    if ( my $old_pg_home = Cpanel::PostgresUtils::find_pgsql_home() ) {
        my $notice = &lt;&lt;&quot;EOS&quot;;
This script installs PostgreSQL $minversion or later.
If your system runs an older version of PostgreSQL, you must
dump your databases to a file, and then restore them after
installation.
PostgreSQL $minversion is NOT backwards compatible.
If no PostgreSQL databases exist on your system, run the
following command to force the creation of a PostgreSQL $minversion -style
setup:
\tmv $old_pg_home $old_pg_home.old
$restart_instruction
Do not run this command if databases exist that you wish to keep!
Are you certain that you wish to proceed? [y/(n)]:
EOS

        prompt( $notice, @args );
    }
    else {
        my $notice = &lt;&lt;&quot;EOS&quot;;
This script installs PostgreSQL $minversion or later.
Are you certain that you wish to proceed? [y/(n)]:
EOS

        prompt( $notice, @args );
    }

    Cpanel::Debug::log_info(&quot;Installing Postgres...&quot;);

    my $syspkgobj = Cpanel::SysPkgs-&gt;new();
    if ( !$syspkgobj ) { die Cpanel::Debug::log_error(&quot;The system could not create the SysPkgs object.&quot;); }

    $syspkgobj-&gt;install( &#039;pkglist&#039; =&gt; Cpanel::OS::postgresql_packages() );

    my $pg_user = Cpanel::PostgresUtils::PgPass::getpostgresuser();
    my $pg_home = Cpanel::PostgresUtils::find_pgsql_home( &#039;user&#039; =&gt; $pg_user );
    my $pg_data = Cpanel::PostgresUtils::find_pgsql_data( &#039;home&#039; =&gt; $pg_home );

    my @cmd;

    foreach my $alias ( @{ Cpanel::OS::postgresql_service_aliases() } ) {
        my $service = &#039;postgresql&#039;;
        if ( !-e &quot;/etc/init.d/$service&quot; &amp;&amp; -e &quot;/etc/init.d/$alias&quot; ) {
            symlink( $alias, &quot;/etc/init.d/$service&quot; );
        }
    }

    if ( !-e &quot;$pg_data/global&quot; ) {
        foreach my $cmd ( @{ Cpanel::OS::postgresql_initdb_commands() } ) {
            @cmd = split &#039; &#039;, $cmd;
            _debug_run_and_log_cmd(@cmd);
        }
    }

    @cmd = qw{/usr/local/cpanel/scripts/cpservice postgresql enable 35};
    _debug_run_and_log_cmd(@cmd);

    @cmd = qw{/usr/local/cpanel/scripts/cpservice postgresql start};
    _debug_run_and_log_cmd(@cmd);

    @cmd = qw{/usr/local/cpanel/scripts/setpostgresconfig --force};
    _debug_run_and_log_cmd(@cmd);

    my ( $status, $message );
    Cpanel::Debug::log_info(&quot;Updating postgresql configuration now...&quot;);
    ( $status, $message ) = Whostmgr::Postgres::update_config();
    print $message. &quot;\n&quot; if $message;

    Cpanel::Debug::log_info(&quot;Attempting to restart postgresql...&quot;);
    @cmd = qw{/usr/local/cpanel/scripts/restartsrv postgresql};
    _debug_run_and_log_cmd(@cmd);
    my $install_ok = $? == 0 ? 1 : 0;

    if ($install_ok) {

        Cpanel::Debug::log_info(&quot;Creating dbowners for existing cpusers...&quot;);
        ( $status, $message ) = Whostmgr::Postgres::create_dbowners_for_cpusers();
        print $message. &quot;\n&quot;;

        $install_ok &amp;&amp;= $status;

        if ($install_ok) {

            print q{

The PostgreSQL packages successfully installed. To configure PostgreSQL,
set your password, and enable PostgreSQL for user accounts, navigate to
WHM&#039;s Configure PostgreSQL interface (Home &gt;&gt; SQL Services &gt;&gt; Configure PostgreSQL).

};
            print &quot;Setting a random password for the PostgreSQL database user.\n&quot;;

            _debug_run_and_log_cmd( &#039;/usr/local/cpanel/bin/postgrescheck&#039;, &#039;--check-auth&#039;, &#039;--reset-pass-on-fail&#039; );

            _debug_run_and_log_cmd(&#039;/usr/local/cpanel/bin/cpsessetup&#039;);

            # If PostgreSQL has never been listed under chkservd, enable monitoring for it.
            # (This might happen if the service was uninstalled manually but reinstalled with this script.)
            # Doing this prevents /scripts/check_unmonitored_enabled_services from complaining to the admin
            # who is installing PostgreSQL for the first time on this system.
            my %MONITORED = Cpanel::Chkservd::Manage::getmonitored();
            Cpanel::Chkservd::Manage::enable(&#039;postgresql&#039;) unless exists $MONITORED{&#039;postgresql&#039;};
        }
    }

    # install_ok value can change in the previous block
    if ( !$install_ok ) {
        print STDERR qq{The PostgreSQL installation failed!\n};
    }

    # reset haspostgres if great success
    Cpanel::ServerTasks::schedule_task( [&#039;CpDBTasks&#039;], 5, &#039;build_global_cache&#039; ) if $install_ok;

    return $install_ok ? 0 : 1;
}

1;
</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/blog/images/1781637752_1754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>