Mac で
しばらく
エラー内容
v9.4.1 から
pg_upgrade -v -d /usr/local/var/postgres9.4 -D /usr/local/var/postgres -b /usr/local/Cellar/postgresql/9.4.1/bin/ -B /usr/local/Cellar/postgresql/9.5.2/bin/
途中まではうまくconnection to database failed: fe_sendauth: no password supplied
で
------------------Running in verbose mode Performing Consistency Checks ----------------------------- Checking cluster versions ok Current pg_control values: pg_control version number: 942 Catalog version number: 201409291-------------------------- ........................ ........................ Values to be changed: First log segment after reset: 000000010000000000000002 "/usr/local/Cellar/postgresql/9.4.1/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/usr/local/var/postgres9.4" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/usr/local/Cellar/postgresql/9.4.1'" start >> "pg_upgrade_server.log" 2>&1 connection to database failed: fe_sendauth: no password supplied
原因
認証関連で
pg_upgrade 実施時は、
対処方法
pg_hba.conf ファイルの
/usr/local/var/postgres9.4/pg_hba.conf
# "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
/usr/local/var/postgres/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust # Allow replication connections from localhost, by a user with the
これで
以上です。
コメント