{"id":995,"date":"2023-10-29T21:59:08","date_gmt":"2023-10-29T12:59:08","guid":{"rendered":"https:\/\/shinke1987.net\/?p=995"},"modified":"2024-03-14T09:15:26","modified_gmt":"2024-03-14T00:15:26","slug":"docker%e3%82%b3%e3%83%b3%e3%83%86%e3%83%8a%e3%82%92%e5%88%a9%e7%94%a8%e3%81%97%e3%81%a6laravel-postgresql-%e7%92%b0%e5%a2%83%e3%82%92%e4%bd%9c%e3%81%a3%e3%81%9f%e6%99%82%e3%81%ae%e3%83%ad%e3%82%b0","status":"publish","type":"post","link":"https:\/\/shinke1987.net\/?p=995","title":{"rendered":"Docker\u30b3\u30f3\u30c6\u30ca\u3092\u5229\u7528\u3057\u3066Laravel + PostgreSQL \u74b0\u5883\u3092\u4f5c\u3063\u305f\u6642\u306e\u30ed\u30b0"},"content":{"rendered":"\n<h2 id=\"toc0\" class=\"wp-block-heading\">\u6982\u8981<\/h2>\n\n\n\n<p>Laravel\u3060\u3051\u30671\u3064\u306e\u30b3\u30f3\u30c6\u30ca\u3001PostgreSQL\u3060\u3051\u30671\u3064\u306e\u30b3\u30f3\u30c6\u30ca\u3001\u5408\u8a082\u500b\u306e\u30b3\u30f3\u30c6\u30ca\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u76ee\u6a19\u3068\u3057\u3066\u306fLaravel\u304b\u3089PostgreSQL\u3078\u30de\u30a4\u30b0\u30ec\u30fc\u30c8\u304c\u3067\u304d\u308b\u3053\u3068\u3002<\/p>\n\n\n\n<h2 id=\"toc1\" class=\"wp-block-heading\">\u624b\u9806<\/h2>\n\n\n\n<p>\u6e96\u5099\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306f\u4e0b\u8a18\u53c2\u7167\u3002<\/p>\n\n\n\n<p>docker-compose.yml \u306e\u5b58\u5728\u3059\u308b\u5834\u6240\u3067\u3001PowerShell\u306b\u3066\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\ndocker compose up -d\n<\/pre><\/div>\n\n\n<p>PHP-Apache\u306e\u30b3\u30f3\u30c6\u30ca\u5185\u306b\u3066\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n# composer create-project laravel\/laravel .\n<\/pre><\/div>\n\n\n<p>\uff08\u5fc5\u8981\u306b\u5fdc\u3058\u3066\uff09WSL\u306b\u3066\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n$ sudo chmod -R 777 \/Development\/TestSite\/*\n$ sudo chmod -R 777 \/Development\/TestSite\/.*\n<\/pre><\/div>\n\n\n<p>Laravel\u306e.env\u30d5\u30a1\u30a4\u30eb\u3092\u6b21\u306e\u3088\u3046\u306b\u7de8\u96c6\u3002<br>\uff08\u7de8\u96c6\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306btinker\u3067\u78ba\u8a8d\u3057\u305f\u65b9\u304c\u826f\u3044\uff09<br>\uff08\u3053\u306e\u5834\u5408\u306f\u30b3\u30f3\u30c6\u30ca\u540d\u3060\u3051\u3067\u30b3\u30f3\u30c6\u30ca\u9593\u901a\u4fe1\u53ef\u80fd\uff09<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDB_CONNECTION=pgsql \nDB_HOST=PostgreSQL \nDB_PORT=5432 \nDB_DATABASE=TestDB \nDB_USERNAME=shinke1987 \nDB_PASSWORD=password\n<\/pre><\/div>\n\n\n<p>PHP-Apache\u306e\u30b3\u30f3\u30c6\u30ca\u5185\u306b\u3066\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n$ php artisan migrate:install\n$ php artisan migrate\n<\/pre><\/div>\n\n\n<h3 id=\"toc2\" class=\"wp-block-heading\">\u78ba\u8a8d<\/h3>\n\n\n\n<p>\u4e0a\u8a18\u624b\u9806\u3067\u30a8\u30e9\u30fc\u304c\u51fa\u305a\u306b\u3001DB\u306b\u3066\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u308c\u3070\u5b8c\u4e86\u3002<\/p>\n\n\n\n<p>\u3064\u3044\u3067\u306b\u6b21\u306eURL\u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3001Laravel\u306ewelcome\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3002<br>http:\/\/\u30c9\u30e1\u30a4\u30f3\u540d\/public<\/p>\n\n\n\n<p>PostgreSQL\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u304c\u53cd\u6620\u3055\u308c\u3066\u308b\u304b\u78ba\u8a8d\u3057\u305f\u3051\u308c\u3070\u3001<br>psql\u7b49\u3067\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001\u7d50\u679c\u304con\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308c\u3070\u826f\u3044\u3002<br>\uff08\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306f\u898b\u76f4\u305b\u3070\u3082\u3063\u3068\u826f\u3044\u8a2d\u5b9a\u304c\u3042\u308b\u306f\u305a\uff09<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nshow logging_collector;\n<\/pre><\/div>\n\n\n<h2 id=\"toc3\" class=\"wp-block-heading\">docker compose \u30b3\u30de\u30f3\u30c9\u5b9f\u884c\u6642\u306eWindows\u3067\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u69cb\u9020<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDockerfile\n\u251c docker-compose.yml\n\u251c .env\n\u251c PHP-Apache\n\u2502 \u251c 000-default.conf\n\u2502 \u251c apache2.conf\n\u2502 \u251c Dockerfile\n\u2502 \u2514 php.ini\n\u2514 PostgreSQL\n\u3000 \u251c Dockerfile\n\u3000 \u251c pg_hba.conf\n\u3000 \u2514 postgresql.conf \uff08\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3060\u3051\u9069\u5b9c\u79fb\u52d5\uff09\n<\/pre><\/div>\n\n\n<h2 id=\"toc4\" class=\"wp-block-heading\">docker-compose.yml \u306e\u5185\u5bb9<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: yaml; title: ; notranslate\" title=\"\">\nversion: &quot;3&quot;\nservices:\n  php-apache:\n    build: .\/PHP-Apache\n    container_name: PHP-Apache\n    ports:\n      - 80:80\n    volumes:\n      - \\\\wsl.localhost\\Ubuntu\\Development\\TestSite:\/var\/www\/html\n  postgresql:\n    build: .\/PostgreSQL\n    container_name: PostgreSQL\n    ports:\n      - 5432:5432\n    volumes:\n      - \\\\wsl.localhost\\Ubuntu\\Development\\DevEnvironment\\postgresql.conf:\/etc\/postgresql\/postgresql.conf\n    command: &#039;-c config_file=\/etc\/postgresql\/postgresql.conf&#039;\n<\/pre><\/div>\n\n\n<h2 id=\"toc5\" class=\"wp-block-heading\">.env(docker-compose.yml\u7528) \u306e\u5185\u5bb9<\/h2>\n\n\n\n<p>\uff08\u203b \u5927\u6587\u5b57\u3092\u5165\u308c\u3066\u306f\u3044\u3051\u306a\u3044\uff09<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nCOMPOSE_PROJECT_NAME=laravel\n<\/pre><\/div>\n\n\n<h2 id=\"toc6\" class=\"wp-block-heading\">Dockerfile(PHP-Apache) \u306e\u5185\u5bb9<\/h2>\n\n\n\n<p>\uff08\u524d\u56de\u306e\u3082\u306e\u306bapt-get install\u6642\u306bgit \u3068 unzip \u3092\u8ffd\u52a0\u3057\u305f\u3060\u3051\uff09<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nFROM php:8.2.11-apache\nLABEL authors=&quot;shinke1987&quot;\n\n# Composer\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002\n# Composer\u306e\u516c\u5f0f\u30da\u30fc\u30b8\u304b\u3089\u5f15\u7528\u3002\nCOPY --from=composer\/composer:latest-bin \/composer \/usr\/bin\/composer\n\n# \u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3002\nRUN apt-get update\nRUN apt-get -y install less git unzip\n\n# \u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306e\u8a2d\u5b9a\nRUN cp \/usr\/share\/zoneinfo\/Asia\/Tokyo \/etc\/localtime\n\n# pdo_pgsql\u3067\u5fc5\u8981\u3002\nRUN apt-get -y install libpq-dev\n\n# apachectl status \u30b3\u30de\u30f3\u30c9\u306e\u5b9f\u884c\u306b\u5fc5\u8981\u3002\nRUN apt-get -y install lynx\n\n# Apache\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30b3\u30d4\u30fc\u3002\nCOPY .\/apache2.conf \/etc\/apache2\/\nCOPY .\/000-default.conf \/etc\/apache2\/sites-available\/\n\n# PHP\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30b3\u30d4\u30fc\u3002\nCOPY .\/php.ini \/usr\/local\/etc\/php\/\n\n# 20240314\u8ffd\u8a18\u3002\n# mod_rewrite\u3092\u6709\u52b9\u5316\u3002\uff08https:\/\/URL\/aiueo\u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066404\u3068\u3057\u306a\u3044\u305f\u3081\uff09\nRUN a2enmod rewrite\n\n# Laravel\u3067\u5fc5\u8981\u306aPHP\u306e\u62e1\u5f35\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u8a2d\u5b9a\u3002\nRUN docker-php-ext-install pdo_pgsql\n\n# xDebug\nRUN pecl install xdebug-3.2.2\n#Build process completed successfully\n#Installing &#039;\/usr\/local\/lib\/php\/extensions\/no-debug-non-zts-20220829\/xdebug.so&#039;\n#install ok: channel:\/\/pecl.php.net\/xdebug-3.2.2\n#configuration option &quot;php_ini&quot; is not set to php.ini location\n#You should add &quot;zend_extension=\/usr\/local\/lib\/php\/extensions\/no-debug-non-zts-20220829\/xdebug.so&quot; to php.ini\nRUN docker-php-ext-enable xdebug\n\n# Apache\u8d77\u52d5\u3002\nCMD &#x5B;&quot;apache2-foreground&quot;]\n<\/pre><\/div>\n\n\n<h2 id=\"toc7\" class=\"wp-block-heading\">Dockerfile(PostgreSQL) \u306e\u5185\u5bb9<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nFROM postgres:14.9\nLABEL authors=&quot;shinke1987&quot;\n\n# \u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3002\nRUN apt-get update\nRUN apt-get -y install less\n\n# \u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306e\u8a2d\u5b9a\u3002\nRUN cp \/usr\/share\/zoneinfo\/Asia\/Tokyo \/etc\/localtime\n\n\n# \u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6\u540d\u3092\u8a2d\u5b9a\u3002\nENV POSTGRES_USER shinke1987\n\n# \u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3002\nENV POSTGRES_PASSWORD password\n\n# \u30c7\u30d5\u30a9\u30eb\u30c8\u306eDB\u306e\u540d\u524d\u3092\u8a2d\u5b9a\u3002\nENV POSTGRES_DB TestDB\n\n# initdb\u5b9f\u884c\u6642\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3002\nENV POSTGRES_INITDB_ARGS=&#039;-E UTF8 --no-locale&#039;\n<\/pre><\/div>\n\n\n<h2 id=\"toc8\" class=\"wp-block-heading\">Apache \u3068 PHP \u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb<\/h2>\n\n\n\n<p>\u4e0b\u8a18\u306e\u524d\u8a18\u4e8b\u3068\u540c\u3058\u3001apache2.conf \u3068 000-default.conf \u3068 php.ini \u3092\u5229\u7528\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-shinke-1987-net wp-block-embed-shinke-1987-net\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"LW8dtvFV4X\"><a href=\"https:\/\/shinke1987.net\/?p=979\">Docker\u3067\u7df4\u7fd2\u7528Apache+PHP\u74b0\u5883\u3092\u6e96\u5099<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Docker\u3067\u7df4\u7fd2\u7528Apache+PHP\u74b0\u5883\u3092\u6e96\u5099&#8221; &#8212; shinke1987.net\" src=\"https:\/\/shinke1987.net\/?p=979&#038;embed=true#?secret=kfcI9QFSze#?secret=LW8dtvFV4X\" data-secret=\"LW8dtvFV4X\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 id=\"toc9\" class=\"wp-block-heading\">postgresql.conf \u306e\u5185\u5bb9<\/h2>\n\n\n\n<p>\uff08\u300c\u5909\u66f4\u300d\u3067\u691c\u7d22\u3059\u308c\u3070\u826f\u3044\uff09<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n# -----------------------------\n# PostgreSQL configuration file\n# -----------------------------\n#\n# This file consists of lines of the form:\n#\n#   name = value\n#\n# (The &quot;=&quot; is optional.)  Whitespace may be used.  Comments are introduced with\n# &quot;#&quot; anywhere on a line.  The complete list of parameter names and allowed\n# values can be found in the PostgreSQL documentation.\n#\n# The commented-out settings shown in this file represent the default values.\n# Re-commenting a setting is NOT sufficient to revert it to the default value;\n# you need to reload the server.\n#\n# This file is read on server startup and when the server receives a SIGHUP\n# signal.  If you edit the file on a running system, you have to SIGHUP the\n# server for the changes to take effect, run &quot;pg_ctl reload&quot;, or execute\n# &quot;SELECT pg_reload_conf()&quot;.  Some parameters, which are marked below,\n# require a server shutdown and restart to take effect.\n#\n# Any parameter can also be given as a command-line option to the server, e.g.,\n# &quot;postgres -c log_connections=on&quot;.  Some parameters can be changed at run time\n# with the &quot;SET&quot; SQL command.\n#\n# Memory units:  B  = bytes            Time units:  us  = microseconds\n#                kB = kilobytes                     ms  = milliseconds\n#                MB = megabytes                     s   = seconds\n#                GB = gigabytes                     min = minutes\n#                TB = terabytes                     h   = hours\n#                                                   d   = days\n\n\n#------------------------------------------------------------------------------\n# FILE LOCATIONS\n#------------------------------------------------------------------------------\n\n# The default values of these variables are driven from the -D command-line\n# option or PGDATA environment variable, represented here as ConfigDir.\n\n#data_directory = &#039;ConfigDir&#039;\t\t# use data in another directory\n\t\t\t\t\t# (change requires restart)\n#hba_file = &#039;ConfigDir\/pg_hba.conf&#039;\t# host-based authentication file\n\t\t\t\t\t# (change requires restart)\n#ident_file = &#039;ConfigDir\/pg_ident.conf&#039;\t# ident configuration file\n\t\t\t\t\t# (change requires restart)\n\n# If external_pid_file is not explicitly set, no extra PID file is written.\n#external_pid_file = &#039;&#039;\t\t\t# write an extra PID file\n\t\t\t\t\t# (change requires restart)\n\n\n#------------------------------------------------------------------------------\n# CONNECTIONS AND AUTHENTICATION\n#------------------------------------------------------------------------------\n\n# - Connection Settings -\n\nlisten_addresses = &#039;*&#039;\n\t\t\t\t\t# comma-separated list of addresses;\n\t\t\t\t\t# defaults to &#039;localhost&#039;; use &#039;*&#039; for all\n\t\t\t\t\t# (change requires restart)\n#port = 5432\t\t\t\t# (change requires restart)\nmax_connections = 100\t\t\t# (change requires restart)\n#superuser_reserved_connections = 3\t# (change requires restart)\n#unix_socket_directories = &#039;\/var\/run\/postgresql&#039;\t# comma-separated list of directories\n\t\t\t\t\t# (change requires restart)\n#unix_socket_group = &#039;&#039;\t\t\t# (change requires restart)\n#unix_socket_permissions = 0777\t\t# begin with 0 to use octal notation\n\t\t\t\t\t# (change requires restart)\n#bonjour = off\t\t\t\t# advertise server via Bonjour\n\t\t\t\t\t# (change requires restart)\n#bonjour_name = &#039;&#039;\t\t\t# defaults to the computer name\n\t\t\t\t\t# (change requires restart)\n\n# - TCP settings -\n# see &quot;man tcp&quot; for details\n\n#tcp_keepalives_idle = 0\t\t# TCP_KEEPIDLE, in seconds;\n\t\t\t\t\t# 0 selects the system default\n#tcp_keepalives_interval = 0\t\t# TCP_KEEPINTVL, in seconds;\n\t\t\t\t\t# 0 selects the system default\n#tcp_keepalives_count = 0\t\t# TCP_KEEPCNT;\n\t\t\t\t\t# 0 selects the system default\n#tcp_user_timeout = 0\t\t\t# TCP_USER_TIMEOUT, in milliseconds;\n\t\t\t\t\t# 0 selects the system default\n\n#client_connection_check_interval = 0\t# time between checks for client\n\t\t\t\t\t# disconnection while running queries;\n\t\t\t\t\t# 0 for never\n\n# - Authentication -\n\n#authentication_timeout = 1min\t\t# 1s-600s\n#password_encryption = scram-sha-256\t# scram-sha-256 or md5\n#db_user_namespace = off\n\n# GSSAPI using Kerberos\n#krb_server_keyfile = &#039;FILE:${sysconfdir}\/krb5.keytab&#039;\n#krb_caseins_users = off\n\n# - SSL -\n\n#ssl = off\n#ssl_ca_file = &#039;&#039;\n#ssl_cert_file = &#039;server.crt&#039;\n#ssl_crl_file = &#039;&#039;\n#ssl_crl_dir = &#039;&#039;\n#ssl_key_file = &#039;server.key&#039;\n#ssl_ciphers = &#039;HIGH:MEDIUM:+3DES:!aNULL&#039; # allowed SSL ciphers\n#ssl_prefer_server_ciphers = on\n#ssl_ecdh_curve = &#039;prime256v1&#039;\n#ssl_min_protocol_version = &#039;TLSv1.2&#039;\n#ssl_max_protocol_version = &#039;&#039;\n#ssl_dh_params_file = &#039;&#039;\n#ssl_passphrase_command = &#039;&#039;\n#ssl_passphrase_command_supports_reload = off\n\n\n#------------------------------------------------------------------------------\n# RESOURCE USAGE (except WAL)\n#------------------------------------------------------------------------------\n\n# - Memory -\n\nshared_buffers = 128MB\t\t\t# min 128kB\n\t\t\t\t\t# (change requires restart)\n#huge_pages = try\t\t\t# on, off, or try\n\t\t\t\t\t# (change requires restart)\n#huge_page_size = 0\t\t\t# zero for system default\n\t\t\t\t\t# (change requires restart)\n#temp_buffers = 8MB\t\t\t# min 800kB\n#max_prepared_transactions = 0\t\t# zero disables the feature\n\t\t\t\t\t# (change requires restart)\n# Caution: it is not advisable to set max_prepared_transactions nonzero unless\n# you actively intend to use prepared transactions.\n#work_mem = 4MB\t\t\t\t# min 64kB\n#hash_mem_multiplier = 1.0\t\t# 1-1000.0 multiplier on hash table work_mem\n#maintenance_work_mem = 64MB\t\t# min 1MB\n#autovacuum_work_mem = -1\t\t# min 1MB, or -1 to use maintenance_work_mem\n#logical_decoding_work_mem = 64MB\t# min 64kB\n#max_stack_depth = 2MB\t\t\t# min 100kB\n#shared_memory_type = mmap\t\t# the default is the first option\n\t\t\t\t\t# supported by the operating system:\n\t\t\t\t\t#   mmap\n\t\t\t\t\t#   sysv\n\t\t\t\t\t#   windows\n\t\t\t\t\t# (change requires restart)\ndynamic_shared_memory_type = posix\t# the default is the first option\n\t\t\t\t\t# supported by the operating system:\n\t\t\t\t\t#   posix\n\t\t\t\t\t#   sysv\n\t\t\t\t\t#   windows\n\t\t\t\t\t#   mmap\n\t\t\t\t\t# (change requires restart)\n#min_dynamic_shared_memory = 0MB\t# (change requires restart)\n\n# - Disk -\n\n#temp_file_limit = -1\t\t\t# limits per-process temp file space\n\t\t\t\t\t# in kilobytes, or -1 for no limit\n\n# - Kernel Resources -\n\n#max_files_per_process = 1000\t\t# min 64\n\t\t\t\t\t# (change requires restart)\n\n# - Cost-Based Vacuum Delay -\n\n#vacuum_cost_delay = 0\t\t\t# 0-100 milliseconds (0 disables)\n#vacuum_cost_page_hit = 1\t\t# 0-10000 credits\n#vacuum_cost_page_miss = 2\t\t# 0-10000 credits\n#vacuum_cost_page_dirty = 20\t\t# 0-10000 credits\n#vacuum_cost_limit = 200\t\t# 1-10000 credits\n\n# - Background Writer -\n\n#bgwriter_delay = 200ms\t\t\t# 10-10000ms between rounds\n#bgwriter_lru_maxpages = 100\t\t# max buffers written\/round, 0 disables\n#bgwriter_lru_multiplier = 2.0\t\t# 0-10.0 multiplier on buffers scanned\/round\n#bgwriter_flush_after = 512kB\t\t# measured in pages, 0 disables\n\n# - Asynchronous Behavior -\n\n#backend_flush_after = 0\t\t# measured in pages, 0 disables\n#effective_io_concurrency = 1\t\t# 1-1000; 0 disables prefetching\n#maintenance_io_concurrency = 10\t# 1-1000; 0 disables prefetching\n#max_worker_processes = 8\t\t# (change requires restart)\n#max_parallel_workers_per_gather = 2\t# taken from max_parallel_workers\n#max_parallel_maintenance_workers = 2\t# taken from max_parallel_workers\n#max_parallel_workers = 8\t\t# maximum number of max_worker_processes that\n\t\t\t\t\t# can be used in parallel operations\n#parallel_leader_participation = on\n#old_snapshot_threshold = -1\t\t# 1min-60d; -1 disables; 0 is immediate\n\t\t\t\t\t# (change requires restart)\n\n\n#------------------------------------------------------------------------------\n# WRITE-AHEAD LOG\n#------------------------------------------------------------------------------\n\n# - Settings -\n\n#wal_level = replica\t\t\t# minimal, replica, or logical\n\t\t\t\t\t# (change requires restart)\n#fsync = on\t\t\t\t# flush data to disk for crash safety\n\t\t\t\t\t# (turning this off can cause\n\t\t\t\t\t# unrecoverable data corruption)\n#synchronous_commit = on\t\t# synchronization level;\n\t\t\t\t\t# off, local, remote_write, remote_apply, or on\n#wal_sync_method = fsync\t\t# the default is the first option\n\t\t\t\t\t# supported by the operating system:\n\t\t\t\t\t#   open_datasync\n\t\t\t\t\t#   fdatasync (default on Linux and FreeBSD)\n\t\t\t\t\t#   fsync\n\t\t\t\t\t#   fsync_writethrough\n\t\t\t\t\t#   open_sync\n#full_page_writes = on\t\t\t# recover from partial page writes\n#wal_log_hints = off\t\t\t# also do full page writes of non-critical updates\n\t\t\t\t\t# (change requires restart)\n#wal_compression = off\t\t\t# enable compression of full-page writes\n#wal_init_zero = on\t\t\t# zero-fill new WAL files\n#wal_recycle = on\t\t\t# recycle WAL files\n#wal_buffers = -1\t\t\t# min 32kB, -1 sets based on shared_buffers\n\t\t\t\t\t# (change requires restart)\n#wal_writer_delay = 200ms\t\t# 1-10000 milliseconds\n#wal_writer_flush_after = 1MB\t\t# measured in pages, 0 disables\n#wal_skip_threshold = 2MB\n\n#commit_delay = 0\t\t\t# range 0-100000, in microseconds\n#commit_siblings = 5\t\t\t# range 1-1000\n\n# - Checkpoints -\n\n#checkpoint_timeout = 5min\t\t# range 30s-1d\n#checkpoint_completion_target = 0.9\t# checkpoint target duration, 0.0 - 1.0\n#checkpoint_flush_after = 256kB\t\t# measured in pages, 0 disables\n#checkpoint_warning = 30s\t\t# 0 disables\nmax_wal_size = 1GB\nmin_wal_size = 80MB\n\n# - Archiving -\n\n#archive_mode = off\t\t# enables archiving; off, on, or always\n\t\t\t\t# (change requires restart)\n#archive_command = &#039;&#039;\t\t# command to use to archive a logfile segment\n\t\t\t\t# placeholders: %p = path of file to archive\n\t\t\t\t#               %f = file name only\n\t\t\t\t# e.g. &#039;test ! -f \/mnt\/server\/archivedir\/%f &amp;amp;&amp;amp; cp %p \/mnt\/server\/archivedir\/%f&#039;\n#archive_timeout = 0\t\t# force a logfile segment switch after this\n\t\t\t\t# number of seconds; 0 disables\n\n# - Archive Recovery -\n\n# These are only used in recovery mode.\n\n#restore_command = &#039;&#039;\t\t# command to use to restore an archived logfile segment\n\t\t\t\t# placeholders: %p = path of file to restore\n\t\t\t\t#               %f = file name only\n\t\t\t\t# e.g. &#039;cp \/mnt\/server\/archivedir\/%f %p&#039;\n#archive_cleanup_command = &#039;&#039;\t# command to execute at every restartpoint\n#recovery_end_command = &#039;&#039;\t# command to execute at completion of recovery\n\n# - Recovery Target -\n\n# Set these only when performing a targeted recovery.\n\n#recovery_target = &#039;&#039;\t\t# &#039;immediate&#039; to end recovery as soon as a\n                                # consistent state is reached\n\t\t\t\t# (change requires restart)\n#recovery_target_name = &#039;&#039;\t# the named restore point to which recovery will proceed\n\t\t\t\t# (change requires restart)\n#recovery_target_time = &#039;&#039;\t# the time stamp up to which recovery will proceed\n\t\t\t\t# (change requires restart)\n#recovery_target_xid = &#039;&#039;\t# the transaction ID up to which recovery will proceed\n\t\t\t\t# (change requires restart)\n#recovery_target_lsn = &#039;&#039;\t# the WAL LSN up to which recovery will proceed\n\t\t\t\t# (change requires restart)\n#recovery_target_inclusive = on # Specifies whether to stop:\n\t\t\t\t# just after the specified recovery target (on)\n\t\t\t\t# just before the recovery target (off)\n\t\t\t\t# (change requires restart)\n#recovery_target_timeline = &#039;latest&#039;\t# &#039;current&#039;, &#039;latest&#039;, or timeline ID\n\t\t\t\t# (change requires restart)\n#recovery_target_action = &#039;pause&#039;\t# &#039;pause&#039;, &#039;promote&#039;, &#039;shutdown&#039;\n\t\t\t\t# (change requires restart)\n\n\n#------------------------------------------------------------------------------\n# REPLICATION\n#------------------------------------------------------------------------------\n\n# - Sending Servers -\n\n# Set these on the primary and on any standby that will send replication data.\n\n#max_wal_senders = 10\t\t# max number of walsender processes\n\t\t\t\t# (change requires restart)\n#max_replication_slots = 10\t# max number of replication slots\n\t\t\t\t# (change requires restart)\n#wal_keep_size = 0\t\t# in megabytes; 0 disables\n#max_slot_wal_keep_size = -1\t# in megabytes; -1 disables\n#wal_sender_timeout = 60s\t# in milliseconds; 0 disables\n#track_commit_timestamp = off\t# collect timestamp of transaction commit\n\t\t\t\t# (change requires restart)\n\n# - Primary Server -\n\n# These settings are ignored on a standby server.\n\n#synchronous_standby_names = &#039;&#039;\t# standby servers that provide sync rep\n\t\t\t\t# method to choose sync standbys, number of sync standbys,\n\t\t\t\t# and comma-separated list of application_name\n\t\t\t\t# from standby(s); &#039;*&#039; = all\n#vacuum_defer_cleanup_age = 0\t# number of xacts by which cleanup is delayed\n\n# - Standby Servers -\n\n# These settings are ignored on a primary server.\n\n#primary_conninfo = &#039;&#039;\t\t\t# connection string to sending server\n#primary_slot_name = &#039;&#039;\t\t\t# replication slot on sending server\n#promote_trigger_file = &#039;&#039;\t\t# file name whose presence ends recovery\n#hot_standby = on\t\t\t# &quot;off&quot; disallows queries during recovery\n\t\t\t\t\t# (change requires restart)\n#max_standby_archive_delay = 30s\t# max delay before canceling queries\n\t\t\t\t\t# when reading WAL from archive;\n\t\t\t\t\t# -1 allows indefinite delay\n#max_standby_streaming_delay = 30s\t# max delay before canceling queries\n\t\t\t\t\t# when reading streaming WAL;\n\t\t\t\t\t# -1 allows indefinite delay\n#wal_receiver_create_temp_slot = off\t# create temp slot if primary_slot_name\n\t\t\t\t\t# is not set\n#wal_receiver_status_interval = 10s\t# send replies at least this often\n\t\t\t\t\t# 0 disables\n#hot_standby_feedback = off\t\t# send info from standby to prevent\n\t\t\t\t\t# query conflicts\n#wal_receiver_timeout = 60s\t\t# time that receiver waits for\n\t\t\t\t\t# communication from primary\n\t\t\t\t\t# in milliseconds; 0 disables\n#wal_retrieve_retry_interval = 5s\t# time to wait before retrying to\n\t\t\t\t\t# retrieve WAL after a failed attempt\n#recovery_min_apply_delay = 0\t\t# minimum delay for applying changes during recovery\n\n# - Subscribers -\n\n# These settings are ignored on a publisher.\n\n#max_logical_replication_workers = 4\t# taken from max_worker_processes\n\t\t\t\t\t# (change requires restart)\n#max_sync_workers_per_subscription = 2\t# taken from max_logical_replication_workers\n\n\n#------------------------------------------------------------------------------\n# QUERY TUNING\n#------------------------------------------------------------------------------\n\n# - Planner Method Configuration -\n\n#enable_async_append = on\n#enable_bitmapscan = on\n#enable_gathermerge = on\n#enable_hashagg = on\n#enable_hashjoin = on\n#enable_incremental_sort = on\n#enable_indexscan = on\n#enable_indexonlyscan = on\n#enable_material = on\n#enable_memoize = on\n#enable_mergejoin = on\n#enable_nestloop = on\n#enable_parallel_append = on\n#enable_parallel_hash = on\n#enable_partition_pruning = on\n#enable_partitionwise_join = off\n#enable_partitionwise_aggregate = off\n#enable_seqscan = on\n#enable_sort = on\n#enable_tidscan = on\n\n# - Planner Cost Constants -\n\n#seq_page_cost = 1.0\t\t\t# measured on an arbitrary scale\n#random_page_cost = 4.0\t\t\t# same scale as above\n#cpu_tuple_cost = 0.01\t\t\t# same scale as above\n#cpu_index_tuple_cost = 0.005\t\t# same scale as above\n#cpu_operator_cost = 0.0025\t\t# same scale as above\n#parallel_setup_cost = 1000.0\t# same scale as above\n#parallel_tuple_cost = 0.1\t\t# same scale as above\n#min_parallel_table_scan_size = 8MB\n#min_parallel_index_scan_size = 512kB\n#effective_cache_size = 4GB\n\n#jit_above_cost = 100000\t\t# perform JIT compilation if available\n\t\t\t\t\t# and query more expensive than this;\n\t\t\t\t\t# -1 disables\n#jit_inline_above_cost = 500000\t\t# inline small functions if query is\n\t\t\t\t\t# more expensive than this; -1 disables\n#jit_optimize_above_cost = 500000\t# use expensive JIT optimizations if\n\t\t\t\t\t# query is more expensive than this;\n\t\t\t\t\t# -1 disables\n\n# - Genetic Query Optimizer -\n\n#geqo = on\n#geqo_threshold = 12\n#geqo_effort = 5\t\t\t# range 1-10\n#geqo_pool_size = 0\t\t\t# selects default based on effort\n#geqo_generations = 0\t\t\t# selects default based on effort\n#geqo_selection_bias = 2.0\t\t# range 1.5-2.0\n#geqo_seed = 0.0\t\t\t# range 0.0-1.0\n\n# - Other Planner Options -\n\n#default_statistics_target = 100\t# range 1-10000\n#constraint_exclusion = partition\t# on, off, or partition\n#cursor_tuple_fraction = 0.1\t\t# range 0.0-1.0\n#from_collapse_limit = 8\n#jit = on\t\t\t\t# allow JIT compilation\n#join_collapse_limit = 8\t\t# 1 disables collapsing of explicit\n\t\t\t\t\t# JOIN clauses\n#plan_cache_mode = auto\t\t\t# auto, force_generic_plan or\n\t\t\t\t\t# force_custom_plan\n\n\n#------------------------------------------------------------------------------\n# REPORTING AND LOGGING\n#------------------------------------------------------------------------------\n\n# - Where to Log -\n\n#log_destination = &#039;stderr&#039;\t\t# Valid values are combinations of\n\t\t\t\t\t# stderr, csvlog, syslog, and eventlog,\n\t\t\t\t\t# depending on platform.  csvlog\n\t\t\t\t\t# requires logging_collector to be on.\n\n# This is used when logging to stderr:\n########## 20231029_\u5909\u66f4\u3002########################################\n#logging_collector = off\t\t# Enable capturing of stderr and csvlog\nlogging_collector = on\n\t\t\t\t\t# into log files. Required to be on for\n\t\t\t\t\t# csvlogs.\n\t\t\t\t\t# (change requires restart)\n\n# These are only used if logging_collector is on:\n#log_directory = &#039;log&#039;\t\t\t# directory where log files are written,\n\t\t\t\t\t# can be absolute or relative to PGDATA\n#log_filename = &#039;postgresql-%Y-%m-%d_%H%M%S.log&#039;\t# log file name pattern,\n\t\t\t\t\t# can include strftime() escapes\n########## 20231029_\u5909\u66f4\u3002########################################\n#log_file_mode = 0600\t\t\t# creation mode for log files,\nlog_file_mode = 0777\n\t\t\t\t\t# begin with 0 to use octal notation\n#log_rotation_age = 1d\t\t\t# Automatic rotation of logfiles will\n\t\t\t\t\t# happen after that time.  0 disables.\n#log_rotation_size = 10MB\t\t# Automatic rotation of logfiles will\n\t\t\t\t\t# happen after that much log output.\n\t\t\t\t\t# 0 disables.\n#log_truncate_on_rotation = off\t\t# If on, an existing log file with the\n\t\t\t\t\t# same name as the new log file will be\n\t\t\t\t\t# truncated rather than appended to.\n\t\t\t\t\t# But such truncation only occurs on\n\t\t\t\t\t# time-driven rotation, not on restarts\n\t\t\t\t\t# or size-driven rotation.  Default is\n\t\t\t\t\t# off, meaning append to existing files\n\t\t\t\t\t# in all cases.\n\n# These are relevant when logging to syslog:\n#syslog_facility = &#039;LOCAL0&#039;\n#syslog_ident = &#039;postgres&#039;\n#syslog_sequence_numbers = on\n#syslog_split_messages = on\n\n# This is only relevant when logging to eventlog (Windows):\n# (change requires restart)\n#event_source = &#039;PostgreSQL&#039;\n\n# - When to Log -\n########## 20231029_\u5909\u66f4\u3002########################################\n#log_min_messages = warning\t\t# values in order of decreasing detail:\nlog_min_messages = debug5\n\t\t\t\t\t#   debug5\n\t\t\t\t\t#   debug4\n\t\t\t\t\t#   debug3\n\t\t\t\t\t#   debug2\n\t\t\t\t\t#   debug1\n\t\t\t\t\t#   info\n\t\t\t\t\t#   notice\n\t\t\t\t\t#   warning\n\t\t\t\t\t#   error\n\t\t\t\t\t#   log\n\t\t\t\t\t#   fatal\n\t\t\t\t\t#   panic\n\n#log_min_error_statement = error\t# values in order of decreasing detail:\n\t\t\t\t\t#   debug5\n\t\t\t\t\t#   debug4\n\t\t\t\t\t#   debug3\n\t\t\t\t\t#   debug2\n\t\t\t\t\t#   debug1\n\t\t\t\t\t#   info\n\t\t\t\t\t#   notice\n\t\t\t\t\t#   warning\n\t\t\t\t\t#   error\n\t\t\t\t\t#   log\n\t\t\t\t\t#   fatal\n\t\t\t\t\t#   panic (effectively off)\n\n#log_min_duration_statement = -1\t# -1 is disabled, 0 logs all statements\n\t\t\t\t\t# and their durations, &gt; 0 logs only\n\t\t\t\t\t# statements running at least this number\n\t\t\t\t\t# of milliseconds\n\n#log_min_duration_sample = -1\t\t# -1 is disabled, 0 logs a sample of statements\n\t\t\t\t\t# and their durations, &gt; 0 logs only a sample of\n\t\t\t\t\t# statements running at least this number\n\t\t\t\t\t# of milliseconds;\n\t\t\t\t\t# sample fraction is determined by log_statement_sample_rate\n\n#log_statement_sample_rate = 1.0\t# fraction of logged statements exceeding\n\t\t\t\t\t# log_min_duration_sample to be logged;\n\t\t\t\t\t# 1.0 logs all such statements, 0.0 never logs\n\n\n#log_transaction_sample_rate = 0.0\t# fraction of transactions whose statements\n\t\t\t\t\t# are logged regardless of their duration; 1.0 logs all\n\t\t\t\t\t# statements from all transactions, 0.0 never logs\n\n# - What to Log -\n\n#debug_print_parse = off\n#debug_print_rewritten = off\n#debug_print_plan = off\n#debug_pretty_print = on\n#log_autovacuum_min_duration = -1\t# log autovacuum activity;\n\t\t\t\t\t# -1 disables, 0 logs all actions and\n\t\t\t\t\t# their durations, &gt; 0 logs only\n\t\t\t\t\t# actions running at least this number\n\t\t\t\t\t# of milliseconds.\n#log_checkpoints = off\n#log_connections = off\n#log_disconnections = off\n#log_duration = off\n#log_error_verbosity = default\t\t# terse, default, or verbose messages\n#log_hostname = off\n########## 20231029_\u5909\u66f4\u3002########################################\n#log_line_prefix = &#039;%m &#x5B;%p] &#039;\t\t# special values:\nlog_line_prefix = &#039;%t &#x5B;DatabaseName:%d] &#x5B;UserName:%u] &#039;\n\t\t\t\t\t#   %a = application name\n\t\t\t\t\t#   %u = user name\n\t\t\t\t\t#   %d = database name\n\t\t\t\t\t#   %r = remote host and port\n\t\t\t\t\t#   %h = remote host\n\t\t\t\t\t#   %b = backend type\n\t\t\t\t\t#   %p = process ID\n\t\t\t\t\t#   %P = process ID of parallel group leader\n\t\t\t\t\t#   %t = timestamp without milliseconds\n\t\t\t\t\t#   %m = timestamp with milliseconds\n\t\t\t\t\t#   %n = timestamp with milliseconds (as a Unix epoch)\n\t\t\t\t\t#   %Q = query ID (0 if none or not computed)\n\t\t\t\t\t#   %i = command tag\n\t\t\t\t\t#   %e = SQL state\n\t\t\t\t\t#   %c = session ID\n\t\t\t\t\t#   %l = session line number\n\t\t\t\t\t#   %s = session start timestamp\n\t\t\t\t\t#   %v = virtual transaction ID\n\t\t\t\t\t#   %x = transaction ID (0 if none)\n\t\t\t\t\t#   %q = stop here in non-session\n\t\t\t\t\t#        processes\n\t\t\t\t\t#   %% = &#039;%&#039;\n\t\t\t\t\t# e.g. &#039;&amp;lt;%u%%%d&gt; &#039;\n#log_lock_waits = off\t\t\t# log lock waits &gt;= deadlock_timeout\n#log_recovery_conflict_waits = off\t# log standby recovery conflict waits\n\t\t\t\t\t# &gt;= deadlock_timeout\n#log_parameter_max_length = -1\t\t# when logging statements, limit logged\n\t\t\t\t\t# bind-parameter values to N bytes;\n\t\t\t\t\t# -1 means print in full, 0 disables\n#log_parameter_max_length_on_error = 0\t# when logging an error, limit logged\n\t\t\t\t\t# bind-parameter values to N bytes;\n\t\t\t\t\t# -1 means print in full, 0 disables\n#log_statement = &#039;none&#039;\t\t\t# none, ddl, mod, all\n#log_replication_commands = off\n#log_temp_files = -1\t\t\t# log temporary files equal or larger\n\t\t\t\t\t# than the specified size in kilobytes;\n\t\t\t\t\t# -1 disables, 0 logs all temp files\n########## 20231029_\u5909\u66f4\u3002########################################\nlog_timezone = &#039;Asia\/Tokyo&#039;\n\n\n#------------------------------------------------------------------------------\n# PROCESS TITLE\n#------------------------------------------------------------------------------\n\n#cluster_name = &#039;&#039;\t\t\t# added to process titles if nonempty\n\t\t\t\t\t# (change requires restart)\n#update_process_title = on\n\n\n#------------------------------------------------------------------------------\n# STATISTICS\n#------------------------------------------------------------------------------\n\n# - Query and Index Statistics Collector -\n\n#track_activities = on\n#track_activity_query_size = 1024\t# (change requires restart)\n#track_counts = on\n#track_io_timing = off\n#track_wal_io_timing = off\n#track_functions = none\t\t\t# none, pl, all\n#stats_temp_directory = &#039;pg_stat_tmp&#039;\n\n\n# - Monitoring -\n\n#compute_query_id = auto\n#log_statement_stats = off\n#log_parser_stats = off\n#log_planner_stats = off\n#log_executor_stats = off\n\n\n#------------------------------------------------------------------------------\n# AUTOVACUUM\n#------------------------------------------------------------------------------\n\n#autovacuum = on\t\t\t# Enable autovacuum subprocess?  &#039;on&#039;\n\t\t\t\t\t# requires track_counts to also be on.\n#autovacuum_max_workers = 3\t\t# max number of autovacuum subprocesses\n\t\t\t\t\t# (change requires restart)\n#autovacuum_naptime = 1min\t\t# time between autovacuum runs\n#autovacuum_vacuum_threshold = 50\t# min number of row updates before\n\t\t\t\t\t# vacuum\n#autovacuum_vacuum_insert_threshold = 1000\t# min number of row inserts\n\t\t\t\t\t# before vacuum; -1 disables insert\n\t\t\t\t\t# vacuums\n#autovacuum_analyze_threshold = 50\t# min number of row updates before\n\t\t\t\t\t# analyze\n#autovacuum_vacuum_scale_factor = 0.2\t# fraction of table size before vacuum\n#autovacuum_vacuum_insert_scale_factor = 0.2\t# fraction of inserts over table\n\t\t\t\t\t# size before insert vacuum\n#autovacuum_analyze_scale_factor = 0.1\t# fraction of table size before analyze\n#autovacuum_freeze_max_age = 200000000\t# maximum XID age before forced vacuum\n\t\t\t\t\t# (change requires restart)\n#autovacuum_multixact_freeze_max_age = 400000000\t# maximum multixact age\n\t\t\t\t\t# before forced vacuum\n\t\t\t\t\t# (change requires restart)\n#autovacuum_vacuum_cost_delay = 2ms\t# default vacuum cost delay for\n\t\t\t\t\t# autovacuum, in milliseconds;\n\t\t\t\t\t# -1 means use vacuum_cost_delay\n#autovacuum_vacuum_cost_limit = -1\t# default vacuum cost limit for\n\t\t\t\t\t# autovacuum, -1 means use\n\t\t\t\t\t# vacuum_cost_limit\n\n\n#------------------------------------------------------------------------------\n# CLIENT CONNECTION DEFAULTS\n#------------------------------------------------------------------------------\n\n# - Statement Behavior -\n\n#client_min_messages = notice\t\t# values in order of decreasing detail:\n\t\t\t\t\t#   debug5\n\t\t\t\t\t#   debug4\n\t\t\t\t\t#   debug3\n\t\t\t\t\t#   debug2\n\t\t\t\t\t#   debug1\n\t\t\t\t\t#   log\n\t\t\t\t\t#   notice\n\t\t\t\t\t#   warning\n\t\t\t\t\t#   error\n#search_path = &#039;&quot;$user&quot;, public&#039;\t# schema names\n#row_security = on\n#default_table_access_method = &#039;heap&#039;\n#default_tablespace = &#039;&#039;\t\t# a tablespace name, &#039;&#039; uses the default\n#default_toast_compression = &#039;pglz&#039;\t# &#039;pglz&#039; or &#039;lz4&#039;\n#temp_tablespaces = &#039;&#039;\t\t\t# a list of tablespace names, &#039;&#039; uses\n\t\t\t\t\t# only default tablespace\n#check_function_bodies = on\n#default_transaction_isolation = &#039;read committed&#039;\n#default_transaction_read_only = off\n#default_transaction_deferrable = off\n#session_replication_role = &#039;origin&#039;\n#statement_timeout = 0\t\t\t# in milliseconds, 0 is disabled\n#lock_timeout = 0\t\t\t# in milliseconds, 0 is disabled\n#idle_in_transaction_session_timeout = 0\t# in milliseconds, 0 is disabled\n#idle_session_timeout = 0\t\t# in milliseconds, 0 is disabled\n#vacuum_freeze_table_age = 150000000\n#vacuum_freeze_min_age = 50000000\n#vacuum_failsafe_age = 1600000000\n#vacuum_multixact_freeze_table_age = 150000000\n#vacuum_multixact_freeze_min_age = 5000000\n#vacuum_multixact_failsafe_age = 1600000000\n#bytea_output = &#039;hex&#039;\t\t\t# hex, escape\n#xmlbinary = &#039;base64&#039;\n#xmloption = &#039;content&#039;\n#gin_pending_list_limit = 4MB\n\n# - Locale and Formatting -\n\ndatestyle = &#039;iso, mdy&#039;\n#intervalstyle = &#039;postgres&#039;\n########## 20231029_\u5909\u66f4\u3002########################################\ntimezone = &#039;Asia\/Tokyo&#039;\n#timezone_abbreviations = &#039;Default&#039;     # Select the set of available time zone\n\t\t\t\t\t# abbreviations.  Currently, there are\n\t\t\t\t\t#   Default\n\t\t\t\t\t#   Australia (historical usage)\n\t\t\t\t\t#   India\n\t\t\t\t\t# You can create your own file in\n\t\t\t\t\t# share\/timezonesets\/.\n#extra_float_digits = 1\t\t\t# min -15, max 3; any value &gt;0 actually\n\t\t\t\t\t# selects precise output mode\n########## 20231029_\u5909\u66f4\u3002########################################\n#client_encoding = sql_ascii\t\t# actually, defaults to database\n\t\t\t\t\t# encoding\nclient_encoding = UTF8\n\n# These settings are initialized by initdb, but they can be changed.\nlc_messages = &#039;en_US.utf8&#039;\t\t\t# locale for system error message\n\t\t\t\t\t# strings\nlc_monetary = &#039;en_US.utf8&#039;\t\t\t# locale for monetary formatting\nlc_numeric = &#039;en_US.utf8&#039;\t\t\t# locale for number formatting\nlc_time = &#039;en_US.utf8&#039;\t\t\t\t# locale for time formatting\n\n# default configuration for text search\ndefault_text_search_config = &#039;pg_catalog.english&#039;\n\n# - Shared Library Preloading -\n\n#local_preload_libraries = &#039;&#039;\n#session_preload_libraries = &#039;&#039;\n#shared_preload_libraries = &#039;&#039;\t# (change requires restart)\n#jit_provider = &#039;llvmjit&#039;\t\t# JIT library to use\n\n# - Other Defaults -\n\n#dynamic_library_path = &#039;$libdir&#039;\n#extension_destdir = &#039;&#039;\t\t\t# prepend path when loading extensions\n\t\t\t\t\t# and shared objects (added by Debian)\n#gin_fuzzy_search_limit = 0\n\n\n#------------------------------------------------------------------------------\n# LOCK MANAGEMENT\n#------------------------------------------------------------------------------\n\n#deadlock_timeout = 1s\n#max_locks_per_transaction = 64\t\t# min 10\n\t\t\t\t\t# (change requires restart)\n#max_pred_locks_per_transaction = 64\t# min 10\n\t\t\t\t\t# (change requires restart)\n#max_pred_locks_per_relation = -2\t# negative values mean\n\t\t\t\t\t# (max_pred_locks_per_transaction\n\t\t\t\t\t#  \/ -max_pred_locks_per_relation) - 1\n#max_pred_locks_per_page = 2            # min 0\n\n\n#------------------------------------------------------------------------------\n# VERSION AND PLATFORM COMPATIBILITY\n#------------------------------------------------------------------------------\n\n# - Previous PostgreSQL Versions -\n\n#array_nulls = on\n#backslash_quote = safe_encoding\t# on, off, or safe_encoding\n#escape_string_warning = on\n#lo_compat_privileges = off\n#quote_all_identifiers = off\n#standard_conforming_strings = on\n#synchronize_seqscans = on\n\n# - Other Platforms and Clients -\n\n#transform_null_equals = off\n\n\n#------------------------------------------------------------------------------\n# ERROR HANDLING\n#------------------------------------------------------------------------------\n\n#exit_on_error = off\t\t\t# terminate session on any error?\n#restart_after_crash = on\t\t# reinitialize after backend crash?\n#data_sync_retry = off\t\t\t# retry or panic on failure to fsync\n\t\t\t\t\t# data?\n\t\t\t\t\t# (change requires restart)\n#recovery_init_sync_method = fsync\t# fsync, syncfs (Linux 5.8+)\n\n\n#------------------------------------------------------------------------------\n# CONFIG FILE INCLUDES\n#------------------------------------------------------------------------------\n\n# These options allow settings to be loaded from files other than the\n# default postgresql.conf.  Note that these are directives, not variable\n# assignments, so they can usefully be given more than once.\n\n#include_dir = &#039;...&#039;\t\t\t# include files ending in &#039;.conf&#039; from\n\t\t\t\t\t# a directory, e.g., &#039;conf.d&#039;\n#include_if_exists = &#039;...&#039;\t\t# include file only if it exists\n#include = &#039;...&#039;\t\t\t# include file\n\n\n#------------------------------------------------------------------------------\n# CUSTOMIZED OPTIONS\n#------------------------------------------------------------------------------\n\n# Add settings for extensions here\n\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981 Laravel\u3060\u3051\u30671\u3064\u306e\u30b3\u30f3\u30c6\u30ca\u3001PostgreSQL\u3060\u3051\u30671\u3064\u306e\u30b3\u30f3\u30c6\u30ca\u3001\u5408\u8a082\u500b\u306e\u30b3\u30f3\u30c6\u30ca\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002 \u76ee\u6a19\u3068\u3057\u3066\u306fLaravel\u304b\u3089PostgreSQL\u3078\u30de\u30a4\u30b0\u30ec\u30fc\u30c8\u304c\u3067\u304d\u308b\u3053\u3068\u3002 \u624b\u9806 \u6e96\u5099\u3059\u308b\u30d5\u30a1\u30a4 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97,96],"tags":[98,88,57],"class_list":["post-995","post","type-post","status-publish","format-standard","hentry","category-docker","category-laravel","tag-docker","tag-laravel","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=995"}],"version-history":[{"count":14,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/995\/revisions"}],"predecessor-version":[{"id":1090,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/995\/revisions\/1090"}],"wp:attachment":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}