Re: [HACKERS] Hostnames in pg_hba.conf

2010-07-19 Thread Peter Eisentraut
On tor, 2010-02-11 at 14:13 +0100, Bart Samwel wrote: I've been working on a patch to add hostname support to pg_hba.conf. It's not ready for public display yet, but I would just like to run a couple of issues / discussion points past everybody. What's the status of this? -- Sent via

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-12 Thread Bart Samwel
On Fri, Feb 12, 2010 at 02:31, Mark Mielke m...@mark.mielke.cc wrote: But once there, it seems clear that packing hostnames or netmasks onto one line is just ugly and hard to manage. I'd like to see this extended to any of the many ways to allow hostnames to be specified one per line. For

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-12 Thread Peter Eisentraut
On tor, 2010-02-11 at 14:13 +0100, Bart Samwel wrote: I've been working on a patch to add hostname support to pg_hba.conf. It's not ready for public display yet, but I would just like to run a couple of issues / discussion points past everybody. It might be good to review Apache's

[HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Bart Samwel
Hi there, I've been working on a patch to add hostname support to pg_hba.conf. It's not ready for public display yet, but I would just like to run a couple of issues / discussion points past everybody. ISSUE #1: Performance / caching At present, I've simply not added caching. The reasoning for

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Kevin Grittner
Bart Samwel b...@samwel.tk wrote: I've been working on a patch to add hostname support to pg_hba.conf. At present, I've simply not added caching. Perhaps you could just recommend using nscd (or similar). There was a suggestion on the TODO list on the wiki, which basically said that

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Mark Mielke
On 02/11/2010 08:13 AM, Bart Samwel wrote: ISSUE #1: Performance / caching At present, I've simply not added caching. The reasoning for this is as follows: (a) getaddrinfo doesn't tell us about expiry, so when do you refresh? (b) If you put the cache in the postmaster, it will not work for

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Tom Lane
Bart Samwel b...@samwel.tk writes: I've been working on a patch to add hostname support to pg_hba.conf. Have you read the previous discussions about that? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Bart Samwel
On Thu, Feb 11, 2010 at 16:36, Mark Mielke m...@mark.mielke.cc wrote: On 02/11/2010 08:13 AM, Bart Samwel wrote: ISSUE #2: Reverse lookup? There was a suggestion on the TODO list on the wiki, which basically said that maybe we could use reverse lookup to find the hostname and then check

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Mark Mielke
On 02/11/2010 04:54 PM, Bart Samwel wrote: On Thu, Feb 11, 2010 at 16:36, Mark Mielke m...@mark.mielke.cc mailto:m...@mark.mielke.cc wrote: ISSUE #3: Multiple hostnames? Currently, a pg_hba entry lists an IP / netmask combination. I would suggest allowing lists of hostnames in

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Bart Samwel
On Thu, Feb 11, 2010 at 17:21, Tom Lane t...@sss.pgh.pa.us wrote: Bart Samwel b...@samwel.tk writes: I've been working on a patch to add hostname support to pg_hba.conf. Have you read the previous discussions about that? Yes, mostly. The previous discussions included all sorts of complex

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Bart Samwel
On Thu, Feb 11, 2010 at 23:01, Mark Mielke m...@mark.mielke.cc wrote: On 02/11/2010 04:54 PM, Bart Samwel wrote: ISSUE #3: Multiple hostnames? Currently, a pg_hba entry lists an IP / netmask combination. I would suggest allowing lists of hostnames in the entries, so that you can at least

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Mark Mielke
On 02/11/2010 05:12 PM, Bart Samwel wrote: On Thu, Feb 11, 2010 at 23:01, Mark Mielke m...@mark.mielke.cc mailto:m...@mark.mielke.cc wrote: On 02/11/2010 04:54 PM, Bart Samwel wrote: ISSUE #3: Multiple hostnames? Currently, a pg_hba entry lists an IP / netmask

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Euler Taveira de Oliveira
Mark Mielke escreveu: Of course, then I'll ask for the ability to simplify specifying multiple databases: We already support multiple users and/or databases for a single pg_hba.conf line ... -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Hostnames in pg_hba.conf

2010-02-11 Thread Mark Mielke
On 02/11/2010 09:38 PM, Euler Taveira de Oliveira wrote: Mark Mielke escreveu: Of course, then I'll ask for the ability to simplify specifying multiple databases: We already support multiple users and/or databases for a single pg_hba.conf line ... Is there a reason you trimmed