{"blog_url":"https://yohei-a.hatenablog.jp/","provider_name":"Hatena Blog","url":"https://yohei-a.hatenablog.jp/entry/20211109/1636414457","height":"190","categories":["AWS"],"author_url":"https://blog.hatena.ne.jp/yohei-a/","version":"1.0","published":"2021-11-09 08:34:17","type":"rich","description":"AWS DMS \u306e\u30bd\u30fc\u30b9\u304c PostgreSQL \u3067 CDC \u3092\u4f7f\u3046\u5834\u5408\u3001DMS \u30bf\u30b9\u30af\u3092\u505c\u6b62\u3059\u308b\u3068\u3001PostgreSQL \u306e WAL \u304c\u6e9c\u307e\u3063\u3066\u30b9\u30c8\u30ec\u30fc\u30b8\u4f7f\u7528\u91cf\u304c\u5897\u3048\u308b\u3002 \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b9\u30ed\u30c3\u30c8\u3092\u524a\u9664\u3059\u308b\u3068\u3001WAL \u304c\u524a\u9664\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308b\u3002 SELECT * FROM pg_replication_slots; SELECT pg_drop_replication_slot('<\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b9\u30ed\u30c3\u30c8\u540d>') \u305f\u3060\u3057\u3001DMS \u30bf\u30b9\u30af\u3092\u518d\u958b\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u304f\u306a\u308a\u3001\u518d\u540c\u671f\u3057\u305f\u3044\u5834\u5408\u306f\u30d5\u30eb\u30ed\u30fc\u30c9+CDC\u3092\u3084\u308a\u76f4\u3059\u5fc5\u8981\u304c\u3042\u308b\u3002 \u53c2\u8003 RDS for Postgres\u306eDisk\u4f7f\u7528\u91cf\u304c\u6025\u6fc0\u306b\u5897\u3048\u305f\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20211109%2F1636414457\" title=\"AWS DMS \u30bf\u30b9\u30af\u505c\u6b62\u6642\u306b PostgreSQL \u306e WAL \u304c\u6e9c\u308a\u7d9a\u3051\u306a\u3044\u3088\u3046\u306b\u3059\u308b - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"provider_url":"https://hatena.blog","title":"AWS DMS \u30bf\u30b9\u30af\u505c\u6b62\u6642\u306b PostgreSQL \u306e WAL \u304c\u6e9c\u308a\u7d9a\u3051\u306a\u3044\u3088\u3046\u306b\u3059\u308b","blog_title":"ablog","width":"100%","author_name":"yohei-a"}