phppgadmin is not in the debian repo

[mwendwa5]

Describe the problem:

The installation is still configured to use Debian repos to install phppgadmin.

Type here what is the problem Installation cannot proceed if PostgreSQL is selected for installation.

Steps to Reproduce:

sudo bash vst-install-debian.sh --postgresql yes

Type here what we should do in order to see the bug on our test server Start installation with PostgreSQL selected.

Debian version:

Debian 12 Type here, example: Debian 10

VestaCP Version:

Most recent Type here, example: 0.9.8.26-29

Installed Software (what you got with the installer):

Installation does not proceed.

###Suggested fix -- copied from VestaCP installation file with few modifications

#----------------------------------------------------------#
#                   Configure PostgreSQL                   #
#----------------------------------------------------------#
if [ "$postgresql" = 'yes' ]; then
    echo "=== Configure PostgreSQL"
    ppass=$(gen_pass)
    cp -f $vestacp/postgresql/pg_hba.conf /etc/postgresql/*/main/
    currentservice='postgresql' 
    ensure_startup $currentservice
    ensure_start $currentservice
    sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '$ppass'"

	wget --retry-connrefused --quiet https://github.com/hestiacp/phppgadmin/releases/download/v$pga_v/phppgadmin-v$pga_v.tar.gz
    tar xzf phppgadmin-v$pga_v.tar.gz -C /usr/share/phppgadmin/
    
    # Configuring phpPgAdmin
    if [ "$apache" = 'yes' ]; then
        cp -f $vestacp/pga/phppgadmin.conf /etc/apache2/conf.d/
    fi
    cp -f $vestacp/pga/config.inc.php /etc/phppgadmin/
	ln -s /etc/phppgadmin/config.inc.php /usr/share/phppgadmin/conf/
	rm phppgadmin-v$pga_v.tar.gz
    write_config_value "DB_PGA_ALIAS" "phppgadmin"
fi