On 11/13/18 3:47 PM, Rich Shepard wrote:
On Sun, 11 Nov 2018, Rich Shepard wrote:
Looks like the pg_dumpall '-h' option will act on the other host's data
directory.
Worked as advertised. Just read the dumped file into the new 11.1 data
directory.
The new installation is asking for my password to access my databases.
Where do I turn this off?
You have two options:
1) The preferred one. Keep the password and create a .pgpass file to
hold the password:
https://www.postgresql.org/docs/10/libpq-pgpass.html
My guess is you had one on the other machine.
2) Change your auth method in pg_hba.conf:
https://www.postgresql.org/docs/10/client-authentication.html
Rich
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
