If you’re using Lubuntu or switch from Gnome to KDE Plasma, chances are your apps installed by using snap / or Ubuntu store are missing. The following single command will help bring them back
# Link all shortcuts installed by snap to .local/share/applications, that's it! ln -s /var/lib/snapd/desktop/applications/* ~/.local/share/applications
The following commands will help you quickly install Postgresql latest version 13 or a custom version on your Ubuntu/Debian machine
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update # If you want a specific version, use 'postgresql-12' or similar instead of 'postgresql': sudo apt-get -y install postgresql
Of course you can also install some other packages that would help during software development or usage:
postgresql-client-12 : client libraries and client binaries
postgresql-contrib-9.x : additional supplied modules (part of the postgresql-xx package in version 10 and later)
libpq-dev : libraries and headers for C language frontend development
postgresql-server-dev-12 : libraries and headers for C language backend development
pgadmin4 : pgAdmin 4 graphical administration utility
Lubuntu is a lightweight and great operating system, unfortunately it doesn’t include a default theme that is easy for changing the default avatar. I found the following trick that might help.
First, let’s find a favorite photo that you want to set up as an avatar, then use one of the website like this to convert the photo into an icon (.ico) file: https://icoconvert.com/
Don’t worry for the .ico, it’s not a very low favicon.ico you often see. Next we need to copy this file to the following location: /usr/share/sddm/faces/ with the name like YOUR_NAME.face.icon, with YOUR_NAME is your linux login. And that’s it, you can then restart your computer for a check.
# please change YOUR_NAME and avatar.ico according to your local sudo cp Downloads/avatar.ico /usr/share/sddm/faces/YOUR_NAME.face.icon reboot