{"id":72265,"date":"2020-03-03T08:42:17","date_gmt":"2020-03-03T05:42:17","guid":{"rendered":"https:\/\/prohoster.info\/blog\/postgresql-antipatterns-menyaem-dannye-v-obhod-triggera"},"modified":"2020-03-03T16:13:51","modified_gmt":"2020-03-03T13:13:51","slug":"postgresql-antipatterns-menyaem-dannye-v-obhod-triggera","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/postgresql-antipatterns-menyaem-dannye-v-obhod-triggera","title":{"rendered":"T\u00f6bb h\u00f3nappal ezel\u0151tt az \u00faj Microsoft Edge b\u00f6ng\u00e9sz\u0151 kiterjeszt\u00e9seinek sz\u00e1ma 162 volt.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>El\u0151bb-ut\u00f3bb sokan szembes\u00fclnek azzal a sz\u00fcks\u00e9glettel, hogy valamit t\u00f6megesen m\u00f3dos\u00edtaniuk kell a t\u00e1bl\u00e1zatban. M\u00e1r <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/post\/481610\/\">besz\u00e9ltem arr\u00f3l, hogyan \u00e9rdemes ezt csin\u00e1lni<\/a><\/noindex>, \u00e9s arr\u00f3l is, hogyan nem. Ma a t\u00f6meges friss\u00edt\u00e9s m\u00e1sodik aspektus\u00e1r\u00f3l fogok besz\u00e9lni \u2014 <b>a triggerekr\u0151l<\/b>.<\/p>\n<p>P\u00e9ld\u00e1ul, ha van egy t\u00e1bla, amelyen valamit m\u00f3dos\u00edtani kell, ott l\u00f3g egy cs\u00fanya trigger <code>ON UPDATE<\/code>, amely minden v\u00e1ltoz\u00e1st \u00e1tvisz valamilyen aggreg\u00e1tumba. \u00d6nnek viszont mindent friss\u00edtenie kell (p\u00e9ld\u00e1ul egy \u00faj mez\u0151 inicializ\u00e1l\u00e1sa), annyira \u00f3vatosan, hogy ezek az aggreg\u00e1tumok ne \u00e9rint\u0151djenek.<\/p>\n<h2>Csak egyszer\u0171en kapcsoljuk ki a triggereket!<\/h2>\n<p><\/p>\n<pre><code class=\"sql\">BEGIN;\n  ALTER TABLE ... DISABLE TRIGGER ...;\n  UPDATE ...; -- itt hosszasan\n  ALTER TABLE ... ENABLE TRIGGER ...;\nCOMMIT;<\/code><\/pre>\n<p>\nIgaz\u00e1b\u00f3l itt minden megvan \u2014 <b>m\u00e1r minden l\u00f3g<\/b>.<\/p>\n<p>Mert <code>ALTER TABLE<\/code> r\u00e1vonatkozik <b>Kiz\u00e1r\u00f3 hozz\u00e1f\u00e9r\u00e9s<\/b>-a blokkol\u00e1s, alatt amely senki p\u00e1rhuzamosan v\u00e9grehajtva, m\u00e9g egy egyszer\u0171 <code>SELECT<\/code>, semmit nem tud majd olvasni a t\u00e1bl\u00e1zatb\u00f3l. Teh\u00e1t am\u00edg ez a tranzakci\u00f3 nem \u00e9r v\u00e9get, mindenki, aki csak \u201eolvashatna\u201d, v\u00e1rakozni fog. \u00c9s eml\u00e9ksz\u00fcnk arra, hogy <code>UPDATE<\/code> n\u00e1lunk e-\u00e9l-hossz\u00fa\u2026<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h4>Akkor gyorsan kapcsoljuk ki, majd gyorsan kapcsoljuk be!<\/h4>\n<p><\/p>\n<pre><code class=\"sql\">BEGIN;\n  ALTER TABLE ... DISABLE TRIGGER ...;\nCOMMIT;\n\nUPDATE ...;\n\nBEGIN;\n  ALTER TABLE ... ENABLE TRIGGER ...;\nCOMMIT;<\/code><\/pre>\n<p>\nItt a helyzet m\u00e1r jobb, a v\u00e1rakoz\u00e1si id\u0151 l\u00e9nyegesen r\u00f6videbb. De k\u00e9t probl\u00e9ma elrontja az eg\u00e9sz sz\u00e9ps\u00e9get:<\/p>\n<ul>\n<li><code>ALTER TABLE<\/code> azt v\u00e1rja el az \u00f6sszes t\u00f6bbi m\u0171velet a t\u00e1bl\u00e1zaton, bele\u00e9rtve a hossz\u00faakat <code>SELECT<\/code><\/li>\n<li>M\u00edg a trigger ki van kapcsolva, <b>minden v\u00e1ltoz\u00e1s<\/b> a t\u00e1bl\u00e1zatban, m\u00e9g csak nem is a mi\u00e9nk, \u201eel fog rep\u00fclni\u201d. \u00c9s az aggreg\u00e1tokba h\u00e1t nem fog bejutni, pedig kellene. Nagy baj!<\/li>\n<\/ul>\n<p><\/p>\n<h2>Sesszi\u00f3v\u00e1ltoz\u00f3k kezel\u00e9se<\/h2>\n<p>\nTeh\u00e1t az el\u0151z\u0151 v\u00e1ltozaton egy alapvet\u0151 pontra bukkantunk \u2014 valahogy meg kell tan\u00edtanunk a triggert megk\u00fcl\u00f6nb\u00f6ztetni a \u201emi\u201d m\u00f3dos\u00edt\u00e1sainkat a \u201enem mi\u201d-t\u0151l. A \u201emi\u201d-ket \u00e1t kell engedni, a \u201enem mi\u201d-kre pedig reag\u00e1lni. <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/runtime-config-client\">a sesszi\u00f3v\u00e1ltoz\u00f3kat<\/a><\/noindex>.<\/p>\n<h4>session_replication_role<\/h4>\n<p>\nOlvassuk <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/sql-altertable\">kezel\u0151i k\u00e9zik\u00f6nyv<\/a><\/noindex>:<\/p>\n<blockquote><p>A triggerekr\u0151l val\u00f3 m\u0171k\u00f6d\u00e9sre a konfigur\u00e1ci\u00f3s v\u00e1ltoz\u00f3 is hat\u00e1ssal van <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/runtime-config-client#GUC-SESSION-REPLICATION-ROLE\">session_replication_role<\/a><\/noindex>. Alap\u00e9rtelmezetten (tov\u00e1bbi utas\u00edt\u00e1sok n\u00e9lk\u00fcl) a triggereket aktiv\u00e1lj\u00e1k, amikor a replik\u00e1ci\u00f3s szerep \u2014 \u201eorigin\u201d (alap\u00e9rtelmezetten) vagy \u201elocal\u201d. A triggereket, amelyeket <code>ENABLE REPLICA<\/code>, csak akkor aktiv\u00e1lj\u00e1k, ha <b>a jelenlegi \u00e9szlel\u00e9si m\u00f3d<\/b> \u2014 \u201ereplica\u201d, \u00e9s a triggereket, amelyeket <code>ENABLE ALWAYS<\/code>, minden k\u00f6r\u00fclm\u00e9nyek k\u00f6z\u00f6tt aktiv\u00e1lj\u00e1k, f\u00fcggetlen\u00fcl a jelenlegi replik\u00e1ci\u00f3s m\u00f3dt\u00f3l.<\/p><\/blockquote>\n<p>K\u00fcl\u00f6n\u00f6sen hangs\u00falyozom, hogy a be\u00e1ll\u00edt\u00e1s nem mindenkire vonatkozik egyszerre, mint <code>ALTER TABLE<\/code>, \u00e9s csak a saj\u00e1t k\u00fcl\u00f6nleges kapcsol\u00f3d\u00e1sunkhoz. \u00d6sszess\u00e9g\u00e9ben, hogy ne m\u0171k\u00f6djenek semmilyen alkalmaz\u00e1si trigger:<\/p>\n<pre><code class=\"sql\">SET session_replication_role = replica; -- a triggerek letiltva\nUPDATE ...;\nSET session_replication_role = DEFAULT; -- vissza\u00e1ll\u00edtottuk az alap\u00e1llapotot<\/code><\/pre>\n<p><\/p>\n<h4>A triggeren bel\u00fcli felt\u00e9tel<\/h4>\n<p>\nDe a fent eml\u00edtett p\u00e9lda minden triggerre egyszerre m\u0171k\u00f6dik (vagy el\u0151re \"alter\u00e1lnunk\" kell a triggert, amit nem szeretn\u00e9nk letiltani). De ha nek\u00fcnk sz\u00fcks\u00e9g\u00fcnk van arra, hogy <b>\"le\u00e1ll\u00edtsunk\" egy konkr\u00e9t triggert<\/b>?<\/p>\n<p>Ebben seg\u00edt nek\u00fcnk <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/runtime-config-custom\">\"felhaszn\u00e1l\u00f3i\" session v\u00e1ltoz\u00f3<\/a><\/noindex>:<\/p>\n<blockquote><p>A kiterjeszt\u00e9sek param\u00e9tereinek nevei a k\u00f6vetkez\u0151k\u00e9ppen \u00edr\u00f3dnak: a kiterjeszt\u00e9s neve, pont, majd a t\u00e9nyleges param\u00e9ter neve, hasonl\u00f3an az SQL objektumok teljes nev\u00e9hez. P\u00e9ld\u00e1ul: plpgsql.variable_conflict.<br \/>\nMivel a nem rendszeres param\u00e9terek a megfelel\u0151 kiterjeszt\u00e9si modul bet\u00f6lt\u00e9se n\u00e9lk\u00fcl is be\u00e1ll\u00edthat\u00f3k a folyamatokban, a PostgreSQL elfogadja <b>\u00e9rt\u00e9keket b\u00e1rmilyen k\u00e9tkomponens\u0171 n\u00e9vhez<\/b>.<\/p><\/blockquote>\n<p>El\u0151sz\u00f6r dolgozzuk ki a triggert, k\u00f6r\u00fclbel\u00fcl \u00edgy:<\/p>\n<pre><code class=\"sql\">BEGIN\n    -- a konverzi\u00f3s folyamat sor\u00e1n mindent lehet csin\u00e1lni\n    IF current_setting('mycfg.my_table_convert_process') = 'TRUE' THEN\n        IF TG_OP IN ('INSERT', 'UPDATE') THEN\n            RETURN NEW;\n        ELSE\n            RETURN OLD;\n        END IF;\n    END IF;\n...<\/code><\/pre>\n<p>\nEgy\u00e9bk\u00e9nt ezt \"\u00e9l\u0151ben\" is meg lehet csin\u00e1lni, z\u00e1rak n\u00e9lk\u00fcl, a k\u00f6vetkez\u0151k \u00e1ltal <code>CREATE OR REPLACE<\/code> a trigger funkci\u00f3hoz. Azt\u00e1n a k\u00fcl\u00f6nleges kapcsolaton aktiv\u00e1ljuk a \"saj\u00e1t\" v\u00e1ltoz\u00f3nkat:<\/p>\n<pre><code class=\"sql\">\nSET mycfg.my_table_convert_process = 'TRUE';\nUPDATE ...;\nSET mycfg.my_table_convert_process = ''; -- vissza\u00e1ll\u00edtottuk az alap\u00e1llapotot\n<\/code><\/pre>\n<p>\nIsmersz m\u00e1s m\u00f3dszereket? Oszd meg a v\u00e9lem\u00e9nyed a megjegyz\u00e9sekben.<br \/>\n<br \/>Forr\u00e1s: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/tensor\/blog\/489900\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0420\u0430\u043d\u043e \u0438\u043b\u0438 \u043f\u043e\u0437\u0434\u043d\u043e \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u044e\u0442\u0441\u044f \u0441 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c\u044e \u0447\u0442\u043e-\u0442\u043e \u043c\u0430\u0441\u0441\u043e\u0432\u043e \u0438\u0441\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u0432 \u0437\u0430\u043f\u0438\u0441\u044f\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u044b. \u042f \u0443\u0436\u0435 \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u044b\u0432\u0430\u043b, \u043a\u0430\u043a \u044d\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c \u043b\u0443\u0447\u0448\u0435, \u0430 \u043a\u0430\u043a \u2014 \u043b\u0443\u0447\u0448\u0435 \u043d\u0435 \u0434\u0435\u043b\u0430\u0442\u044c. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443 \u043e \u0432\u0442\u043e\u0440\u043e\u043c \u0430\u0441\u043f\u0435\u043a\u0442\u0435 \u043c\u0430\u0441\u0441\u043e\u0432\u043e\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u2014 \u043e \u0441\u0440\u0430\u0431\u043e\u0442\u043a\u0435 \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u043e\u0432. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u0435, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0432\u0430\u043c \u043d\u0430\u0434\u043e \u0447\u0442\u043e-\u0442\u043e \u043f\u043e\u043f\u0440\u0430\u0432\u0438\u0442\u044c, \u0432\u0438\u0441\u0438\u0442 \u0437\u043b\u043e\u0431\u043d\u044b\u0439 \u0442\u0440\u0438\u0433\u0433\u0435\u0440 ON UPDATE, \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u044f\u0449\u0438\u0439 \u0432\u0441\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0432 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-72265","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0420\u0430\u043d\u043e \u0438\u043b\u0438 \u043f\u043e\u0437\u0434\u043d\u043e \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u044e\u0442\u0441\u044f \u0441 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c\u044e \u0447\u0442\u043e-\u0442\u043e \u043c\u0430\u0441\u0441\u043e\u0432\u043e \u0438\u0441\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u0432 \u0437\u0430\u043f\u0438\u0441\u044f\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u044b.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/postgresql-antipatterns-menyaem-dannye-v-obhod-triggera\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47PostgreSQL Antipatterns: \u043c\u0435\u043d\u044f\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u043e\u0431\u0445\u043e\u0434 \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u0430 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0420\u0430\u043d\u043e \u0438\u043b\u0438 \u043f\u043e\u0437\u0434\u043d\u043e \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u044e\u0442\u0441\u044f \u0441 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c\u044e \u0447\u0442\u043e-\u0442\u043e \u043c\u0430\u0441\u0441\u043e\u0432\u043e \u0438\u0441\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u0432 \u0437\u0430\u043f\u0438\u0441\u044f\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u044b.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/postgresql-antipatterns-menyaem-dannye-v-obhod-triggera\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-03-03T05:42:17+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-03-03T13:13:51+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47PostgreSQL Antipatterns: adatok m\u00f3dos\u00edt\u00e1sa a trigger megker\u00fcl\u00e9s\u00e9vel | ProHoster","description":"Korai vagy k\u00e9s\u0151i, sokan tal\u00e1lkoznak azzal a sz\u00fcks\u00e9glettel, hogy valamit t\u00f6megesen jav\u00edtani kell a t\u00e1bl\u00e1zat bejegyz\u00e9sein.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/postgresql-antipatterns-menyaem-dannye-v-obhod-triggera","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\udd47PostgreSQL Antipatterns: \u043c\u0435\u043d\u044f\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u043e\u0431\u0445\u043e\u0434 \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u0430 | ProHoster","og:description":"\u0420\u0430\u043d\u043e \u0438\u043b\u0438 \u043f\u043e\u0437\u0434\u043d\u043e \u043c\u043d\u043e\u0433\u0438\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u044e\u0442\u0441\u044f \u0441 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c\u044e \u0447\u0442\u043e-\u0442\u043e \u043c\u0430\u0441\u0441\u043e\u0432\u043e \u0438\u0441\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u0432 \u0437\u0430\u043f\u0438\u0441\u044f\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u044b.","og:url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/postgresql-antipatterns-menyaem-dannye-v-obhod-triggera","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-03-03T05:42:17+00:00","article:modified_time":"2020-03-03T13:13:51+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"72265","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 18:47:24","updated":"2022-09-27 18:26:38","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/72265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=72265"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/72265\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=72265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=72265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=72265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}