From 3f09bb8d27d509c25e4cbeef92ad454582579851 Mon Sep 17 00:00:00 2001 From: Noah Misch Date: Fri, 18 Jul 2014 16:05:17 -0400 Subject: [PATCH] Limit pg_upgrade authentication advice to always-secure techniques. ~/.pgpass is a sound choice everywhere, and "peer" authentication is safe on every platform it supports. Cease to recommend "trust" authentication, the safety of which is deeply configuration-specific. Back-patch to 9.0, where pg_upgrade was introduced. --- doc/src/sgml/pgupgrade.sgml | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/pgupgrade.sgml b/doc/src/sgml/pgupgrade.sgml index 6012523dbc..9a670d38c0 100644 --- a/doc/src/sgml/pgupgrade.sgml +++ b/doc/src/sgml/pgupgrade.sgml @@ -252,10 +252,9 @@ gmake prefix=/usr/local/pgsql.new install Adjust authentication - pg_upgrade will connect to the old and new servers several times, - so you might want to set authentication to trust - or peer in pg_hba.conf, or if using - md5 authentication, use a ~/.pgpass file + pg_upgrade will connect to the old and new servers several + times, so you might want to set authentication to peer + in pg_hba.conf or use a ~/.pgpass file (see ). @@ -355,8 +354,7 @@ pg_upgrade.exe Restore <filename>pg_hba.conf</> - If you modified pg_hba.conf to use trust, - restore its original authentication settings. + If you modified pg_hba.conf, restore its original settings. -- 2.50.0