| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Move cluster to new host, upgraded version |
| Date: | 2018-11-14 00:24:40 |
| Message-ID: | alpine.LNX.2.20.1811131613140.19445@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 13 Nov 2018, Adrian Klaver wrote:
> 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
Adrian,
That's database-specific if I read the manual page correctly.
> My guess is you had one on the other machine.
Nope. I've been running postgres since 1997 and never used a password
since I'm the only one using the databases.
> 2) Change your auth method in pg_hba.conf:
> https://www.postgresql.org/docs/10/client-authentication.html
/var/lib/pgsql/11/data/pg_hba.conf has trust as the local authentication
method for all databases. Perhaps I need to restart the server after loading
the databases. Will try that.
Thanks,
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-11-14 00:38:07 | Re: Move cluster to new host, upgraded version |
| Previous Message | Tom Lane | 2018-11-14 00:00:16 | Re: TOAST : partial detoasting : only a small part of a toasted value (for pgpointcloud) |