ืึธืคึผืืืืงืขื ืื ื
ืืื ืืื ืึท ืืขืืืขืืึธืคึผืขืจ. ืืื ืฉืจืืึทืื ืงืึธื ืืื ืื ืืขืจืึทืงื ืืื ืื ืืึทืืึทืืืืก ืืืืื ืืื ืึท ืืึทื ืืฆืขืจ. ืืื ืฉืืขื ืืื ื ืืฉื ืคืืจ ืื ืืื ืืื ื ืกืืกืืขื ืืืืื ืืกืืจืืืืจ, ืคืื ืืืืื ืืืขืจ ื ืืื. ืึธืืขืจโฆ
ืขืก ืึทืืื ืืขืืจืืคื ืึทื ืืื ืืืจืฃ ืฆื ืึธืจืืึทื ืืืืจื ืึท ืืึทืงืึทืคึผ ืคืื ืื ืคึผืึธืกืืืจืขืกืงื ืืึทืืึทืืืืก. ืงืืื ืืืืืงื ืก - ื ืึธืจ ื ืืฆื SSH ืืื ืืึทืื ืืืืขืจ ืึทื ืึทืืฅ ืึทืจืืขื ืึธื ืึทืกืงืื ื ืคึฟืึทืจ ืืขืื. ืืืึธืก ืืึธื ืืืจ ืืึธื ืืื ืึทืืึท ืงืึทืกืขืก? ืืึธืก ืืื ืจืขืื, ืืืจ ืฉืืืคึผื pgdump ืืื cron, ืืึทืงืึทืคึผ ืึทืืฅ ืฆื ืื ืึทืจืงืืืื ืืขืืขืจ ืืึธื, ืืื ืืืื ืืืจ ืืขื ืขื ืืึธืจ ืคืึทืจืคืึทืื, ืืืจ ืฉืืงื ืืขื ืึทืจืงืืืื ืขืจืืขืฅ ืืืืึทื ืึทืืืขืง.
ืืึธืก ืืึธื ืื ืฉืืืขืจืืงืืื ืืื ืืขืืืขื ืึทื ืืืื ืื ืคึผืืึทื ื, ืื ืืึทืืึทืืืืก ืืื ืืขืืืขื ืืขืืืื ื ืฆื ืืืึทืงืกื ืืื ืืืขืื +- 100 ืืขืืืืืืื ืคึผืขืจ ืืึธื. ืคืื ืงืืจืก, ื ืึธื ืึท ืคึผืึธืจ ืคืื ืืืึธืื ืื ืคืึทืจืืึทื ื ืฆื ืืึทืงืึทืคึผ ืึทืืฅ ืืื ืคึผืืืึทืืคึผ ืืืขื ืคืึทืจืฉืืืื ืื. ืืึธืก ืืื ืืื ืื ืงืจืึทืืขื ืืึทื ืืึทืงืึทืคึผืก ืงืืืขื ืฆื ืจืึทืืขืืืขื.
ืืฉืืงืึทืืืข? ืืจืืืื ืืืืื ืฆื ืงืึทืฅ.
ืื ืงืจืขืืขื ืืึทื ืืึทืงืึทืคึผ ืืื ืึท ืืืคึผ ืคืื ืืึทืงืึทืคึผ ืืืขื ื ืื ืึทืืข ืืงืืจ ืืขืงืขืก ืืขื ืขื ืงืึทืคึผืื, ืึธืืขืจ ืืืืื ื ืืึทืข ืืื ืื ืืขืืืื ืืื ื ืื ืฉืึทืคืื ื ืคืื ืื ืคืจืืขืจืืืงืข ืงืึธืคึผืืข.
ืืื ืืขืืขืจ ืืขืืืขืืึธืคึผืขืจ ืืืึธืก ืืื ืืขืืืขื ืึทืืกืึธืืื ื ืื ืืืืื (ืืื ืืขืจ ืฆืืื) ืฆื ืคึฟืึทืจืฉืืืื ืื ืื ืืจืึทืงืึทืกืื ืคืื ืคึผืึธืกืืืจืขืก, ืืื ืืขืืืืื ืฆื ืืขืคึฟืื ืขื ืื ืืจืื ืงื ืขืคึผื. ื ื, ืืืจ ืืืืกื, ืืื ืืื AWS, DigitalOcean: ืืืจ ืืขืืจืืงื ืืืื ืงื ืขืคึผื - ืืืจ ืืึธื ืจืขืคึผืืึทืงืืืฉืึทื, ืืืจ ืืขืืจืืงื ืื ืจืืข - ืืืจ ืฉืืขืื ืึทืจืืืฃ ืืึทืงืึทืคึผืก, ืื ืืจืื - ืืืจ ืจืึธืืื ืึทืืฅ ืฆืืจืืง ืึท ืคึผืึธืจ ืคืื ืฉืขื. ืืื ืืึธื ื ืื ืืขืคึฟืื ืขื ืึท ืงื ืขืคึผื ืึธืืขืจ ืึท ืฉืืื GUI ืืขืฆืืึทื. ืืืื ืืืจ ืืืืกื ืืืื ืขืจ (ืคืจืื ืึธืืขืจ ืืืืืง), ืฉืจืืึทืื ืืืขืื ืืื ืืื ืื ืืึทืืขืจืงืื ืืขื.
ื ืึธื ืืืืืื ื ืืื ืืขืคึฟืื ืขื ืฆืืืื ืืืฉืืจืื ืคึผืืืึทืจืืึทื ะธ pgbackrest. ืืื ืืื ืคืฉืื ื ืืฉื ืืฆืืื ืืขืืืขื ืืื ืื ืขืจืฉืืข (ืืืืขืจ ืฉืืืขืจืข ืืืงืืืขื ืืืฆืืข, ืืื ืืื ืืขืคืจืืืืื ืืืขืก ืืืืกืฆืืคืื ืขื ืืืื ืื ืืืืข ืืื ืืืืื), ืืืขืจ ืืื ืื ืฆืืืืืืข ืืื ืืื ืื ืืืงืืืขื ืืืฆืืข ืืจืืืกืืขืืืืื ืฆื ืืืื ืืืืื, ืืืขืจ ื ืืฉื ืื ืืกืจืื ืืช. ืฆื ืคืึทืจืคึผืึธืฉืขืืขืจื ืื ืึทืจืืขื ืคืื ืื ืืืืก ืืขื ืขื ืคืืืกื ืืื ืึท ืขื ืืขื ืึทืจืืขื, ืืขื ืึทืจืืืงื ืืื ืืขืฉืจืืื.
ื ืึธื ืืืืขื ืขื ืืขื ืึทืจืืืงื, ืืืจ ืืืขื ืืขืจื ืขื ืืื ืฆื ืืึทืื ืื ืงืจืึทืืขื ืืึทื ืืึทืงืึทืคึผืก, ืจืึทืืขืืืขื ืืื ืฆื ืึท ืืืืึทื ืกืขืจืืืขืจ (ืจืืคึผืึทืืึทืืึธืจื ืืื ืืึทืงืึทืคึผืก) ืืื ืืืงืขืจื ืืื ืืื ืคืึทื ืคืื ืืึทืื ืึธื ืืืขืจ ืึธืืขืจ ืื ืืขืจืข ืคึผืจืึธืืืขืืก ืืืืฃ ืื ืืืืคึผื ืกืขืจืืืขืจ.
ืืจืึทืื ืื ื
ืฆื ืจืขืคึผืจืึธืืืฆืืจื ืื ืืึทื ืืึทื ืืืจ ืืึทืจืคึฟื ืฆืืืื ืืืคึผืก. ืืขืจ ืขืจืฉืืขืจ ืืืขื ืืืื ืื ืกืืึธืจืืืืฉ (ืื ืจืืคึผืึทืืึทืืึธืจื ืืืืฃ ืืืึธืก ืื ืืึทืงืึทืคึผืก ืืืขื ืืืื ืกืืึธืจื), ืืื ืื ืจืืข, ืืื ืคืึทืงื, ืื ืกืขืจืืืขืจ ืืื ืืื ืคึผืึธืกืืืจืขืก (ืืื ืืืื ืคืึทื, ืืืขืจืกืืข 11 ืคืื ืคึผืึธืกืืืจืขืก).
ืขืก ืืื ืื ืืขื ืืืขื ืึทื ืืืืฃ ืื ืกืขืจืืืขืจ ืืื postgres ืืืจ ืืึธืื ืืืึธืจืฆื, sudo user, postgres ืืึทื ืืฆืขืจ ืืื postgres ืืื ืืื ืืื ืกืืึทืืืจื (ืื ืคึผืึธืกืืืจืขืก ืืึทื ืืฆืขืจ ืืื ืืืฉืืคื ืืืืืึธืืึทืืืฉ ืืืขื ืืืจ ืื ืกืืึทืืืจื postgresql), ืืื ืืืืฃ ืื ืจืืคึผืึทืืึทืืึธืจื ืกืขืจืืืขืจ ืขืก ืืขื ืขื ืืืึธืจืฆื ืืื sudo ืืึทื ืืฆืขืจ (ืืื ืื ืืึทื ืืึทื. ืืขืจ ืืึทื ืืฆืขืจ ื ืึธืืขื pgbackrest ืืืขื ืืืื ืืขืืืืื ื).
ืึทืืื ืึทื ืืืจ ืืึธื ืืืืื ืืงืขืจืข ืคืจืืืืขืืขื ืืืขื ืืืจ ืจืขืคึผืจืึธืืืฆืืจื ืื ืื ืกืืจืึทืงืฉืึทื ื, ืืื ืฉืจืืึทืื ืืื ืืืืึทืืืง ืืื, ืืื ืืืึธืก ืืึทื ืืฆืขืจ ืืื ืืื ืืืึธืก ืจืขืื ืืื ืืืกืคืืจื ืืขื ืืึทืคึฟืขื ืืฉืขืช ืฉืจืืืื ืืื ืงืึธื ืืจืึธืืืจื ืืขื ืึทืจืืืงื.
ืื ืกืืึธืืื ื pgbackrest
ืจืืคึผืึทืืึทืืึธืจื (ืืึทื ืืฆืขืจ pgbackrest):
1. ืืจืืคืงืืคืืข ืื ืึทืจืงืืืื ืคึฟืื pgbackrest ืืื ืึทืจืืืขืจืคืืจื ืื ืืื ืืึทืื ืฆื ืื /build ืืขืงืข:
sudo mkdir /build
sudo wget -q -O -
https://github.com/pgbackrest/pgbackrest/archive/release/2.18.tar.gz |
sudo tar zx -C /build2. ืื ืกืืึทืืืจื ืื ืืืคึผืขื ืืึทื ืกืื ื ืืืืืง ืคึฟืึทืจ ืคึฟืึทืจืืึทืืืื ื:
sudo apt-get update
sudo apt-get install build-essential libssl-dev libxml2-dev libperl-dev zlib1g-dev
libpq-dev3. ืึทืกืขืืืึทื ืคึผืืืึทืงืงืจืขืกื:
cd /build/pgbackrest-release-2.18/src && sudo ./configure
sudo make -s -C /build/pgbackrest-release-2.18/src4. ื ืึธืืืึทืื ืื ืขืงืกืขืงืืืึทืืืข ืืขืงืข ืฆื ืื /usr/bin ืืืขืืืืืึทืืขืจ:
sudo cp /build/pgbackrest-release-2.18/src/pgbackrest /usr/bin
sudo chmod 755 /usr/bin/pgbackrest5. ืคึผืืืึทืงืงืจืขืกื ืจืืงืืืืืขืจื ืคึผืขืจื. ืื ืกืืึทืืืจื:
sudo apt-get install perl6. ืฉืึทืคึฟื ืืืจืขืงืืขืจืื ืคึฟืึทืจ ืืึธืืก, ืืขืื ืืื ืืืืขืจ ืจืขืื:
sudo mkdir -p -m 770 /var/log/pgbackrest
sudo chown pgbackrest:pgbackrest /var/log/pgbackrest
sudo mkdir -p /etc/pgbackrest
sudo mkdir -p /etc/pgbackrest/conf.d
sudo touch /etc/pgbackrest/pgbackrest.conf
sudo chmod 640 /etc/pgbackrest/pgbackrest.conf
sudo chown pgbackrest:pgbackrest /etc/pgbackrest/pgbackrest.conf7. ืืฉืขืง:
pgbackrest versionPostgres ืกืขืจืืืขืจ (ืกืืืึธ ืืึทื ืืฆืขืจ ืึธืืขืจ ืืืึธืจืฆื):
ืืขืจ ืคึผืจืึธืฆืขืก ืคืื ืื ืกืืึธืืื ื ืคึผืืืึทืงืงืจืขืกื ืืืืฃ ืึท ืกืขืจืืืขืจ ืืื ืคึผืึธืกืืืจืขืก ืืื ืขื ืืขื ืฆื ืื ืื ืกืืึทืืืจืื ื ืคึผืจืึธืฆืขืก ืืืืฃ ืื ืจืืคึผืึทืืึทืืึธืจื (ืืึธ, ืคึผืืืึทืงืงืจืขืกื ืืืื ืืืื ืืื ืกืืึทืืืจื ืืืืฃ ืืืืืข ืกืขืจืืืขืจืก), ืึธืืขืจ ืืื ืื 6 ืคึผืึทืจืึทืืจืึทืฃ ืื ืจืืข ืืื ืืขืฆืืข ืงืึทืืึทื ืื:
sudo chown pgbackrest:pgbackrest /var/log/pgbackrest
sudo chown pgbackrest:pgbackrest /etc/pgbackrest/pgbackrest.confืคืึทืจืืืึทืื ืืื:
sudo chown postgres:postgres /var/log/pgbackrest
sudo chown postgres:postgres /etc/pgbackrest/pgbackrest.confืืึทืฉืืขืืืงื ืื ืืขืจืึทืงืฉืึทื ืฆืืืืฉื ืกืขืจืืืขืจืก ืืืจื ืคึผืึทืจืึธืืืขืกืก SSH
ืืื ืกืืจ ืคึฟืึทืจ ืคึผืืืึทืงืงืจืขืกื ืฆื ืึทืจืืขืื ืจืืืืืง, ืขืก ืืื ื ืืืืืง ืฆื ืงืึทื ืคืืืืขืจ ืื ืื ืืขืจืึทืงืฉืึทื ืฆืืืืฉื ืื ืคึผืึธืกืืืจืขืก ืกืขืจืืืขืจ ืืื ืื ืจืืคึผืึทืืึทืืึธืจื ื ืืฆื ืื ืฉืืืกื ืืขืงืข.
ืจืืคึผืึทืืึทืืึธืจื (ืืึทื ืืฆืขืจ pgbackrest):
ืฉืึทืคึฟื ืึท ืฉืืืกื ืคึผืึธืจ:
mkdir -m 750 /home/pgbackrest/.ssh
ssh-keygen -f /home/pgbackrest/.ssh/id_rsa
-t rsa -b 4096 -N ""ืืืืจืขื ืื ื! ืืืจ ืืืืคื ืื ืืืืื ืงืึทืืึทื ืื ืึธื ืกืืืึธ.
Postgres ืกืขืจืืืขืจ (ืกืืืึธ ืืึทื ืืฆืขืจ ืึธืืขืจ ืืืึธืจืฆื):
ืฉืึทืคึฟื ืึท ืฉืืืกื ืคึผืึธืจ:
sudo -u postgres mkdir -m 750 -p /var/lib/postgresql/.ssh
sudo -u postgres ssh-keygen -f /var/lib/postgresql/.ssh/id_rsa
-t rsa -b 4096 -N ""ืจืืคึผืึทืืึทืืึธืจื (ืกืืืึธ ืืึทื ืืฆืขืจ):
ื ืึธืืืึทืื ืื ืขืคื ืืืขื ืฉืืืกื ืคืื ืื ืคึผืึธืกืืืจืขืก ืกืขืจืืืขืจ ืฆื ืื ืจืืคึผืึทืืึทืืึธืจื ืกืขืจืืืขืจ:
(echo -n 'no-agent-forwarding,no-X11-forwarding,no-port-forwarding,' &&
echo -n 'command="/usr/bin/pgbackrest ${SSH_ORIGINAL_COMMAND#* }" ' &&
sudo ssh root@<postgres_server_ip> cat /var/lib/postgresql/.ssh/id_rsa.pub) |
sudo -u pgbackrest tee -a /home/pgbackrest/.ssh/authorized_keysืืื ืืขื ืฉืจืื ืืืจ ืืืขื ืืืื ืืขืืขืื ืคึฟืึทืจ ืื ืคึผืึทืจืึธื ืคึฟืึทืจ ืื ืืืึธืจืฆื ืืึทื ืืฆืขืจ. ืืืจ ืืึทืจืคึฟื ืฆื ืึทืจืืึทื ืื ืคึผืึทืจืึธื ืคืื ืื ืืืึธืจืฆื ืืึทื ืืฆืขืจ ืคืื ืื ืคึผืึธืกืืืจืขืก ืกืขืจืืืขืจ!
Postgres ืกืขืจืืืขืจ (ืกืืืึธ ืืึทื ืืฆืขืจ):
ื ืึธืืืึทืื ืื ืจืืคึผืึทืืึทืืึธืจื ืขืคื ืืืขื ืฉืืืกื ืฆื ืื ืกืขืจืืืขืจ ืืื ืคึผืึธืกืืืจืขืก:
(echo -n 'no-agent-forwarding,no-X11-forwarding,no-port-forwarding,' &&
echo -n 'command="/usr/bin/pgbackrest ${SSH_ORIGINAL_COMMAND#* }" ' &&
sudo ssh root@<repository_server_ip> cat /home/pgbackrest/.ssh/id_rsa.pub) |
sudo -u postgres tee -a /var/lib/postgresql/.ssh/authorized_keys
ืืื ืืขื ืฉืจืื ืืืจ ืืืขื ืืืื ืืขืืขืื ืคึฟืึทืจ ืื ืคึผืึทืจืึธื ืคึฟืึทืจ ืื ืืืึธืจืฆื ืืึทื ืืฆืขืจ. ืืืจ ืืึทืจืคึฟื ืฆื ืึทืจืืึทื ืคึผืื ืงื ืื ืคึผืึทืจืึธื ืคืื ืืขืจ ืืืึธืจืฆื ืืึทื ืืฆืขืจ ืคืื ืื ืจืืคึผืึทืืึทืืึธืจื!
ืืืจ ืงืึธื ืืจืึธืืืจื:
ืจืืคึผืึทืืึทืืึธืจื (ืืืึธืจืฆื ืืึทื ืืฆืขืจ, ืคึฟืึทืจ ืื ืจืืื ืงืืึทื ืคืื ืืขืจ ืขืงืกืคึผืขืจืืืขื ื):
sudo -u pgbackrest ssh postgres@<postgres_server_ip>Postgres ืกืขืจืืืขืจ (ืืืึธืจืฆื ืืึทื ืืฆืขืจ, ืคึฟืึทืจ ืื ืจืืื ืงืืึทื ืคืื ืืขืจ ืขืงืกืคึผืขืจืืืขื ื):
sudo -u postgres ssh pgbackrest@<repository_server_ip>ืืืจ ืืึทืื ืืืืขืจ ืึทื ืืืจ ืืึทืงืืืขื ืึทืงืกืขืก ืึธื ืคืจืืืืขืืขื.
ืืึทืฉืืขืืืงื ืึท ืคึผืึธืกืืืจืขืก ืกืขืจืืืขืจ
Postgres ืกืขืจืืืขืจ (ืกืืืึธ ืืึทื ืืฆืขืจ ืึธืืขืจ ืืืึธืจืฆื):
1. ืืึธืื ืก ืืึธืื ื ืึทืงืื ื ืืืืฃ ืื ืคึผืึธืกืืืจืขืก ืกืขืจืืืขืจ ืคึฟืื ืคืื ืืจืืืกื ืืืง ืืคึผืก. ืฆื ืืึธื ืืึธืก, ืจืขืืึทืืืจื ืื ืืขืงืข postgresql.conf (ืืืื ืืื ืื /etc/postgresql/11/ืืืืคึผื ืืขืงืข), ืึทืืื ื ืื ืฉืืจื ืฆื ืขืก:
listen_addresses = '*'ืืืื ืึทืืึท ืึท ืฉืืจื ืฉืืื ืืืืืกืฅ, ืึธืืขืจ ืื ืงืึธืืืขื ื ืขืก ืึธืืขืจ ืฉืืขืื ืื ืคึผืึทืจืึทืืขืืขืจ ืืืขืจื ืืื '*'.
ืืื ืืขืงืข pg_hba.conf (ืืืื ืืืื ืืื ืืขืจ ืืขืงืข /etc/postgresql/11/main) ืืืื ืื ืคืืืืขื ืืข ืฉืืจืืช:
hostssl all all 0.0.0.0/0 md5
host all all 0.0.0.0/0 md5ืืื:
hostssl/host - ะฟะพะดะบะปััะฐะตะผัั ัะตัะตะท SSL (ะธะปะธ ะฝะตั)
all - ัะฐะทัะตัะฐะตะผ ะฟะพะดะบะปััะตะฝะธะต ะบะพ ะฒัะตะผ ะฑะฐะทะฐะผ
all - ะธะผั ะฟะพะปัะทะพะฒะฐัะตะปั, ะบะพัะพัะพะผั ัะฐะทัะตัะฐะตะผ ะฟะพะดะบะปััะตะฝะธะต (ะฒัะตะผ)
0.0.0.0/0 - ะผะฐัะบะฐ ัะตัะธ ั ะบะพัะพัะพะน ะผะพะถะฝะพ ะฟะพะดะบะปััะฐัััั
md5 - ัะฟะพัะพะฑ ัะธััะพะฒะฐะฝะธั ะฟะฐัะพะปั2. ืืื ืก ืืึทืื ืื ื ืืืืืง ืกืขืืืื ืืก ืืื postgresql.conf (ืขืก ืืื ืืื ืืขืจ ืืขืงืข /etc/postgresql/11/main) ืคึฟืึทืจ pgbackrest ืฆื ืึทืจืืขืื:
archive_command = 'pgbackrest --stanza=main archive-push %p' # ะะดะต main - ะฝะฐะทะฒะฐะฝะธะต ะบะปะฐััะตัะฐ. ะัะธ ัััะฐะฝะพะฒะบะต postgres ะฐะฒัะพะผะฐัะธัะตัะบะธ ัะพะทะดะฐะตั ะบะปะฐััะตั main.
archive_mode = on
max_wal_senders = 3
wal_level = replica3. ืืึธืืืจ ืืึทืื ืื ื ืืืืืง ืกืขืืืื ืืก ืืื ืื pgbackrest ืงืึทื ืคืืืืขืจืืืฉืึทื ืืขืงืข (/etc/pgbackrest/pgbackrest.conf):
[main]
pg1-path=/var/lib/postgresql/11/main
[global]
log-level-file=detail
repo1-host=<repository_server_ip>4. ืจืขืืึธืึทื ืคึผืึธืกืืืจืขืกืงื:
sudo service postgresql restartืืึทืฉืืขืืืงื ืึท ืจืืคึผืึทืืึทืืึธืจื ืกืขืจืืืขืจ
ืจืืคึผืึทืืึทืืึธืจื (ืคึผืืืึทืงืงืจืขืกื ืืึทื ืืฆืขืจ):
ืืื ืก ืืึทืื ืื ื ืืืืืง ืกืขืืืื ืืก ืืื ืื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืขืงืข pgbackrest
(/etc/pgbackrest/pgbackrest.conf):
[main]
pg1-host=<postgres_server_ip>
pg1-path=/var/lib/postgresql/11/main
[global]
repo1-path=/var/lib/pgbackrest
repo1-retention-full=2 # ะะฐัะฐะผะตัั, ัะบะฐะทัะฒะฐััะธะน ัะบะพะปัะบะพ ั
ัะฐะฝะธัั ะฟะพะปะฝัั
ะฑัะบะฐะฟะพะฒ. ะข.ะต. ะตัะปะธ ั ะฒะฐั ะตััั ะดะฒะฐ ะฟะพะปะฝัั
ะฑัะบะฐะฟะฐ ะธ ะฒั ัะพะทะดะฐะตัะต ััะตัะธะน - ะฟะตัะฒัะต ะดะฒะฐ ะฑัะดัั ัะดะฐะปะตะฝั ะฒะผะตััะต ั ะธะฝะบัะตะผะตะฝัะฐะผะธ.
start-fast=y # ะะฐัะธะฝะฐะตั ัะตะทะตัะฒะฝะพะต ะบะพะฟะธัะพะฒะฐะฝะธะต ะฝะตะผะตะดะปะตะฝะฝะพ, ะฟัะพัะธัะฐัั ะฟัะพ ััะพั ะฟะฐัะฐะผะตัั ะผะพะถะฝะพ ััั https://postgrespro.ru/docs/postgrespro/9.5/continuous-archivingืฉืึทืคึฟื ืึท ืจืืคึผืึทืืึทืืึธืจื
ืจืืคึผืึทืืึทืืึธืจื (ืคึผืืืึทืงืงืจืขืกื ืืึทื ืืฆืขืจ):
ืฉืึทืคึฟื ืึท ื ืืึทืข ืกืืึธืจืืืืฉ ืคึฟืึทืจ ืืขื ืงื ืืื ืืืืคึผื:
sudo mkdir -m 770 /var/lib/pgbackrest
sudo chown -R pgbackrest /var/lib/pgbackrest/
sudo -u pgbackrest pgbackrest --stanza=main stanza-create
ะัะพะฒะตัะบะฐ
Postgres ืกืขืจืืืขืจ (ืกืืืึธ ืืึทื ืืฆืขืจ ืึธืืขืจ ืืืึธืจืฆื):
ืืืจ ืงืึธื ืืจืึธืืืจื ืืืืฃ ืื Postgres ืกืขืจืืืขืจ:
sudo -u postgres pgbackrest --stanza=main --log-level-console=info checkืจืืคึผืึทืืึทืืึธืจื (ืคึผืืืึทืงืงืจืขืกื ืืึทื ืืฆืขืจ):
ืืืจ ืงืึธื ืืจืึธืืืจื ืืืืฃ ืื ืจืืคึผืึทืืึทืืึธืจื ืกืขืจืืืขืจ:
sudo -u pgbackrest pgbackrest --stanza=main --log-level-console=info checkืืืจ ืืึทืื ืืืืขืจ ืึทื ืืื ืืขืจ ืจืขืืืืืึทื ืืืจ ืืขื ืื ืฉืืจื "ืืฉืขืง ืืึทืคึฟืขื ืกืืฃ: ืืขืขื ืืืงื ืืฆืืื".
ืืื? ืืึธืืืจ ืืืื ืฆื ืื ืืขืจืกื ืืฉืืงืึทืืืข ืืืื.
ืืึทืื ืึท ืืึทืงืึทืคึผ
ืจืืคึผืึทืืึทืืึธืจื (ืคึผืืืึทืงืงืจืขืกื ืืึทื ืืฆืขืจ):
1. ืืืจืืคืืจื ืึท ืืึทืงืึทืคึผ:
sudo -u pgbackrest pgbackrest --stanza=main backup
2. ืืึทืื ืืืืขืจ ืึทื ืึท ืืึทืงืึทืคึผ ืืื ืืืฉืืคื:
ls /var/lib/pgbackrest/backup/main/Pgbackrest ืืืขื ืืึทืื ืื ืขืจืฉืืขืจ ืคืื ืืึทืงืึทืคึผ. ืืืื ืืืจ ืืืืื, ืืืจ ืงืขื ืขื ืืืืคื ืื ืืึทืงืึทืคึผ ืืึทืคึฟืขื ืืืืืขืจ ืืื ืืึทืื ืืืืขืจ ืึทื ืื ืกืืกืืขื ืงืจืืืืฅ ืึท ืื ืงืจืึทืืขื ืืึทื ืืึทืงืึทืคึผ.
ืืืื ืืืจ ืืืืื ืฆื ืืึทืื ืึท ืคืื ืืึทืงืึทืคึผ ืืืืืขืจ, ืกืคึผืขืฆืืคืืฆืืจื ืึทื ื ืึธื ืคืึธื:
sudo -u pgbackrest pgbackrest --stanza=main --type=full backupืืืื ืืืจ ืืืืื ืืืืืืื ืงืึทื ืกืึธืื ืจืขืืืืืึทื, ืืืื ืกืคึผืขืฆืืคืืฆืืจื:
sudo -u pgbackrest pgbackrest --stanza=main --type=full --log-level-console=info backupืจืืกืืึธืจืื ื ืึท ืืึทืงืึทืคึผ
Postgres ืกืขืจืืืขืจ (ืกืืืึธ ืืึทื ืืฆืขืจ ืึธืืขืจ ืืืึธืจืฆื):
1. ืืึทืืื ืื ืคืืืกื ืืืง ืงื ืืื:
sudo pg_ctlcluster 11 main stop2. ืจืืกืืึธืจืื ื ืคืื ืืึทืงืึทืคึผ:
sudo -u postgres pgbackrest --stanza=main --delta restore3. ืึธื ืืืื ืืขื ืงื ืืื:
sudo pg_ctlcluster 11 main startื ืึธื ืจืืกืืึธืจืื ื ืื ืืึทืงืึทืคึผ, ืืืจ ืืึทืจืคึฟื ืฆื ืืืจืืคืืจื ืึท ืฆืืืืื ืืึทืงืึทืคึผ:
ืจืืคึผืึทืืึทืืึธืจื (ืคึผืืืึทืงืงืจืขืกื ืืึทื ืืฆืขืจ):
sudo pgbackrest --stanza=main backupืึทื ืก ืึทืืข. ืฆืื ืกืืฃ ืืืื ืืื ืืืื ืืขืจืืื ืขื, ืื ืืื ืคืจืื ืืฉืื ืืืคื ื ืืฉื ืืื ืคืืจืฉืืขืื ืคืืจ ื ืขืืืขืจืข ืืื ืืื ืืืขื ื ืืฆื ืื ืืืืืงื ืก ืืื ืื ืืื ืืกืืข ืืขืืขืื ืืืื. ืืขืจืืืืึทื, ืืื ืืื ืึธื ืืืืื ืฆื ืืขืจื ืขื ืคืึทืจืฉืืื ืืขืืขืก ืึทืืึท ืืื ืืึทืงืึทืคึผ, ืจืขืคึผืืึทืงืืืฉืึทื, ืืึธื ืืืึธืจืื ื, ืขืืง. ืืื ืืื ืฉืจืืื ืงืืืื ืข ืืืจืืืื ืืืขืื ืื ืจืขืืืืืืื ืืื ืฆื ืืืื ื ืงืืืื ืข ืืืืฉืืืืขืจืื ื ืคืืจ ืื ืงืืืื ืืื ืืืืขืจืืืื ืงืืืื ืข ืฉืืืื ืืืขืจืืขื ืคืืจ ืืื ืืืืื.
ืืื ืื ืคืืืืขื ืืข ืึทืจืืืงืืขื, ืืื ืืืขื ืคึผืจืืืืจื ืฆื ืจืขืื ืืืขืื ื ืึธื ืคึฟืขืึดืงืืืื - ืืึทืื ืึธืคึผืืื ืฆื ืึท ืจืืื ืงื ืืื, ืขื ืงืจืืคึผืฉืึทื ืคืื ืืึทืงืึทืคึผืก ืืื ืืจืืืกืืขืื ืฆื S3, ืืึทืงืึทืคึผืก ืืืจื rsync.
ืืงืืจ: www.habr.com