Re: Move cluster to new host, upgraded version

On 11/13/18 4:41 PM, Rich Shepard wrote:
> On Tue, 13 Nov 2018, Adrian Klaver wrote:
> 
>> No:
>> " Each of the first four fields can be a literal value, or *, which 
>> matches anything. "
> 
> Adrian,
> 
>    Okay.
> 
>> If the record starts with local then that is for socket connections.
>> If you are connecting to a host e.g -h localhost then you need to look 
>> at the host records.
> 
>    I'm connecting from the same host on which the server is installed. I've
> always used 'psql <database_name>' and been connected. The new desktop's

Please show complete connection command.

> pg_hba.conf is identical to the old desktop's pg_hba.conf, but only the new
> one is now asking for a password. Permissions on both are the same.

Can you show us the new pg_hba.conf?

> 
> Thanks,
> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com