Read https://github.com/shiftkey/desktop/

wget -qO - https://mirror.mwt.me/shiftkey-desktop/gpgkey | gpg --dearmor | sudo tee /usr/share/keyrings/mwt-desktop.gpg > /dev/null
sudo sh -c 'echo "deb [arch=amd64 signed-by=/usr/share/keyrings/mwt-desktop.gpg] https://mirror.mwt.me/shiftkey-desktop/deb/ any main" > /etc/apt/sources.list.d/mwt-desktop.list'

sudo apt update && sudo apt install github-desktop

https://www.postgresql.org/download/linux/ubuntu/

After installation give the user postgres a password. Use psql on a terminal. The password is needed to be able to use pgadmin4. Both applications are running on localhost.

# in bash terminal login as user postgres who has access to the databases.
sudo -i -u postgres

# start the CLI
psql

# set the password for user postgres
ALTER USER postgres WITH PASSWORD 'your_new_password';

Often not need bot nn case you want to or have to alter the `pg_hba.conf`file:

# Add the following to pg_hba.conf:
host    all             postgres            127.0.0.1/32            md5

Restart PostgreSQL after making changes to the pg_hba.conf file:

sudo systemctl restart postgresql