Re: [GENERAL] pg_hba.conf broken after cluster upgrade

2013-10-16 Thread Adrian Klaver
On 10/16/2013 05:03 PM, John R Pierce wrote: On 10/16/2013 4:56 PM, Adrian Klaver wrote: I have never seen this in a pg_hba,conf. Of course I don't get out much:) Not sure of its purpose. It seems to be in the place of the IP mask. i think thats an email program artifact,

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

2013-10-16 Thread John R Pierce
On 10/16/2013 4:56 PM, Adrian Klaver wrote: I have never seen this in a pg_hba,conf. Of course I don't get out much:) Not sure of its purpose. It seems to be in the place of the IP mask. i think thats an email program artifact, trying to treat an IP as a URL -- john r p

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

2013-10-16 Thread Adrian Klaver
On 10/16/2013 04:20 PM, Bob Jolliffe wrote: CCing the list so more eyes can see thid. Hi Adrian Sure. Here are 6 versions of complete pg_hba.conf files: 1. This works (note the auth method is peer not ident. my first post had an error). Complete one line pg_hba.conf file: local all postg

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

2013-10-16 Thread Adrian Klaver
On 10/16/2013 09:46 AM, Bob Jolliffe wrote: Hello I just upgraded my postgresql server from 8.4 to 9.2 on ubuntu linux 12.04. I installed the new version then used pg_upgrade to upgrade and replicate the cluster from the old server to the new. Everything appears to have worked well except that

[GENERAL] pg_hba.conf broken after cluster upgrade

2013-10-16 Thread Bob Jolliffe
Hello I just upgraded my postgresql server from 8.4 to 9.2 on ubuntu linux 12.04. I installed the new version then used pg_upgrade to upgrade and replicate the cluster from the old server to the new. Everything appears to have worked well except that I am left with a problem with my pg_hba.conf