Ubuntu desktop 16.04 установка PostgreSQL 1C 10.6 от PostgresPro

Установка PostgreSQL 10 для 1С:Предприятие на Debian / Ubuntu 

Продукт: PostgreSQL 1C 10.6

Платформа: x86_64

Пакет: postgrespro-1c-10-server_10.6-1.xenial_amd64.deb

Установка

$ sudo apt-get update -y
$ sudo apt-get install -y wget gnupg2 || sudo apt-get install -y gnupg
$ wget -O - http://repo.postgrespro.ru/keys/GPG-KEY-POSTGRESPRO | sudo apt-key add -
$ sudo su -c "echo deb http://repo.postgrespro.ru/1c-archive/pg1c-10.6/ubuntu xenial main > /etc/apt/sources.list.d/postgrespro-1c.list"
$ sudo apt-get update -y
$ sudo apt-get install -y postgrespro-1c-10-server postgrespro-1c-10-contrib
$ sudo /opt/pgpro/1c-10/bin/pg-wrapper links update

$ sudo /opt/pgpro/1c-10/bin/pg-setup initdb --data-checksums

$ sudo /opt/pgpro/1c-10/bin/pg-setup service enable
$ sudo service postgrespro-1c-10 start

$ ss -tunpl | grep 5432
tcp    LISTEN     0      128    127.0.0.1:5432                  *:*

$ sudo -u postgres psql -U postgres -c "alter user postgres with password 'pass';"
ALTER ROLE




Установка 1с

В папку /test положить файлы:
deb64_8_3_13_1690.tar.gz

# установка 1с
$ mkdir -p /tmp/1ctmp
$ cd /tmp/1ctmp
$ sudo apt install imagemagick -y
#$sudo apt install -y unixodbc libgsf-1-114 libglib2.0
$ sudo apt install libfreetype6 libgsf-1-common unixodbc glib2.0
#ubuntu
$ sudo  apt install -y xfonts-utils cabextract
$ sudo apt install ttf-mscorefonts-installer -y
$  ls /home/user/test/
$ cp /home/user/test/deb64_8_3_13_1690.tar.gz /tmp/1ctmp
$ cp /home/user/test/client_8_3_13_1690.deb64.tar.gz /tmp/1ctmp
$ tar xvzf deb64_8_3_13_1690.tar.gz
$ tar xvzf client_8_3_13_1690.deb64.tar.gz
$ sudo dpkg -i 1c-enterprise83-common_8.3.13-1690_amd64.deb
$ sudo dpkg -i 1c-enterprise83-server_8.3.13-1690_amd64.deb
$ sudo dpkg -i 1c-enterprise83-client_8.3.13-1690_amd64.deb
$ sudo apt -f -y install
$ sudo chown -R usr1cv8:grp1cv8 /opt/1C
$ sudo echo -e "pass\npass\n" | sudo passwd usr1cv8
$ sudo service srv1cv83 start
$ sudo service srv1cv83 status
#$ sudo usermod -aG sudo usr1cv8

$ sudo  apt install -y libc6-i386
$ mkdir /tmp/hasp
$ cd /tmp/hasp
$ wget http://download.etersoft.ru/pub/Etersoft/HASP/last/x86_64/Ubuntu/16.04/haspd-modules_7.60-eter1ubuntu_amd64.deb
$ wget http://download.etersoft.ru/pub/Etersoft/HASP/last/x86_64/Ubuntu/16.04/haspd_7.60-eter1ubuntu_amd64.deb
$ sudo dpkg -i *.deb
#$ sudo apt-get install -f -y
$ sudo service haspd start
$ sudo service haspd status
$ sudo reboot

$ sudo service srv1cv83 status
$ ss -tlnp | grep :15
LISTEN     0      128          *:1560                     *:*
LISTEN     0      128          *:1540                     *:*
LISTEN     0      128          *:1541                     *:*
LISTEN     0      128         :::1560                    :::*
LISTEN     0      128         :::1540                    :::*
LISTEN     0      128         :::1541                    :::*


#Не встал скриптом imagemagick?
#Без строчки ниже будет ругаться при входе в 1с
#$ sudo apt-get install imagemagick  -y



sudo cp /var/lib/pgpro/1c-10/data/postgresql.conf /var/lib/pgpro/1c-10/data/postgresql.conf.bak

sudo nano /var/lib/pgpro/1c-10/data/postgresql.conf
Добавить в конец: 


# Total Memory (RAM): 16 GB
# Data Storage: ssd

max_connections = 1000
shared_buffers = 4GB
temp_buffers = 256MB
work_mem = 64MB
effective_cache_size = 12GB
maintenance_work_mem = 1GB
wal_buffers = 16MB
min_wal_size = 2GB
max_wal_size = 4GB

default_statistics_target = 100
effective_io_concurrency = 2
random_page_cost = 1.1
autovacuum = on
autovacuum_max_workers = 4
autovacuum_naptime = 20s
bgwriter_delay = 20ms
bgwriter_lru_multiplier = 4.0
bgwriter_lru_maxpages = 400
synchronous_commit = off
checkpoint_completion_target = 0.9
#min_wal_size = 2GB
#max_wal_size = 4GB
ssl = off
fsync = on
commit_delay = 1000
commit_siblings = 5
row_security = off
max_files_per_process = 1000
standard_conforming_strings = off
escape_string_warning = off
max_locks_per_transaction = 256
#log_min_duration_statement = 0
log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d,client=%h '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
#log_autovacuum_min_duration = 0
lc_messages='C'
#log_duration = on
#log_statement = all
log_destination = stderr
plantuner.fix_empty_table = 'on'
online_analyze.table_type = 'temporary'
online_analyze.verbose = 'off'

Сохранить.

$ sudo nano /etc/hosts

127.0.0.1       localhost  ud1604
#127.0.1.1      ud1604


$ sudo poweroff

Сделать образ



2. с настройкой postgresql.conf и без тж
Заполнить: 158 с
Провести: 130 с