Install Docker on Debian 12

 apt install ca-certificates curl
install -m 0755 -d /etc/apt/keyrings

 curl -fsSL https://download.docker.com/linux/debian/gpg -o /etc/apt/keyrings/docker.asc
 chmod a+r /etc/apt/keyrings/docker.asc

echo "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/debian $(. /etc/os-release && echo "$VERSION_CODENAME") stable" | \
   tee /etc/apt/sources.list.d/docker.list > /dev/null
 apt update

apt-cache madison docker-ce | awk '{ print $3 }'

VERSION_STRING="5:26.1.3-1~debian.12~bookworm"
 apt-get install docker-ce=$VERSION_STRING docker-ce-cli=$VERSION_STRING containerd.io docker-buildx-plugin docker-compose-plugin

Upgrade Debian Kernel

Replace buster with suitable version

echo "deb http://ftp.debian.org/debian buster-backports main" | sudo tee -a /etc/apt/sources.list > /dev/null

sudo apt-get -t buster-backports upgrade

apt search Linux-image

result look like (with first phrase split by slash is image name which can install-able)

linux-headers-4.19.0-6-amd64/stable 4.19.67-2+deb10u2 amd64
  Header files for Linux 4.19.0-6-amd64

linux-headers-4.19.0-6-cloud-amd64/stable 4.19.67-2+deb10u2 amd64
  Header files for Linux 4.19.0-6-cloud-amd64

linux-headers-4.19.0-6-rt-amd64/stable 4.19.67-2+deb10u2 amd64
  Header files for Linux 4.19.0-6-rt-amd64

linux-headers-4.19.0-8-amd64/stable,stable 4.19.98-1 amd64
  Header files for Linux 4.19.0-8-amd64

linux-headers-4.19.0-8-cloud-amd64/stable,stable 4.19.98-1 amd64
  Header files for Linux 4.19.0-8-cloud-amd64

linux-headers-4.19.0-8-rt-amd64/stable,stable 4.19.98-1 amd64
  Header files for Linux 4.19.0-8-rt-amd64

linux-headers-5.4.0-0.bpo.2-amd64/buster-backports 5.4.8-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.2-amd64

linux-headers-5.4.0-0.bpo.2-cloud-amd64/buster-backports 5.4.8-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.2-cloud-amd64

linux-headers-5.4.0-0.bpo.2-rt-amd64/buster-backports 5.4.8-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.2-rt-amd64

linux-headers-5.4.0-0.bpo.3-amd64/buster-backports 5.4.13-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.3-amd64

linux-headers-5.4.0-0.bpo.3-cloud-amd64/buster-backports 5.4.13-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.3-cloud-amd64

linux-headers-5.4.0-0.bpo.3-rt-amd64/buster-backports 5.4.13-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.3-rt-amd64

linux-headers-5.4.0-0.bpo.4-amd64/buster-backports 5.4.19-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.4-amd64

linux-headers-5.4.0-0.bpo.4-cloud-amd64/buster-backports 5.4.19-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.4-cloud-amd64

linux-headers-5.4.0-0.bpo.4-rt-amd64/buster-backports 5.4.19-1~bpo10+1 amd64
  Header files for Linux 5.4.0-0.bpo.4-rt-amd64

linux-image-4.19.0-6-amd64/stable 4.19.67-2+deb10u2 amd64
  Linux 4.19 for 64-bit PCs (signed)

linux-image-4.19.0-6-amd64-dbg/stable 4.19.67-2+deb10u2 amd64
  Debug symbols for linux-image-4.19.0-6-amd64

linux-image-4.19.0-6-amd64-unsigned/stable 4.19.67-2+deb10u2 amd64
  Linux 4.19 for 64-bit PCs

linux-image-4.19.0-6-cloud-amd64/stable 4.19.67-2+deb10u2 amd64
  Linux 4.19 for x86-64 cloud (signed)

linux-image-4.19.0-6-cloud-amd64-dbg/stable 4.19.67-2+deb10u2 amd64
  Debug symbols for linux-image-4.19.0-6-cloud-amd64

linux-image-4.19.0-6-cloud-amd64-unsigned/stable 4.19.67-2+deb10u2 amd64
  Linux 4.19 for x86-64 cloud

linux-image-4.19.0-6-rt-amd64/stable 4.19.67-2+deb10u2 amd64
  Linux 4.19 for 64-bit PCs, PREEMPT_RT (signed)

linux-image-4.19.0-6-rt-amd64-dbg/stable 4.19.67-2+deb10u2 amd64
  Debug symbols for linux-image-4.19.0-6-rt-amd64

linux-image-4.19.0-6-rt-amd64-unsigned/stable 4.19.67-2+deb10u2 amd64
  Linux 4.19 for 64-bit PCs, PREEMPT_RT

linux-image-4.19.0-8-amd64/stable,stable,now 4.19.98-1 amd64 [installed]
  Linux 4.19 for 64-bit PCs (signed)

