From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>,
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Simon Riggs <simon(at)2ndquadrant(dot)com>,
Stephen Frost <sfrost(at)snowman(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>,
Aidan Van Dyk <aidan(at)highrise(dot)ca>, Joshua Tolley <eggyknap(at)gmail(dot)com>,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Thoughts on pg_hba.conf rejection
Date:
2010-04-20 14:19:45
Message-ID:
26632.1271773185@sss.pgh.pa.us (view raw or flat )
Thread:
2010-04-07 10:51:52 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-07 14:46:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-07 15:41:23 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
2010-04-07 15:43:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-07 17:07:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-08 23:12:31 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2010-04-14 20:19:14 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-04-14 20:24:13 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-04-14 20:28:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-14 21:51:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-14 21:57:08 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
2010-04-14 22:46:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-15 00:19:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-15 00:22:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-15 00:27:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-15 00:31:17 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-04-15 00:37:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-15 02:21:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-15 02:55:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-15 04:24:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-15 06:35:13 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-04-15 07:17:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-15 13:08:54 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-04-15 13:44:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-19 19:10:49 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-19 20:30:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-19 20:45:07 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-19 23:09:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-19 20:59:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-19 21:04:07 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-04-19 21:08:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-19 21:12:31 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-04-19 21:51:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-19 21:22:37 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-19 21:47:15 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-04-19 21:52:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-19 22:03:06 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-19 23:18:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-19 23:26:41 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-20 00:11:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-20 03:03:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-20 14:05:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-20 14:19:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-20 18:24:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-20 19:30:28 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-04-20 21:43:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-20 19:35:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-20 21:02:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-20 21:51:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-20 22:12:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-20 22:48:17 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-04-20 23:13:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-21 04:14:33 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-21 14:50:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-22 21:14:00 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-04-15 15:28:17 from David Fetter <david(at)fetter(dot)org>
2010-04-07 16:53:35 from Josh Berkus <josh(at)agliodbs(dot)com>
Lists:
pgsql-hackers
I wrote:
> Actually, while I'm looking at that code, a more immediate TODO is
> "fix walsender". Somebody has inserted an absolutely flight-of-fantasy
> code path into InitPostgres. (Hint: template1 can be dropped.
> ESPECIALLY when you're deliberately not taking any lock on it.)
Now that I look more closely, it seems what we have actually got there
is an incorrect attempt to solve the problem of authenticating without
selecting any particular database. So we could solve both this and
the original complaint in the thread if we can arrange for all
authentication to be done on the basis of shared-catalog access under
rules similar to what the AV launcher does with pg_database. At a
minimum that will require marking the pg_auth catalogs as
BKI_SCHEMA_MACRO, but that's far less painful than it used to be.
I don't recall what other consequences there are, but will go looking.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Kevin GrittnerDate: 2010-04-20 14:24:38Subject : Re: [HACKERS] Streaming replication document improvementsPrevious :From : Tom LaneDate : 2010-04-20 14:08:37Subject : Re: [HACKERS] Streaming replication document improvements
