Ondrej Valenta OndrejValenta

Installation of PostgreSQL 15 on RockyLinux 9 with OS configuration for better performance

Based on various sources

https://www.tecmint.com/install-postgresql-rocky-linux/

Installation and initialization

Serilog configuration for easy console/file/debug logging in Console apps

Using Microsoft Logging extensions

Serilog.Debugging.SelfLog.Enable(msg => Debug.WriteLine(msg));
Serilog.Debugging.SelfLog.Enable(Console.Error);

loggerConfig = new LoggerConfiguration()
  .MinimumLevel.Verbose();

Install Docker on Hetzner's CentosOS

This script is based on Docker's installation steps and containerd installation fix based on this article Installation of Docker fails on CentOS 8 with Error — package containerd.io

Install prerequisities

yum install -y yum-utils
yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
yum install -y https://download.docker.com/linux/centos/7/x86_64/stable/Packages/containerd.io-1.2.6-3.3.el7.x86_64.rpm

Simple reordering of items in database table

The problem

Ability to reorder item based on users drag and drop of items in UI. Items can be drag and drop in as a single object or with This is not the most efficient way how to do this but it's working just fine.

-- Drop functions and data table if they already exists
drop function save_todo_float(_user_id int, _what text, _todo_id int);
drop function move_todo_float(_user_id int, _ids int[], _target_id int, _position text);
drop table todos_float;

Install Zsh and Oh-my-zsh on CentOS 8

Based on this article

chsh is not available on some Centos8 so there is a dnf install to add the package that contains it

ALL INSTALLATIONS ASSUME YES WHEN PROMPTED, that's what -y does

This script can be copy paste to ssh as is. No hands installation. :-)

Install Nginx and PHP on CentOS 7

Based on this article

Install Nginx

sudo yum install epel-release -y
sudo yum install nginx -y

sudo systemctl start nginx

Install Zsh and Oh-my-zsh on CentOS 7

Based on this article

ALL INSTALLATIONS ASSUME YES WHEN PROMPTED, that's what -y does

This script can be copy paste to ssh as is. No hands installation. :-)

yum install zsh -y

	# DEPENDS ON install-erlang-on-centos8.sh

	# Install Elixir
	cd /opt
	git clone https://github.com/elixir-lang/elixir.git
	cd elixir
	make clean test
	export PATH="$PATH:/opt/elixir/bin"

	# Install Epel repository
	yum install epel-release -y

	# Install necessary libraries for Erlang compilation
	yum install gcc gcc-c++ glibc-devel make ncurses-devel openssl-devel autoconf java-1.8.0-openjdk-devel git wget wxBase3 libGL libGLU unixODBC wxGTK3 wxGTK3-gl -y

	# Download Erlang package (update to proper package version)
	wget https://packages.erlang-solutions.com/erlang/rpm/centos/8/x86_64/esl-erlang_23.0.2-1~centos~8_amd64.rpm

	# Install Erlang

	# Update everything automatically
	yum update -y

	# Install nano and other useful stuff because you are not a masochist
	yum install epel-release -y;
	yum install nano -y;
	yum install mc -y;
	yum install htop -y;

	# Install and start firewalld