linux-image-4.19.0-8-amd64-dbg/stable,stable 4.19.98-1 amd64
  Debug symbols for linux-image-4.19.0-8-amd64

linux-image-4.19.0-8-amd64-unsigned/stable,stable 4.19.98-1 amd64
  Linux 4.19 for 64-bit PCs

linux-image-4.19.0-8-cloud-amd64/stable,stable 4.19.98-1 amd64
  Linux 4.19 for x86-64 cloud (signed)

linux-image-4.19.0-8-cloud-amd64-dbg/stable,stable 4.19.98-1 amd64
  Debug symbols for linux-image-4.19.0-8-cloud-amd64

linux-image-4.19.0-8-cloud-amd64-unsigned/stable,stable 4.19.98-1 amd64
  Linux 4.19 for x86-64 cloud

linux-image-4.19.0-8-rt-amd64/stable,stable 4.19.98-1 amd64
  Linux 4.19 for 64-bit PCs, PREEMPT_RT (signed)

linux-image-4.19.0-8-rt-amd64-dbg/stable,stable 4.19.98-1 amd64
  Debug symbols for linux-image-4.19.0-8-rt-amd64

linux-image-4.19.0-8-rt-amd64-unsigned/stable,stable 4.19.98-1 amd64
  Linux 4.19 for 64-bit PCs, PREEMPT_RT

linux-image-5.4.0-0.bpo.2-amd64/buster-backports,now 5.4.8-1~bpo10+1 amd64 [installed]
  Linux 5.4 for 64-bit PCs (signed)

linux-image-5.4.0-0.bpo.2-amd64-dbg/buster-backports 5.4.8-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.2-amd64

linux-image-5.4.0-0.bpo.2-amd64-unsigned/buster-backports 5.4.8-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs

linux-image-5.4.0-0.bpo.2-cloud-amd64/buster-backports 5.4.8-1~bpo10+1 amd64
  Linux 5.4 for x86-64 cloud (signed)

linux-image-5.4.0-0.bpo.2-cloud-amd64-dbg/buster-backports 5.4.8-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.2-cloud-amd64

linux-image-5.4.0-0.bpo.2-cloud-amd64-unsigned/buster-backports 5.4.8-1~bpo10+1 amd64
  Linux 5.4 for x86-64 cloud

linux-image-5.4.0-0.bpo.2-rt-amd64/buster-backports 5.4.8-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs, PREEMPT_RT (signed)

linux-image-5.4.0-0.bpo.2-rt-amd64-dbg/buster-backports 5.4.8-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.2-rt-amd64

linux-image-5.4.0-0.bpo.2-rt-amd64-unsigned/buster-backports 5.4.8-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs, PREEMPT_RT

linux-image-5.4.0-0.bpo.3-amd64/buster-backports 5.4.13-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs (signed)

linux-image-5.4.0-0.bpo.3-amd64-dbg/buster-backports 5.4.13-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.3-amd64

linux-image-5.4.0-0.bpo.3-amd64-unsigned/buster-backports 5.4.13-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs

linux-image-5.4.0-0.bpo.3-cloud-amd64/buster-backports 5.4.13-1~bpo10+1 amd64
  Linux 5.4 for x86-64 cloud (signed)

linux-image-5.4.0-0.bpo.3-cloud-amd64-dbg/buster-backports 5.4.13-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.3-cloud-amd64

linux-image-5.4.0-0.bpo.3-cloud-amd64-unsigned/buster-backports 5.4.13-1~bpo10+1 amd64
  Linux 5.4 for x86-64 cloud

linux-image-5.4.0-0.bpo.3-rt-amd64/buster-backports 5.4.13-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs, PREEMPT_RT (signed)

linux-image-5.4.0-0.bpo.3-rt-amd64-dbg/buster-backports 5.4.13-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.3-rt-amd64

linux-image-5.4.0-0.bpo.3-rt-amd64-unsigned/buster-backports 5.4.13-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs, PREEMPT_RT

linux-image-5.4.0-0.bpo.4-amd64/buster-backports,now 5.4.19-1~bpo10+1 amd64 [installed]
  Linux 5.4 for 64-bit PCs (signed)

linux-image-5.4.0-0.bpo.4-amd64-dbg/buster-backports 5.4.19-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.4-amd64

linux-image-5.4.0-0.bpo.4-amd64-unsigned/buster-backports 5.4.19-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs

linux-image-5.4.0-0.bpo.4-cloud-amd64/buster-backports 5.4.19-1~bpo10+1 amd64
  Linux 5.4 for x86-64 cloud (signed)

linux-image-5.4.0-0.bpo.4-cloud-amd64-dbg/buster-backports 5.4.19-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.4-cloud-amd64

linux-image-5.4.0-0.bpo.4-cloud-amd64-unsigned/buster-backports 5.4.19-1~bpo10+1 amd64
  Linux 5.4 for x86-64 cloud

