{"id":45730,"date":"2026-08-10T13:32:02","date_gmt":"2026-08-10T04:32:02","guid":{"rendered":"https:\/\/jore2.com\/?p=45730"},"modified":"2026-08-10T13:32:02","modified_gmt":"2026-08-10T04:32:02","slug":"community-18424-how-we-pushed-cdc-into-postgres","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=45730","title":{"rendered":"\uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\uac00 \ud3ec\uc2a4\ud2b8\uadf8\ub808\ub97c \ub2e4\uc2dc \uc4f4 \uc774\uc720, CDC\uc758 \uc0c8\ub85c\uc6b4 \uc7a5\uc774 \uc5f4\ub9ac\ub2e4"},"content":{"rendered":"<div class=\"jore2-editor-byline\">\n<p><strong>\ubc15\uc11c\uc724<\/strong><\/p>\n<\/div>\n<p>\ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1 \ucee4\ubba4\ub2c8\ud2f0\uc5d0\uc11c \ucd5c\uadfc \uac00\uc7a5 \ub728\uac70\uc6b4 \uac10\uc790\ub294 \ub2e8\uc5f0 \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\uac00 \uacf5\uac1c\ud55c \ud3ec\uc2a4\ud2b8\uadf8\ub808 \ubbf8\ub7ec\ub9c1 \uae30\uc220\uc785\ub2c8\ub2e4. \uc774 \uae30\uc220\uc740 \ub2e8\uc21c\ud788 \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud558\ub294 \uac83\uc744 \ub118\uc5b4 \ud2b8\ub79c\uc7ad\uc158 \uae30\ubc18\uc758 \ubcc0\uacbd \ub370\uc774\ud130 \ucea1\ucc98\ub97c \ub370\uc774\ud130 \ub808\uc774\ud06c\ub85c \uc9c1\uc811 \ubc00\uc5b4 \ub123\ub294 \ubc29\uc2dd\uc744 \ucc44\ud0dd\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uae30\uc874\uc5d0\ub294 \ud3ec\uc2a4\ud2b8\uadf8\ub808\uc758 CDC \ub97c \uad6c\ud604\ud558\uae30 \uc704\ud574 \ub17c\ub9ac\uc801 \ubcf5\uc81c\ub098 \ud2b8\ub9ac\uac70 \uae30\ubc18\uc758 \ubcf5\uc7a1\ud55c \ud30c\uc774\ud504\ub77c\uc778\uc744 \uad6c\ucd95\ud574\uc57c \ud588\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774 \uacfc\uc815\uc5d0\uc11c \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc774\ub098 \uc7a5\uc560 \ubc1c\uc0dd \uc2dc \ud30c\uc774\ud504\ub77c\uc778\uc774 \uc27d\uac8c \ub04a\uae30\ub294 \ubb38\uc81c\uac00 \ube48\ubc88\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\ub294 \uc774\ub7ec\ud55c \ub09c\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ud3ec\uc2a4\ud2b8\uadf8\ub808\uc758 \ubcf5\uc81c \ubc29\uc2dd\uc744 \uadfc\ubcf8\ubd80\ud130 \uc7ac\uc124\uacc4\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>## \uae30\uc874 \ud30c\uc774\ud504\ub77c\uc778\uc758 \ud55c\uacc4\ub97c \ub118\uc5b4\uc11c\ub294 \uae30\uc220\uc801 \uc804\ud658<\/p>\n<p>\uae30\uc874\uc758 CDC \ubc29\uc2dd\uc740 \uc8fc\ub85c \ub85c\uadf8 \uae30\ubc18\uc774\ub098 \ucffc\ub9ac \uae30\ubc18 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. \uc5d0\uc2a4\ud130\ub9ac \uac19\uc740 \uc194\ub8e8\uc158\uc740 \ud3ec\uc2a4\ud2b8\uadf8\ub808\uc758 CDC \ub97c \ub2e4\uc591\ud55c \ubc29\ubc95\uc73c\ub85c \uad6c\ud604\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud558\uba70 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ud30c\uc774\ud504\ub77c\uc778 \uad6c\ucd95\uc744 \ub3d5\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Glossier \ub098 Xometry \uac19\uc740 \uae30\uc5c5\ub4e4\uc740 \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130 \ube44\uc6a9\uc744 \uc808\ubc18 \uc774\uc0c1 \uc808\uac10\ud558\uac70\ub098 \ud1b5\ud569 \ube44\uc6a9\uc744 60 \ud37c\uc13c\ud2b8\ub098 \uc904\uc774\ub294 \uc131\uacfc\ub97c \uac70\ub450\uc5c8\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub7ec\ud55c \uc194\ub8e8\uc158\ub4e4\ub3c4 \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc5d0 \ucde8\uc57d\ud558\uac70\ub098 \ubcf5\uc7a1\ud55c \uc124\uc815\uc774 \ud544\uc694\ud558\ub2e4\ub294 \uacf5\ud1b5\uc801\uc778 \ud55c\uacc4\ub97c \uc548\uace0 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud2b9\ud788 \ub300\uaddc\ubaa8 \ud2b8\ub79c\uc7ad\uc158\uc774 \ube60\ub974\uac8c \uc720\uc785\ub420 \ub54c \ud30c\uc774\ud504\ub77c\uc778\uc774 \ubd95\uad34\ub418\uac70\ub098 \ub370\uc774\ud130 \ubd88\uc77c\uce58\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\uac00 \uc81c\uc2dc\ud55c \uc0c8\ub85c\uc6b4 \ubbf8\ub7ec\ub9c1 \uae30\ub2a5\uc740 \uc774\ub7ec\ud55c \ubcf5\uc7a1\uc131\uc744 \ud68d\uae30\uc801\uc73c\ub85c \ub2e8\uc21c\ud654\ud588\uc2b5\ub2c8\ub2e4. \ud3ec\uc2a4\ud2b8\uadf8\ub808\uc5d0\uc11c \ubc1c\uc0dd\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc544\ud30c\uce58 \uc544\uc774\uc2a4\ubc84\uadf8 \ud14c\uc774\ube14\ub85c \uc9c1\uc811 \ud2b8\ub79c\uc7ad\uc158 \ub2e8\uc704\ub85c \ud478\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uacfc\uc815\uc740 \ubcc4\ub3c4\uc758 \uc778\ud504\ub77c \uc5c6\uc774\ub3c4 \uc11c\ubc84\ub9ac\uc2a4 \ubc29\uc2dd\uc73c\ub85c \uc790\ub3d9\uc73c\ub85c \uc801\uc6a9\ub429\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\ub294 \ub2e8\uc21c\ud788 \ubc84\ud2bc\uc744 \ub204\ub974\uae30\ub9cc \ud558\uba74 \ud3ec\uc2a4\ud2b8\uadf8\ub808 \ud14c\uc774\ube14\uc774 \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\uc5d0 \uc2e4\uc2dc\uac04\uc73c\ub85c \ub3d9\uae30\ud654\ub429\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub294 \ub9c8\uce58 \uc2dc\uacc4 \ud0dc\uc5fd\uc744 \uac10\uc544\ub193\uc740 \uac83\ucc98\ub7fc \uc548\uc815\uc801\uc73c\ub85c \uc791\ub3d9\ud558\ub294 \uc2dc\uc2a4\ud15c\uc73c\ub85c \ud3c9\uac00\ubc1b\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ubcf5\uc7a1\ud55c \uc7a5\uc560 \ucc98\ub9ac \ub85c\uc9c1\uc744 \uc2e0\uacbd \uc4f0\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4\ub294 \uc810\uc774 \uc5d4\uc9c0\ub2c8\uc5b4\ub4e4\uc5d0\uac8c \ud070 \ud638\uc751\uc744 \uc5bb\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>## \ucee4\ubba4\ub2c8\ud2f0\uc758 \ubc18\uc751\uacfc \ud5a5\ud6c4 \ub370\uc774\ud130 \uc544\ud0a4\ud14d\ucc98\uc758 \ubc29\ud5a5\uc131<\/p>\n<p>\ud558\ucee4\ub274\uc2a4\ub97c \ube44\ub86f\ud55c \uae30\uc220 \ucee4\ubba4\ub2c8\ud2f0\uc5d0\uc11c\ub294 \uc774 \ubc1c\ud45c\uc5d0 \ub300\ud574 \ub728\uac70\uc6b4 \ub17c\uc7c1\uc774 \uc77c\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc5b4\ub5a4 \uc774\ub4e4\uc740 \uc774 \uae30\uc220\uc774 \ubca0\ub974\ud2f0\uce74\uc758 WOS \uc640 ROS \ud3ec\ub9f7\uc744 \ud65c\uc6a9\ud55c \ubc29\uc2dd\uacfc \uc720\uc0ac\ud558\ub2e4\uace0 \uc9c0\uc801\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc624\ub77c\ud074 \uace8\ub4e0\uac8c\uc774\ud2b8\ub098 \uc544\ub9c8\uc874\uc758 \uc624\ub85c\ub77c\uc5d0\uc11c \ub808\ub4dc\uc2dc\ud504\ud2b8\ub85c \uac00\ub294 \uc81c\ub85c ETL \ube0c\ub9ac\uc9c0\uc640\ub3c4 \ube44\uad50\ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud3ec\uc2a4\ud2b8\uadf8\ub808 \uc0dd\ud0dc\uacc4\uc5d0\uc11c \uc774 \ubc29\uc2dd\uc774 \uac16\ub294 \uc758\ubbf8\ub294 \ub354\uc6b1 \ud07d\ub2c8\ub2e4.<\/p>\n<p>\uc624\ud508\uc18c\uc2a4 \uc601\uc5ed\uc5d0\uc11c \ubb38\ucf00\uc774\ud06c \ub7a9\uc2a4\uc758 pg_mooncake \ud504\ub85c\uc81d\ud2b8\uc640\ub3c4 \ube44\uad50\ub418\uba70 \ud3ec\uc2a4\ud2b8\uadf8\ub808 \ub370\uc774\ud130\ub97c \uc544\uc774\uc2a4\ubc84\uadf8\ub85c \ud478\ub294 \ub2e4\uc591\ud55c \uc2dc\ub3c4\ub4e4\uc774 \uc8fc\ubaa9\ubc1b\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud074\ub9ad\ud558\uc6b0\uc2a4\uac00 \ud53c\uc5b4\ub514\ube44\ub97c \uc778\uc218\ud558\uba70 \uc774 \ubd84\uc57c\uc5d0\uc11c \uac15\uc138\ub97c \ubcf4\uc778 \ubc14 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\uc758 \uc811\uadfc \ubc29\uc2dd\uc740 \ub370\uc774\ud130 \ub808\uc774\ud06c\uc640 \ubd84\uc11d \uc5d4\uc9c4 \uac04\uc758 \uac04\uadf9\uc744 \uc644\uc804\ud788 \uc5c6\uc564\ub2e4\ub294 \uc810\uc5d0\uc11c \ucc28\ubcc4\ud654\ub429\ub2c8\ub2e4.<\/p>\n<p>\ubb3c\ub9ac\uc801\uc778 \ucef4\ud4e8\ud305\uc774\ub098 \uc785\ucd9c\ub825 \uc6a9\ub7c9\uc5d0 \ub530\ub77c \ubcf5\uc81c \uc18d\ub3c4\uac00 \uc81c\ud55c\ub420 \uc218\ub294 \uc788\uc9c0\ub9cc, \uc804\uccb4\uc801\uc778 \uc2dc\uc2a4\ud15c\uc758 \uc548\uc815\uc131\uc740 \uae30\uc874 \ubc29\uc2dd\ubcf4\ub2e4 \ud6e8\uc52c \ub192\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4\ub4e4\uc740 \uc774\uc81c \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc774\ub098 \uc7a5\uc560 \ubcf5\uad6c \uac19\uc740 \ubcf5\uc7a1\ud55c \ubcc0\uc218\ub97c \ub35c \uac71\uc815\ud574\ub3c4 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub294 \ub370\uc774\ud130 \ud30c\uc774\ud504\ub77c\uc778 \uad6c\ucd95\uc5d0 \ub4e4\uc5b4\uac00\ub294 \uc2dc\uac04\uacfc \ube44\uc6a9\uc744 \ud68d\uae30\uc801\uc73c\ub85c \uc904\uc5ec\uc904 \uac83\uc73c\ub85c \uc608\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \uae30\uc220\uc801 \ubcc0\ud654\ub294 \uace7 \ub370\uc774\ud130 \uc544\ud0a4\ud14d\ucc98\uc758 \ud328\ub7ec\ub2e4\uc784 \uc804\ud658\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158 \ub370\uc774\ud130\uc640 \ubd84\uc11d \ub370\uc774\ud130\ub97c \ubd84\ub9ac\ud558\ub358 \uacfc\uac70\uc758 \ubc29\uc2dd\uc5d0\uc11c \uc2e4\uc2dc\uac04\uc73c\ub85c \ud1b5\ud569\ub418\ub294 \uc0c8\ub85c\uc6b4 \ud750\ub984\uc73c\ub85c \ubc14\ub00c\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uae30\uc5c5\ub4e4\uc740 \ub354 \uc774\uc0c1 \ubcf5\uc7a1\ud55c ETL \ub3c4\uad6c\uc5d0 \uc758\uc874\ud558\uc9c0 \uc54a\uace0\ub3c4 \uc2e4\uc2dc\uac04 \ubd84\uc11d\uc744 \uad6c\ud604\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4. \ub2e4\ub9cc \uc544\uc9c1 \uc774 \uae30\uc220\uc740 \uacf5\uac1c \ud504\ub9ac\ubdf0 \ub2e8\uacc4\uc774\ubbc0\ub85c \uc2e4\uc81c \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c\uc758 \uc131\ub2a5 \uac80\uc99d\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub300\uaddc\ubaa8 \ub370\uc774\ud130\uac00 \ud55c\uaebc\ubc88\uc5d0 \uc720\uc785\ub420 \ub54c\uc758 \ucc98\ub9ac \ub2a5\ub825\uc774\ub098 \uc7a5\uae30\uc801\uc778 \uc548\uc815\uc131\uc740 \uc55e\uc73c\ub85c\uc758 \uad00\uc804 \ud3ec\uc778\ud2b8\uac00 \ub420 \uac83\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1\uc758 \ubbf8\ub798\ub294 \ubcf5\uc7a1\ud568\uc5d0\uc11c \ub2e8\uc21c\ud568\uacfc \uc548\uc815\uc131\uc73c\ub85c \ud5a5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1 \ud604\uc7a5\uc5d0\uc11c \uc624\ub7ab\ub3d9\uc548 \uace8\uce6b\uac70\ub9ac\uc600\ub358 \ud3ec\uc2a4\ud2b8\uadf8\ub808\uc758 \ubcc0\uacbd \ub370\uc774\ud130 \ucea1\ucc98\uac00 \uc2a4\ub178\uc6b0\ud50c\ub808\uc774\ud06c\uc758 \uc0c8\ub85c\uc6b4 \uae30\uc220\ub85c \uc778\ud574 \uc644\uc804\ud788 \ub2ec\ub77c\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ubcf5\uc7a1\ud55c \ud30c\uc774\ud504\ub77c\uc778 \uc5c6\uc774\ub3c4 \ud2b8\ub79c\uc7ad\uc158 \ub2e8\uc704\uc758 \uc2e4\uc2dc\uac04 \ubcf5\uc81c\uac00 \uac00\ub2a5\ud574\uc9c0\uba74\uc11c \ub370\uc774\ud130 \ub808\uc774\ud06c\uc640 \ubd84\uc11d \uc2dc\uc2a4\ud15c \uac04\uc758 \uac04\uadf9\uc774 \uc881\uc544\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":6,"featured_media":45729,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[406],"tags":[29425,29423,29424,29426,13203],"class_list":["post-45730","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-406","tag-cdc","tag-29423","tag-29424","tag-29426","tag-13203"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr.png",960,540,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr-300x169.png",300,169,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr-768x432.png",640,360,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr.png",640,360,false],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr.png",960,540,false],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr.png",960,540,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr-825x540.png",825,540,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/08\/figure-1-blog-graphics-snowflake-postgres-data-mirroring-pupr-590x410.png",590,410,true]},"author_info":{"info":["\ubc15\uc11c\uc724"]},"category_info":"<a href=\"https:\/\/jore2.com\/?cat=406\" rel=\"category\">\uc694\uc998\ub728\ub294\uc18c\uc2dd<\/a>","tag_info":"\uc694\uc998\ub728\ub294\uc18c\uc2dd","comment_count":"0","_links":{"self":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/45730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=45730"}],"version-history":[{"count":0,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/45730\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/45729"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=45730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=45730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=45730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}