pvcreate /dev/sdf
pvdisplay
vgextend pg_probackup /dev/sdf
vgdisplay
lvextend -r -l +100%FREE /dev/pg_probackup/job_db
lvdisplay

ssh-copy-id postgres@db1-1c-prod

/opt/pgpro/ent-17/bin/pg_probackup add-instance -B /mnt/backup/db1-1c-prod -D /mnt/instance_1/ --instance=Buh_UPCB --remote-host=db1-1c-prod --remote-user=postgres

mkdir /mnt/backup/Buh_UPCB/backups
mkdir /mnt/backup/Buh_UPCB/wal

mkdir /var/log/pg_probackup/db1-1c-prod

/opt/pgpro/ent-17/bin/pg_probackup backup -B /mnt/backup/db1-1c-prod -b FULL --instance=Buh_UPCB --stream --remote-host=db1-1c-prod --remote-user=postgres -U postgres -d Buh_UPCB -p 5432 --compress-level=2 --compress-algorithm lz4 --log-filename=Buh_UPCB_backup.log --log-level-file=log --log-directory=/var/log/pg_probackup/db1-1c-prod

/opt/pgpro/ent-17/bin/pg_probackup backup -B /mnt/backup/db1-1c-prod -b DELTA --instance=Buh_UPCB --stream --remote-host=db1-1c-prod --remote-user=postgres -U postgres -d Buh_UPCB -p 5432 --compress-level=2 --compress-algorithm lz4 --log-filename=Buh_UPCB_backup.log --log-level-file=log --log-directory=/var/log/pg_probackup/db1-1c-prod

/opt/pgpro/ent-17/bin/pg_probackup show -B /mnt/backup/db1-1c-prod --instance=Buh_UPCB

w32tm /stripchart /computer:clock.isc.org /dataonly /samples:3

pool xx.xx.xx.xx iburst prefer
pool xx.xx.xx.xx iburst

chronyc tracking

nano /root/.smbclient

username=myname
password=dPassw0rd
domain=domain.local

chmod 600 /root/.smbclient
chown root:root /root/.smbclient

nano /etc/fstab

//192.168.1.10/share /mnt cifs user,rw,credentials=/root/.smbclient 0 0

journalctl --vacuum-size=1M

apt-get install gdisk
apt-get install cloud-utils-growpart
growpart /dev/sdb 1
resize2fs /dev/sdb1

export EDITOR=nano

npm config set proxy http://user:password@host:8080

npm config rm proxy
npm config rm https-proxy

systemctl restart pvedaemon pveproxy

systemctl | grep postgres

netstat -tulnp | grep 54

su - postgres

psql -p 5433 -c '\l';

psql -p 5433 -c '\l+';

su - postgres -c "psql -p 5432 -c '\l+';"

psql -p 5433 -c 'show data_directory';

select pg_reload_conf();

ALTER DATABASE "OLDBASE" RENAME TO "NEWBASE";

SELECT pg_terminate_backend (pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'НАЗВАНИЕ_БАЗЫ';

[global]
        security = ads
        realm = TEST-DOMAIN.RU
        workgroup = WORKGROUP
        netbios name = SAMBA-SRV1
        template shell = /bin/bash
        kerberos method = system keytab
        wins support = no
        winbind use default domain = yes
        winbind enum users = no
        winbind enum groups = no
        template homedir = /home/TEST-DOMAIN.RU/%U
        idmap config * : range = 200000-2000200000
        idmap config * : backend = sss
        machine password timeout = 0
        # скрываем нечитаемые файлы
        hide unreadable = yes
        # скрываем недоступные общие
        access based share enum = yes
        # отображение права доступа в Windows на права доступа Linux
        nt acl support = yes
        # включение режима наследования ACL от каталога, в котором создаются новые файлы и каталоги. Без этого параметра дополнитель>
        inherit acls = yes
        # включение режима наследования владельца каталога, в котором создаётся файл. Без этого параметра владельцем будет становить>
        inherit owner = yes
        # включение наследования unix mode разрешений
        inherit permissions = yes
        # Наследование прав от родительского каталога в NT acls на файловую систему.
        map acl inherit = yes

        directory mask = 0775
        create mask = 0775

[1C]
        path = /mnt/share/1C
        write list = acronis usr1cv8 @admin_srv @FILE_DomainUsers
        valid users = acronis, usr1cv8, @admin_srv, @FILE_DomainUsers
        public = no
        writable = yes
        browseable = no

[buh]
        path = /mnt/share/docs/buh
        write list = acronis @admin_srv @FILE_Бухгалтерия_RW
        valid users = acronis, @admin_srv, @FILE_Бухгалтерия_RW
        public = yes
        writable = yes
        browseable = yes

su postgres -c "psql -c \"alter role postgres with password 'postgres';\""

mysql -u root -p -h localhost

SHOW DATABASES;

CREATE DATABASE newdb;

CREATE USER 'bitrixuser'@'localhost' Identified by 'ПАРОЛЬ';

GRANT ALL on *.* to 'bitrixuser'@'localhost';

GRANT all ON newdb.* to bitrixuser@localhost;
FLUSH PRIVILEGES;
quit

nano /etc/sudoers
"пользователь" ALL = (ALL) NOPASSWD: /opt/Validata/VDCSP/bin/amd64vdcsp_cfg

apt install linux-image-generic

Add-ADGroupMember -Identity 'FILE_DomainUsers' -Members (Get-ADGroupMember -Identity 'Пользователи домена')