linux-image-5.4.0-0.bpo.4-rt-amd64/buster-backports 5.4.19-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs, PREEMPT_RT (signed)

linux-image-5.4.0-0.bpo.4-rt-amd64-dbg/buster-backports 5.4.19-1~bpo10+1 amd64
  Debug symbols for linux-image-5.4.0-0.bpo.4-rt-amd64

linux-image-5.4.0-0.bpo.4-rt-amd64-unsigned/buster-backports 5.4.19-1~bpo10+1 amd64
  Linux 5.4 for 64-bit PCs, PREEMPT_RT

linux-image-amd64/stable,stable,now 4.19+105+deb10u3 amd64 [installed]
  Linux for 64-bit PCs (meta-package)

linux-image-amd64-dbg/stable,stable 4.19+105+deb10u3 amd64
  Debugging symbols for Linux amd64 configuration (meta-package)

linux-image-amd64-signed-template/stable,stable 4.19.98-1 amd64
  Template for signed linux-image packages for amd64

linux-image-cloud-amd64/stable,stable 4.19+105+deb10u3 amd64
  Linux for x86-64 cloud (meta-package)

linux-image-cloud-amd64-dbg/stable,stable 4.19+105+deb10u3 amd64
  Debugging symbols for Linux cloud-amd64 configuration (meta-package)

linux-image-rt-amd64/stable,stable 4.19+105+deb10u3 amd64
  Linux for 64-bit PCs (meta-package), PREEMPT_RT

linux-image-rt-amd64-dbg/stable,stable 4.19+105+deb10u3 amd64
  Debugging symbols for Linux rt-amd64 configuration (meta-package)

Choose image which you want to install,

sudo apt-get -t buster-backports install linux-image-5.4.0-0.bpo.4-amd64

uname -r

Make Viber larger font

I modified the Exec= line in /usr/share/applications/viber.desktop to this:

Exec=/usr/bin/env QT_AUTO_SCREEN_SCALE_FACTOR=1 QT_SCALE_FACTOR=1.5 /usr/bin/viber

Move Desktop Launcher to shared apps

1. Create Desktop launcher
sudo apt  install --no-install-recommends gnome-panel
gnome-desktop-item-edit ~/Desktop/ --create-new

2. Move to shared apps
sudo mv YourApp.desktop /usr/share/applications

Bug cannot detect UTF-8 when ssh deploy (Mac OS)

nano /etc/ssh/ssh_config

comment the line
SendEnv LANG LC_*

Install .deb package and dependencies

 Example:

wget http://ftp.jp.debian.org/debian/pool/contrib/m/msttcorefonts/ttf-mscorefonts-installer_3.6_all.deb
dpkg -i ttf-mscorefonts-installer_3.6_all.deb
apt -f install
apt install fontconfig

locale debian

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales

Setup OpenVPN

Server
1. Install openvpn
apt-get install openvpn

2. Install easy-rsa
apt-get install easy-rsa

3. Config easy-rsa

4. Config openvpn

Client
1. Install openvpn

2. Config openvpn

Portable Postgres

Postgres full extension 9.6.3 on Debian 8 64bit 
https://drive.google.com/open?id=0B30EeVPAcvhvWHpMNDZmbFdNYVk

Build Postgres from source

Install libs for compile source postgres

apt-get install build-essential libreadline-dev zlib1g-dev llvm-7 clang-7

if use Debian 11 or Ubuntu 22.04, change llvm and clang to current version

apt-get install build-essential libreadline-dev zlib1g-dev llvm clang libicu-dev pkg-config bison flex libssl-dev
 

Extract postgres source to postgres-source-dir (change lllvm-7 to current version llvm path)

mkdir -p /home/userpath/postgres/pgsql
cd postgres-source-dir

./configure --with-llvm LLVM_CONFIG="/usr/lib/llvm-7/bin/llvm-config" --prefix=/home/userpath/postgres/pgsql

make

make install

if you want to install postgres-contrib extension, you can compile it

cd contrib
make
make install

cd \

mkdir postgres

cd postgres

mkdir database

pgsql/bin/initdb --locale en_US.UTF-8 -D database

Now you can setup everything with new portable postgres include 2 folder: pgsql and database

Run portable postgres 9.5.3 on Debian 8 64bit

I built portable postgres 9.5.3 from source for Debian 8 64bit. You can download it and free to use wihout install any dependencies.

Get file from https://drive.google.com/open?id=0B30EeVPAcvhvZmNFbXFidFVYRTA

tar xvf postgresql_9.5.3_portable_debian8_64.tar.gz

cd postgres

sh start_postgres.sh

To stop postgres

sh stop_postgres.sh

To use other command of Postgres:

source config_postgres

then all commands of postgres should be work properly

Update link for Postgres 9.6.2: https://drive.google.com/open?id=0B30EeVPAcvhvRHotSDdxYTA2LTA