Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-13 Thread Adrian Klaver
On 10/12/2016 08:57 AM, arnaud gaboury wrote: On Wed, Oct 12, 2016 at 3:41 PM Adrian Klaver So other then adding the mapping for the dovecot user, did anything else change? after a little bit of cleaning and a change in my Postgres username (now postgres username == unix user),

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-12 Thread arnaud gaboury
On Wed, Oct 12, 2016 at 3:41 PM Adrian Klaver wrote: > On 10/12/2016 02:07 AM, arnaud gaboury wrote: > > > > > > > > > On Tue, Oct 11, 2016 at 4:20 PM Tom Lane > > > wrote: > > > > > > arnaud gaboury > > > writes: > > > > > >

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-12 Thread Adrian Klaver
On 10/12/2016 02:07 AM, arnaud gaboury wrote: On Tue, Oct 11, 2016 at 4:20 PM Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: arnaud gaboury mailto:arnaud.gabo...@gmail.com>> writes: > I am a little confused about some of my settings when it comes to map > linux/psql users. I

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-12 Thread Adrian Klaver
On 10/12/2016 01:30 AM, arnaud gaboury wrote: On Tue, Oct 11, 2016 at 4:20 PM Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: arnaud gaboury mailto:arnaud.gabo...@gmail.com>> writes: > I am a little confused about some of my settings when it comes to map > linux/psql users. I

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-12 Thread arnaud gaboury
On Tue, Oct 11, 2016 at 4:20 PM Tom Lane wrote: > arnaud gaboury writes: > > > I am a little confused about some of my settings when it comes to map > > > linux/psql users. > > > > I think you're misunderstanding what the user-mapping stuff does. > > It does not silently translate the username i

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-12 Thread arnaud gaboury
On Tue, Oct 11, 2016 at 4:20 PM Tom Lane wrote: > arnaud gaboury writes: > > > I am a little confused about some of my settings when it comes to map > > > linux/psql users. > > > > I think you're misunderstanding what the user-mapping stuff does. > > It does not silently translate the username i

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-11 Thread Tom Lane
arnaud gaboury writes: > I am a little confused about some of my settings when it comes to map > linux/psql users. I think you're misunderstanding what the user-mapping stuff does. It does not silently translate the username in the connection request to something else; rather, it checks whether a

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-11 Thread Adrian Klaver
On 10/11/2016 06:47 AM, arnaud gaboury wrote: Did you remember to reload Postgres? YES I did it this time My mistake, forget to look at your connection string: psql postgres:///mattermost You have not told Postgres what user you want mattermost to connect as. It worked for you b

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-11 Thread arnaud gaboury
On Tue, Oct 11, 2016 at 3:45 PM Adrian Klaver wrote: > On 10/11/2016 04:25 AM, arnaud gaboury wrote: > > > I am a little confused about some of my settings when it comes to map > > > linux/psql users. > > > > > > I have two databases: mattermost and thetradinghall > > > I have two linux users: ma

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-11 Thread Adrian Klaver
On 10/11/2016 04:25 AM, arnaud gaboury wrote: I am a little confused about some of my settings when it comes to map linux/psql users. I have two databases: mattermost and thetradinghall I have two linux users: mattermost and dovecot. mattermost is the one who want to talk to mattermost and dove