#PostgreSQL packages patched for 1C Enterprise on Arch-based distributions
#(these are rpm packages from oficial site 1C Enterprise, converted via utility 'rpmtoarch' for installing on Arch-based distributions with pacman or yay command)
#0 - clone repo
git clone https://github.com/bor-1s/postgresql-1C-arch.git#1 - additional libs needed to start current version postgresql
yay -S libicu50 libldap24 enchant1.6
># package "compat-openssl10-1.0.2o-3.el8.x86_64" is not available in official arch repositories or AUR, so copy files
sudo cp postgresql-1C-arch/libs/openssl10/etc/pki/openssl10.cnf /etc/pki/openssl10.cnf
sudo cp postgresql-1C-arch/libs/openssl10/usr/share/ /usr/share/
sudo cp postgresql-1C-arch/libs/openssl10/usr/lib64/ /usr/lib/
#2 - install postgresql server
yay -U postgresql-1C-arch/postgresql-1C/15.2-1_x86_64_server/*.pkg.tar.zst#3 - install postgresql addons
yay -U postgresql-1C-arch/postgresql-1C/15.2-1_x86_64_addon/*.pkg.tar.zst#4 - create database folder (PGDATA) in separate drive for example '/home/admin/Data' is mount point for drive
mkdir -p /home/admin/Data/DATABASE/PostgreDB/#allow postgres user modify files on new drive (if mountpoint of new drive is in home directory - we must allow all our home directory)
sudo setfacl -m u:postgres:rwx /home/admin#make owned PGDATA folder for postgres user (this folder we also indicate in ExecStart command in our postgre service unit)
sudo chown postgres:postgres /home/admin/Data/DATABASE/PostgreDB/
sudo chmod 750 /home/admin/Data/DATABASE/PostgreDB/#5 - enable postgresql service
sudo cp postgresql-15-1C /etc/dinit.d/postgresql-15-1C
sudo dinitctl enable postgresql-15-1C#for systemd unit will be:
#sudo systemctl enable postgresql-15.service