{"id":527,"date":"2017-04-20T01:33:55","date_gmt":"2017-04-19T16:33:55","guid":{"rendered":"http:\/\/www.ranran.mydns.jp\/blog\/?p=527"},"modified":"2017-04-20T20:14:39","modified_gmt":"2017-04-20T11:14:39","slug":"mastdon%e3%81%a7%e7%8f%be%e5%9c%a8%e6%8e%a5%e7%b6%9a%e4%b8%ad%e3%81%ae%e3%82%a4%e3%83%b3%e3%82%b9%e3%82%bf%e3%83%b3%e3%82%b9%e4%b8%80%e8%a6%a7%e3%82%92%e5%8f%96%e5%be%97%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"http:\/\/www.ranran.mydns.jp\/blog\/?p=527","title":{"rendered":"Mastodon\u3067\u73fe\u5728\u63a5\u7d9a\u4e2d\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4e00\u89a7\u3092\u53d6\u5f97\u3059\u308b"},"content":{"rendered":"<p>about\u306a\u3089\u63a5\u7d9a\u4e2d\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e&#8221;\u6570&#8221;\u306a\u3089\u308f\u304b\u308b\u3093\u3067\u3059\u304c\u3001<\/p>\n<p><a href=\"http:\/\/www.ranran.mydns.jp\/blog\/wp-content\/uploads\/2017\/04\/9a71833dfe37687acddf3c357249a75f.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-528 size-thumbnail alignnone\" src=\"http:\/\/www.ranran.mydns.jp\/blog\/wp-content\/uploads\/2017\/04\/9a71833dfe37687acddf3c357249a75f-400x265.png\" alt=\"\" width=\"400\" height=\"265\" \/><\/a><\/p>\n<p>\u5b9f\u969b\u3069\u3093\u306a\u30c9\u30e1\u30a4\u30f3\u3068\u63a5\u7d9a\u3057\u3066\u3044\u308b\u304b\u77e5\u308a\u305f\u3044\u5834\u5408\u306b\u8abf\u3079\u308b\u65b9\u6cd5\u3067\u3059\u3002<br \/>\n\u3046\u3061\u306fdocker\u74b0\u5883\u3067\u904b\u7528\u3057\u3066\u3044\u307e\u3059\u304c\u3001PostgreSQL\u306b\u63a5\u7d9a\u3057\u3066SQL\u53e9\u3051\u308c\u3070OK\u3067\u3059\u3002<\/p>\n<p>\u25a0 \u63a5\u7d9a\u30c9\u30e1\u30a4\u30f3\u306e\u4e00\u89a7\u3092\u53d6\u5f97<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n# docker exec -it mastodon_db_1 bash\r\n# psql -U postgres\r\n# select * from (select distinct domain from accounts) as domains;\r\n          domain\r\n---------------------------\r\n social.targaryen.house\r\n\r\n mastodon.potproject.net\r\n gs.yvt.jp\r\n cksv.jp\r\n mstdnjp.wipiano.net\r\n mastodon.noraworld.jp\r\n pawoo.net\r\n z-socialgame.mstdn.cloud\r\n mstdn.h3z.jp\r\n mstdn.techdrive.top\r\n mstdn.hakai-macaron.com\r\n js4.in\r\n yontengop.com\r\n unnerv.jp\r\n mstdn.club\r\n md.ggtea.org\r\n friends.nico\r\n 7144.party\r\n ostatus.ikeji.ma\r\n gnusocial.cardina1.red\r\n octodon.social\r\n cybre.space\r\n mastodon.social\r\n im-in.space\r\n mstdn-workers.com\r\n kero.ccsakura.jp\r\n m6n.onsen.tech\r\n mstdn.maud.io\r\n mstdn.kemono-friends.info\r\n mstdn.social\r\n boitam.eu\r\n mstdn.io\r\n mstdn.sanin.club\r\n mastodon.2502.net\r\n mastodon.paas.jp\r\n mstdn.nere9.help\r\n mstdn.nukaya.net\r\n mastodon.juggler.jp\r\n mstdn.mobilehackerz.jp\r\n mastodon.motcha.tech\r\n m.sighash.info\r\n jp-mstdn.com\r\n mastodon.cloud\r\n mstdn.aoitofu.net\r\n toot.mst-dn.me\r\n mdn.hinaloe.net\r\n mastodon.yumulab.org\r\n mstdn.jp\r\n mstdn.7kry.net\r\n ostatus.isidai.com\r\n pao.moe\r\n toot.kashishokunin.com\r\n mstdn.uec.tokyo\r\n oransns.com\r\n mstdn.haun.jp\r\n gs.smuglo.li\r\n mastodon.oresys.nagoya\r\n toot.yukimochi.jp\r\n(59 rows)\r\n<\/pre>\n<p>\u7a7a\u884c\u304c\u51fa\u3066\u307e\u3059\u304c\u3053\u308c\u306f\u30ed\u30fc\u30ab\u30eb\u30e6\u30fc\u30b6\u30fc\u3067\u3059\u306e\u3067 59 &#8211; 1 = 58\u3067\u63a5\u7d9a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u6570\u306b\u30de\u30c3\u30c1\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u8ffd\u8a18\uff09<\/p>\n<p>v1.2.2\u3067\u7ba1\u7406\u753b\u9762\u306bUI\u304c\u8ffd\u52a0\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>https:\/\/github.com\/tootsuite\/mastodon\/releases<\/p>\n<ul>\n<li>List of known instances in admin UI (<a class=\"issue-link js-issue-link\" title=\"Instances list in admin\" href=\"https:\/\/github.com\/tootsuite\/mastodon\/pull\/2095\" data-id=\"222508221\" data-error-text=\"Failed to load issue title\" data-permission-text=\"Issue title is private\">#2095<\/a>)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>about\u306a\u3089\u63a5\u7d9a\u4e2d\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e&#8221;\u6570&#8221;\u306a\u3089\u308f\u304b\u308b\u3093\u3067\u3059\u304c\u3001 \u5b9f\u969b\u3069\u3093\u306a\u30c9\u30e1\u30a4\u30f3\u3068\u63a5\u7d9a\u3057\u3066\u3044\u308b\u304b\u77e5\u308a\u305f\u3044\u5834\u5408\u306b\u8abf\u3079\u308b\u65b9\u6cd5\u3067\u3059\u3002 \u3046\u3061\u306fdocker\u74b0\u5883\u3067\u904b\u7528\u3057\u3066\u3044\u307e\u3059\u304c\u3001PostgreSQL\u306b\u63a5\u7d9a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,43],"tags":[],"class_list":["post-527","post","type-post","status-publish","format-standard","hentry","category-docker","category-mastodon"],"_links":{"self":[{"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=527"}],"version-history":[{"count":3,"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/527\/revisions"}],"predecessor-version":[{"id":535,"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/527\/revisions\/535"}],"wp:attachment":[{"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=527"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ranran.mydns.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}