{"id":55884,"date":"2020-01-31T00:00:00","date_gmt":"2020-01-30T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/znakomstvo-s-wal-g-sistemoj-bekapirovaniya-postgresql"},"modified":"2020-02-18T14:04:03","modified_gmt":"2020-02-18T11:04:03","slug":"znakomstvo-s-wal-g-sistemoj-bekapirovaniya-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/znakomstvo-s-wal-g-sistemoj-bekapirovaniya-postgresql","title":{"rendered":"Introduksjon til wal-g systemet for sikkerhetskopiering av PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

WAL-G<\/a><\/noindex> \u2014 et enkelt og effektivt verkt\u00f8y for sikkerhetskopiering av PostgreSQL til skyer. I sin grunnleggende funksjonalitet er det en arv av det popul\u00e6re verkt\u00f8yet WAL-E<\/a><\/noindex>, men omskrevet i Go. Men WAL-G har \u00e9n viktig ny funksjon \u2014 delta-kopier. Delta-kopier WAL-G<\/a><\/noindex> lagrer filside som har endret seg siden den forrige versjonen av sikkerhetskopien. WAL-G implementerer en rekke teknologier for parallellisering av sikkerhetskopier. WAL-G fungerer betydelig raskere enn WAL-E.<\/p>\n

<\/a><\/noindex><\/p>\n

Detaljer om hvordan wal-g fungerer kan leses i artikkelen: Optimalisering av sikkerhetskopiering. Yandex-forelesning<\/a><\/noindex> <\/p>\n

<\/p>\n

S3-lagringsprotokollen har blitt popul\u00e6r for datalagring. En av fordelene med S3 er muligheten for tilgang via API, noe som gj\u00f8r det mulig \u00e5 organisere fleksibel interaksjon med lagringen, inkludert offentlig leseadgang, mens oppdatering av informasjonen i lagringen kun gj\u00f8res av autoriserte personell.<\/p>\n

<\/p>\n

Det finnes flere b\u00e5de \u00e5pne og private versjoner av lagringsl\u00f8sninger som fungerer med S3-protokollen. I dag skal vi se p\u00e5 en popul\u00e6r l\u00f8sning for \u00e5 organisere sm\u00e5 lagringsenheter \u2014 Minio.<\/p>\n

<\/p>\n

For testing av wal-g kan en PostgreSQL-server brukes, og Minio brukes som en erstatning for S3.<\/p>\n

<\/p>\n

Minio-server<\/h2>\n

<\/p>\n

Installasjon av Minio<\/p>\n

<\/p>\n

yum -y install yum-plugin-copr\nyum copr enable -y lkiesow\/minio\nyum install -y minio<\/code><\/pre>\n
<\/p>\n
Vi redigerer AccessKey og SecretKey i \/etc\/minio\/minio.conf<\/p>\n
<\/p>\n
vi \/etc\/minio\/minio.conf<\/code><\/pre>\n
<\/p>\n
Hvis du ikke bruker nginx foran Minio, m\u00e5 du endre<\/p>\n
<\/p>\n
--address 127.0.0.1:9000<\/code><\/pre>\n
<\/p>\n
--address 0.0.0.0:9000<\/code><\/pre>\n
<\/p>\n
Vi starter Minio<\/p>\n
<\/p>\n
systemctl start minio<\/code><\/pre>\n
<\/p>\n
G\u00e5 til Minio-webgrensesnittet http:\/\/server-ip-adresse-minio:9000<\/a><\/noindex> og opprett en b\u00f8tte (for eksempel, pg-backups).<\/p>\n
<\/p>\n
DB-server<\/h2>\n
<\/p>\n
Jeg samler WAL-G i rpm (Anton Patsev). Github<\/a><\/noindex>, Fedora COPR<\/a><\/noindex>.<\/p>\n
<\/p>\n
For de som ikke bruker et RPM-basert system, bruker den offisielle instruksjonen<\/a><\/noindex> installasjonen.<\/p>\n
<\/p>\n
Sammen med bin\u00e6rfilen wal-g i rpm f\u00f8lger det skript som importerer variabler fra filen \/etc\/wal-g.d\/server-s3.conf.<\/p>\n
<\/p>\n
backup-fetch.sh\nbackup-list.sh\nbackup-push.sh\nwal-fetch.sh\nwal-g-run.sh\nwal-push.sh<\/code><\/pre>\n
<\/p>\n
Vi installerer wal-g.<\/p>\n
<\/p>\n
yum -y install yum-plugin-copr\nyum copr enable -y antonpatsev\/wal-g\nyum install -y wal-g<\/code><\/pre>\n
<\/p>\n
Vi sjekker versjonen av wal-g.<\/p>\n
<\/p>\n
wal-g --version\nwal-g version v0.2.14<\/code><\/pre>\n
<\/p>\n
Vi redigerer \/etc\/wal-g.d\/server-s3.conf etter egne behov.<\/p>\n
<\/p>\n
Konfigurasjonsfiler og datafiler brukt av databasesystemet lagres tradisjonelt sammen i katalogen for databasens klynge, som vanligvis kalles PGDATA<\/code><\/p>\n
<\/p>\n
#!\/bin\/bash\n\nexport PG_VER="9.6"\n\nexport WALE_S3_PREFIX="s3:\/\/pg-backups" # \u0431\u0430\u043a\u0435\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u043b\u0438 \u0432 S3\nexport AWS_ACCESS_KEY_ID="xxxx" # AccessKey \u0438\u0437 \/etc\/minio\/minio.conf \nexport AWS_ENDPOINT="http:\/\/ip-\u0430\u0434\u0440\u0435\u0441-\u0441\u0435\u0440\u0432\u0435\u0440\u0430-minio:9000"\nexport AWS_S3_FORCE_PATH_STYLE="true"\nexport AWS_SECRET_ACCESS_KEY="yyyy" # SecretKey \u0438\u0437 \/etc\/minio\/minio.conf\n\nexport PGDATA=\/var\/lib\/pgsql\/$PG_VER\/data\/\nexport PGHOST=\/var\/run\/postgresql\/.s.PGSQL.5432 # \u0421\u043e\u043a\u0435\u0442 \u0434\u043b\u044f \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a PostgreSQL\n\nexport WALG_UPLOAD_CONCURRENCY=2 # \u041a\u043e\u043b-\u0432\u043e \u043f\u043e\u0442\u043e\u043a\u043e\u0432 \u0434\u043b\u044f \u0437\u0430\u043a\u0430\u0447\u043a\u0438 \nexport WALG_DOWNLOAD_CONCURRENCY=2 # \u041a\u043e\u043b-\u0432\u043e \u043f\u043e\u0442\u043e\u043a\u043e\u0432 \u0434\u043b\u044f \u0441\u043a\u0430\u0447\u0438\u0432\u0430\u043d\u0438\u044f\nexport WALG_UPLOAD_DISK_CONCURRENCY=2 # \u041a\u043e\u043b-\u0432\u043e \u043f\u043e\u0442\u043e\u043a\u043e\u0432 \u043d\u0430 \u0434\u0438\u0441\u043a\u0435 \u0434\u043b\u044f \u0437\u0430\u043a\u0430\u0447\u043a\u0438\nexport WALG_DELTA_MAX_STEPS=7\nexport WALG_COMPRESSION_METHOD=brotli # \u041a\u0430\u043a\u043e\u0439 \u043c\u0435\u0442\u043e\u0434 \u0441\u0436\u0430\u0442\u0438\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c.\n<\/code><\/pre>\n
<\/p>\n
N\u00e5r du konfigurerer WAL-G, angir du WALG_DELTA_MAX_STEPS \u2014 antall trinn som den maksimale delta-sikkerhetskopien kan avvike fra base-sikkerhetskopien, og angir sjekken for delta-kopier. Du kan enten lage en kopi med den nyeste eksisterende deltaen, eller ta en delta fra den opprinnelige komplette sikkerhetskopien. Dette er viktig i tilfeller hvor den samme komponenten av databasen stadig endres med de samme dataene.<\/p>\n
<\/p>\n
Installerer databasen.<\/p>\n
<\/p>\n
yum install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\nyum install -y postgresql96 postgresql96-server mc<\/code><\/pre>\n
<\/p>\n
Initialiserer databasen.<\/p>\n
<\/p>\n
\/usr\/pgsql-9.6\/bin\/postgresql96-setup initdb\nInitializing database ... OK<\/code><\/pre>\n
<\/p>\n
Hvis du tester p\u00e5 \u00e9n server, m\u00e5 du endre parameteren wal_level til archive for PostgreSQL versjoner under 10, og replica for PostgreSQL versjon 10 og nyere.<\/p>\n
<\/p>\n
wal_level = archive<\/code><\/pre>\n
<\/p>\n
Vi setter opp sikkerhetskopiering av WAL-arkivene hvert 60. sekund ved hjelp av PostgreSQL. P\u00e5 produksjon vil du ha en annen verdi for archive_timeout.<\/p>\n
<\/p>\n
archive_mode = on\narchive_command = '\/usr\/local\/bin\/wal-push.sh %p'\narchive_timeout = 60 # Kommandoen archive_command utf\u00f8res hvert 60. sekund.<\/code><\/pre>\n
<\/p>\n
Starter PostgreSQL<\/p>\n
<\/p>\n
systemctl start postgresql-9.6<\/code><\/pre>\n
<\/p>\n
Sjekker loggene til PostgreSQL for feil i et annet konsoll: (endres postgresql-Wed.log til den aktuelle filen).<\/p>\n
<\/p>\n
tail -fn100 \/var\/lib\/pgsql\/9.6\/data\/pg_log\/postgresql-Wed.log<\/code><\/pre>\n
<\/p>\n
Logger inn i psql.<\/p>\n
<\/p>\n
su - postgres\npsql<\/code><\/pre>\n
<\/p>\n
Oppretter en database i psql.<\/p>\n
<\/p>\n
Oppretter en tabell i databasen test1.<\/p>\n
<\/p>\n
create database test1;<\/code><\/pre>\n
<\/p>\n
Bytter til databasen test.<\/p>\n
<\/p>\n
postgres=# c test1;<\/code><\/pre>\n
<\/p>\n
Oppretter tabellen indexing_table.<\/p>\n
<\/p>\n
test1=# CREATE TABLE indexing_table(created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW());<\/code><\/pre>\n
<\/p>\n
Legger til data.<\/p>\n
<\/p>\n
Kj\u00f8rer dataavsetning. Venter 10-20 minutter.<\/p>\n
<\/p>\n
#!\/bin\/bash\n# postgres\nwhile true; do\npsql -U postgres -d test1 -c "INSERT INTO indexing_table(created_at) VALUES (CURRENT_TIMESTAMP);"\nsleep 60;\ndone<\/code><\/pre>\n
<\/p>\n
S\u00f8rg for \u00e5 ta en fullstendig sikkerhetskopi.<\/p>\n
<\/p>\n
su - postgres\n\/usr\/local\/bin\/backup-push.sh<\/code><\/pre>\n
<\/p>\n
Viser postene i tabellen i databasen test1<\/p>\n
<\/p>\n
select * from indexing_table;\n2020-01-29 09:41:25.226198+\n2020-01-29 09:42:25.336989+\n2020-01-29 09:43:25.356069+\n2020-01-29 09:44:25.37381+\n2020-01-29 09:45:25.392944+\n2020-01-29 09:46:25.412327+\n2020-01-29 09:47:25.432564+\n2020-01-29 09:48:25.451985+\n2020-01-29 09:49:25.472653+\n2020-01-29 09:50:25.491974+\n2020-01-29 09:51:25.510178+<\/code><\/pre>\n
<\/p>\n
Linjen er den n\u00e5v\u00e6rende tiden.<\/p>\n
<\/p>\n
Ser p\u00e5 listen over fullstendige sikkerhetskopier<\/h3>\n
<\/p>\n
\/usr\/local\/bin\/backup-list.sh<\/code><\/pre>\n
<\/p>\n
Testing av gjenoppretting<\/h3>\n
<\/p>\n
Full gjenoppretting med \u00e5 bruke alle tilgjengelige WAL.<\/h4>\n
<\/p>\n
Stopper Postgresql.<\/p>\n
<\/p>\n
Fjerner alt fra mappen \/var\/lib\/pgsql\/9.6\/data.<\/p>\n
<\/p>\n
Kj\u00f8rer skriptet \/usr\/local\/bin\/backup-fetch.sh som bruker postgres-brukeren.<\/p>\n
<\/p>\n
su - postgres\n\/usr\/local\/bin\/backup-fetch.sh<\/code><\/pre>\n
<\/p>\n
Sikkerhetskopiering fullf\u00f8rt.<\/p>\n
<\/p>\n
Legger til recovery.conf i mappen \/var\/lib\/pgsql\/9.6\/data med f\u00f8lgende innhold.<\/p>\n
<\/p>\n
restore_command = '\/usr\/local\/bin\/wal-fetch.sh \"%f\" \"%p\"'<\/code><\/pre>\n
<\/p>\n
Starter PostgreSQL. PostgreSQL vil kj\u00f8re gjenopprettingsprosessen fra de arkiverte WAL, og deretter vil databasen \u00e5pne. <\/p>\n
<\/p>\n
systemctl start postgresql-9.6\ntail -fn100 \/var\/lib\/pgsql\/9.6\/data\/pg_log\/postgresql-Wed.log<\/code><\/pre>\n
<\/p>\n
Gjenoppretting til et bestemt tidspunkt.<\/h4>\n
<\/p>\n
Dersom vi \u00f8nsker \u00e5 gjenopprette databasen til et bestemt tidspunkt, legger vi til parameteren recovery_target_time i recovery.conf \u2014 vi angir hvilket tidspunkt vi vil gjenopprette databasen til.<\/p>\n
<\/p>\n
restore_command = '\/usr\/local\/bin\/wal-fetch.sh \"%f\" \"%p\"'\nrecovery_target_time = '2020-01-29 09:46:25'<\/code><\/pre>\n
<\/p>\n
Etter gjenopprettingen ser vi p\u00e5 tabellen indexing_table<\/p>\n
<\/p>\n
 2020-01-29 09:41:25.226198+00\n 2020-01-29 09:42:25.336989+00\n 2020-01-29 09:43:25.356069+00\n 2020-01-29 09:44:25.37381+00\n 2020-01-29 09:45:25.392944+00<\/code><\/pre>\n
<\/p>\n
Starter PostgreSQL. PostgreSQL vil kj\u00f8re gjenopprettingsprosessen fra de arkiverte WAL, og deretter vil databasen \u00e5pne. <\/p>\n
<\/p>\n
systemctl start postgresql-9.6\ntail -fn100 \/var\/lib\/pgsql\/9.6\/data\/pg_log\/postgresql-Wed.log<\/code><\/pre>\n
<\/p>\n
Testing<\/h3>\n
<\/p>\n
Vi genererer en 1GB database som beskrevet her https:\/\/gist.github.com\/ololobus\/5b25c432f208d7eb31051a5f238dffff<\/a><\/noindex><\/p>\n
<\/p>\n
Vi sp\u00f8r om st\u00f8rrelsen p\u00e5 b\u00f8tta etter \u00e5 ha generert 1GB data.<\/p>\n
<\/p>\n
postgres=# SELECT pg_size_pretty(pg_database_size('test1'));\npg_size_pretty\n----------------\n1003 MB<\/code><\/pre>\n
<\/p>\n
s4cmd \u2014 et gratis kommandolinjeverkt\u00f8y for \u00e5 jobbe med data lagret i Amazon S3. Verkt\u00f8yet er skrevet i programmeringsspr\u00e5ket Python, og kan derfor brukes i b\u00e5de Windows og Linux.<\/p>\n
<\/p>\n
Installer s4cmd<\/p>\n
<\/p>\n
pip install s4cmd<\/code><\/pre>\n
<\/p>\n
LZ4<\/h4>\n
<\/p>\n
s4cmd --endpoint-url=http:\/\/server-ip-address-minio:9000 --access-key=xxxx --secret-key=yyyy du -r s3:\/\/pg-backups\n840540822       s3:\/\/pg-backups\/wal_005\/\n840 MB i lz4-format kun for WAL-loggene\n\nFull backup med lz4 - 1GB data\ntime backup_push.sh\nreal 0m18.582s\n\nSt\u00f8rrelsen p\u00e5 S3-b\u00f8tten etter full backup\n\n581480085       s3:\/\/pg-backups\/basebackups_005\/\n842374424   s3:\/\/pg-backups\/wal_005\n581 MB tar full backup<\/code><\/pre>\n
<\/p>\n
LZMA<\/h4>\n
<\/p>\n
Etter \u00e5 ha generert 1GB data\n338413694       s3:\/\/pg-backups\/wal_005\/\n338 MB logger i lzma-format\n\nTid for \u00e5 generere full backup\ntime backup_push.sh\nreal    5m25.054s\n\nSt\u00f8rrelsen p\u00e5 b\u00f8tten i S3\n270310495       s3:\/\/pg-backups\/basebackups_005\/\n433485092   s3:\/\/pg-backups\/wal_005\/\n\n270 MB tar full backup i lzma-format<\/code><\/pre>\n
<\/p>\n
Brotli<\/h4>\n
<\/p>\n
Etter \u00e5 ha generert 1GB data\n459229886       s3:\/\/pg-backups\/wal_005\/\n459 MB logger i brotli-format\n\nTid for \u00e5 generere full backup\nreal    0m23.408s\n\nSt\u00f8rrelsen p\u00e5 b\u00f8tten i S3\n312960942       s3:\/\/pg-backups\/basebackups_005\/\n459309262   s3:\/\/pg-backups\/wal_005\/\n\n312 MB tar full backup i brotli-format\n<\/code><\/pre>\n
<\/p>\n
Sammenligning av resultatene i grafen.<\/p>\n
<\/p>\n
\"Introduksjon<\/p>\n
<\/p>\n
Som vi ser, er Brotli sammenlignbar i st\u00f8rrelse med LZMA, men backupen fullf\u00f8res p\u00e5 tiden til LZ4.<\/p>\n
<\/p>\n
Chatten til det russisktalende samfunnet PostgreSQL: https:\/\/t.me\/pgsql<\/a><\/noindex><\/p>\n
<\/p>\n
Vennligst gi en stjerne p\u00e5 Github hvis du bruker wal-g<\/a><\/noindex><\/p>\n
Kilde: habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
WAL-G \u2014 \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u0434\u043b\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f PostgreSQL \u0432 \u043e\u0431\u043b\u0430\u043a\u0430. \u041f\u043e \u0441\u0432\u043e\u0435\u0439 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043e\u043d \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043d\u0430\u0441\u043b\u0435\u0434\u043d\u0438\u043a\u043e\u043c \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 WAL-E, \u043d\u043e \u043f\u0435\u0440\u0435\u043f\u0438\u0441\u0430\u043d\u043d\u044b\u043c \u043d\u0430 Go. \u041d\u043e \u0432 WAL-G \u0435\u0441\u0442\u044c \u043e\u0434\u043d\u0430 \u0432\u0430\u0436\u043d\u0430\u044f \u043d\u043e\u0432\u0430\u044f \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044c \u2014 \u0434\u0435\u043b\u044c\u0442\u0430-\u043a\u043e\u043f\u0438\u0438. \u0414\u0435\u043b\u044c\u0442\u0430-\u043a\u043e\u043f\u0438\u0438 WAL-G \u0445\u0440\u0430\u043d\u044f\u0442 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b \u0444\u0430\u0439\u043b\u043e\u0432, \u0438\u0437\u043c\u0435\u043d\u0438\u0432\u0448\u0438\u0435\u0441\u044f \u0441 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0432\u0435\u0440\u0441\u0438\u0438 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0438. \u0412 WAL-G \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043e \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u043f\u043e \u0440\u0430\u0441\u043f\u0430\u0440\u0430\u043b\u043b\u0435\u043b\u0438\u0432\u0430\u043d\u0438\u044e […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":55885,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-55884","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Introduksjon til wal-g backup-systemet for PostgreSQL | ProHoster","description":"WAL-G \u2014 et enkelt og effektivt verkt\u00f8y for sikkerhetskopiering av PostgreSQL til skyer.","canonical_url":"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/znakomstvo-s-wal-g-sistemoj-bekapirovaniya-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"nn_NO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0417\u043d\u0430\u043a\u043e\u043c\u0441\u0442\u0432\u043e \u0441 wal-g \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u0431\u0435\u043a\u0430\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f PostgreSQL | ProHoster","og:description":"WAL-G \u2014 \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u0434\u043b\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f PostgreSQL \u0432 \u043e\u0431\u043b\u0430\u043a\u0430.","og:url":"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/znakomstvo-s-wal-g-sistemoj-bekapirovaniya-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-01-30T21:00:00+00:00","article:modified_time":"2020-02-18T11:04:03+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"55884","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 19:35:40","updated":"2022-09-28 13:58:06","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/55884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/comments?post=55884"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/55884\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/media\/55885"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/media?parent=55884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/categories?post=55884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/tags?post=55884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}