{"id":2415,"date":"2022-12-30T18:55:24","date_gmt":"2022-12-30T09:55:24","guid":{"rendered":"https:\/\/www.agile-software.site\/?p=2415"},"modified":"2023-01-08T18:53:53","modified_gmt":"2023-01-08T09:53:53","slug":"2415","status":"publish","type":"post","link":"https:\/\/agile-software.net\/?p=2415","title":{"rendered":"PostgreSQL\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u4e0a\u3067\u64cd\u4f5c\/\u7ba1\u7406\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u305f\u3082\u306e\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0(DBMS)\u3068\u547c\u3073\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u4fc2\u30e2\u30c7\u30eb\u3092\u5229\u7528\u3057\u305fDBMS\u3092\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(RDBMS)\u3068\u547c\u3073\u307e\u3059<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<p>PostgreSQL\u306eWindows\u7248\u30d1\u30c3\u30b1\u30fc\u30b8\u306b\u306fWindows\u30e6\u30fc\u30b6\u30fc\u5411\u3051\u306bGUI\u4e0a\u3067\u69d8\u3005\u306a\u8a2d\u5b9a\u304c\u53ef\u80fd\u306a\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u307e\u305f\u3001PostgreSQL\u3092\u7ba1\u7406\u3059\u308bGUI\u30c4\u30fc\u30eb\u300cpgAdmin 4\u300d\u304c\u540c\u68b1\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n\n\n\n<p>Web\u30da\u30fc\u30b8\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066PostgreSQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.enterprisedb.com\/downloads\/postgres-postgresql-downloads\">https:\/\/www.enterprisedb.com\/downloads\/postgres-postgresql-downloads<\/a><\/p>\n\n\n\n<p>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fpostgresql-15.1-1-windows-x64.exe\u304cPostgreSQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"432\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30.png\" alt=\"\" class=\"wp-image-2416\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"432\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_2.png\" alt=\"\" class=\"wp-image-2417\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u306e\u9078\u629e<\/h4>\n\n\n\n<p>\u300cPostgreSQL Server\u300d\u304cPostgreSQL\u306e\u672c\u4f53\u3067\u3059\u3002\u300cpgAdmin4\u300d\u306fPostgreSQL\u306eGUI\u7ba1\u7406\u30c4\u30fc\u30eb\u3067\u3059\u3002\u300cStack Builder\u306f\u300dPostgreSQL\u306b\u95a2\u9023\u3059\u308b\u30c4\u30fc\u30eb\u3084\u30c9\u30e9\u30a4\u30d0\u30fc\u3001Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3001Web\u958b\u767a\u7528\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u306a\u3069\u306e\u8ffd\u52a0\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u304d\u306b\u4f7f\u3044\u307e\u3059\u3002\u300cCommand Line Tools\u300d\u306fPostgreSQL\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30e9\u30a4\u30d6\u30e9\u30ea\u3084\u30c4\u30fc\u30eb\u7fa4\u304c\u7d0d\u3081\u3089\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"432\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_3.png\" alt=\"\" class=\"wp-image-2418\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"432\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_4.png\" alt=\"\" class=\"wp-image-2419\"\/><\/figure>\n\n\n\n<p>PostgreSQL\u306e\u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6\u30fc\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"432\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_5.png\" alt=\"\" class=\"wp-image-2420\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u30dd\u30fc\u30c8\u756a\u53f7\u306e\u6307\u5b9a<\/h4>\n\n\n\n<p>PostgreSQL\u306e\u30b5\u30fc\u30d0\u30fc\u304c\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u306e\u63a5\u7d9a\u3092\u53d7\u3051\u4ed8\u3051\u308b\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"432\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_6.png\" alt=\"\" class=\"wp-image-2422\"\/><\/figure>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30af\u30e9\u30b9\u30bf\u306e\u30ed\u30b1\u30fc\u30eb\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u30ed\u30b1\u30fc\u30eb\u3068\u306f\u6587\u5b57\u306e\u4e26\u3079\u66ff\u3048\u3084\u7a2e\u985e\u3001\u901a\u8ca8\u3084\u6570\u5b57\u3001\u65e5\u4ed8\u306e\u66f8\u5f0f\u306a\u3069\u3001\u8a00\u8a9e\u3084\u5730\u57df\u3054\u3068\u306e\u52d5\u4f5c\u306e\u9055\u3044\u3092\u53d6\u308a\u6271\u3046\u305f\u3081\u306e\u4ed5\u7d44\u307f\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"432\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_7.png\" alt=\"\" class=\"wp-image-2423\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30bf\u30c3\u30af\u30d3\u30eb\u30c0\u306b\u3088\u308b\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"419\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_8.png\" alt=\"\" class=\"wp-image-2424\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"419\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_9.png\" alt=\"\" class=\"wp-image-2425\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"419\" src=\"https:\/\/www.agile-software.site\/wp-content\/uploads\/2022\/12\/2022-12-30_10.png\" alt=\"\" class=\"wp-image-2426\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30b9\u306e\u8a2d\u5b9a<\/h2>\n\n\n\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304c\u7d42\u4e86\u3057\u305f\u3089\u3001\u6b21\u306b\u74b0\u5883\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u304b\u3089PostgreSQL\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3067\u304d\u308b\u3088\u3046\u306b\u3001\u74b0\u5883\u5909\u6570PATH\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30af\u30e9\u30b9\u30bf\u3068\u306fPostgreSQL\u304c\u7ba1\u7406\u3059\u308b\u30c7\u30fc\u30bf\u3092\u5b9f\u969b\u306b\u8a18\u9332\u3059\u308b\u305f\u3081\u306e\u9818\u57df\u3067\u3059\u3002<br>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30af\u30e9\u30b9\u30bf\u306b\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u60c5\u5831\u3084\u30e6\u30fc\u30b6\u30fc\u60c5\u5831\u306a\u3069\u3001\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5171\u901a\u306e\u30c7\u30fc\u30bf\u3082\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002<br>\u3053\u306e\u9818\u57df\u3092\u4e8b\u524d\u306b\u4f5c\u6210\u3057\u3066\u304a\u304b\u306a\u3044\u3068\u3001PostgreSQL\u30b5\u30fc\u30d0\u30fc\u3092\u8d77\u52d5\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>initdb\u306e\u5b9f\u884c\u76f4\u5f8c\u306f\u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6\u30fc\u3057\u304b\u3044\u307e\u305b\u3093\u3002<br>\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3059\u308b\u306b\u306fcreateuser\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>create <\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u30b5\u30fc\u30d0\u30fc\u306e\u8d77\u52d5<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>pg_ctl start<\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u30b5\u30fc\u30d0\u30fc\u306e\u505c\u6b62<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>pg_ctl stop<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u4e0a\u3067\u64cd\u4f5c\/\u7ba1\u7406\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u305f\u3082\u306e\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0(DBMS)\u3068\u547c\u3073\u307e\u3059\u3002 \u95a2\u4fc2\u30e2\u30c7\u30eb\u3092\u5229\u7528\u3057\u305fDBMS\u3092\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(RDBMS)\u3068\u547c\u3073\u307e\u3059 Postgre<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jin_ogp_image_url":"","_jin_last_featured_id":0,"footnotes":""},"categories":[57],"tags":[],"class_list":["post-2415","post","type-post","status-publish","format-standard","hentry","category-57"],"_links":{"self":[{"href":"https:\/\/agile-software.net\/index.php?rest_route=\/wp\/v2\/posts\/2415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agile-software.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/agile-software.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/agile-software.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/agile-software.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2415"}],"version-history":[{"count":3,"href":"https:\/\/agile-software.net\/index.php?rest_route=\/wp\/v2\/posts\/2415\/revisions"}],"predecessor-version":[{"id":2477,"href":"https:\/\/agile-software.net\/index.php?rest_route=\/wp\/v2\/posts\/2415\/revisions\/2477"}],"wp:attachment":[{"href":"https:\/\/agile-software.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/agile-software.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/agile-software.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}