activebreak We don't have pgsql-12 available yet, so you would have to install your own instance from source. To do that, create a new NGINX proxy port app and note the assigned port. For the sake of this example we'll call it psql and assume the port is 15481 but you will need to replace them with your own values. It will create a psql user after the shell user that you use when setting it up so be sure to update those values too in the superuser steps.
#Download, install, and configure
cd ~/apps/psql
wget https://ftp.postgresql.org/pub/source/v12.14/postgresql-12.14.tar.gz
tar zxf postgresql-12.14.tar.gz
export PGHOME=$HOME/apps/psql/
export PGDATA=$HOME/apps/psql/pgdata
./postgresql-12.14/configure --prefix=$PGHOME
make
make install
mkdir $PGDATA
$PGHOME/bin/initdb -D $PGDATA
rm -rf postgresql-12.14 postgresql-12.14.tar.gz Makefile
sed -i 's/#port = 5432/port = 15481/g' $PGDATA/postgresql.conf
#Version check
./bin/postgres -V
postgres (PostgreSQL) 12.14
#Immediately setup superuser **DO NOT SKIP**
~/apps/psql/bin/pg_ctl -D ~/apps/psql/pgdata -l logfile start
~/apps/psql/bin/psql -h localhost -p 15481 -d postgres
ALTER USER your_shelluser WITH PASSWORD 'your_password';
exit
sed -i 's/trust/md5/g' $PGDATA/pg_hba.conf
~/apps/psql/bin/pg_ctl -D ~/apps/psql/pgdata -l logfile restart
#Commands to stop, start, restart, and connect
~/apps/psql/bin/pg_ctl -D ~/apps/psql/pgdata stop
~/apps/psql/bin/pg_ctl -D ~/apps/psql/pgdata -l logfile start
~/apps/psql/bin/pg_ctl -D ~/apps/psql/pgdata -l logfile restart
~/apps/psql/bin/psql -h localhost -p 15481 -d postgres -U your_shelluser
You should then be able to export the database from this instance and import it into ours when we update it. But we will address that when the time comes.
Hope this helps!
