Re: [HACKERS] Getting rid of the flat authentication file

2009-08-28 Thread Tom Lane
I'm back on the warpath about $SUBJECT. (Aside from any other reason to do it, it occurs to me that we really need to get rid of the flat files for Hot Standby. Otherwise we'd need some way to keep them up to date during WAL replay.) I wrote earlier: The easy way to do it would be to postpone

Re: [HACKERS] Getting rid of the flat authentication file

2009-08-28 Thread Joshua D. Drake
On Fri, 2009-08-28 at 11:52 -0400, Tom Lane wrote: I've thought of an easier way to handle this: if the given database name is invalid, connect to database postgres instead, and perform authentication using normal access to the pg_auth catalogs. If authentication succeeds, *then* throw the

Re: [HACKERS] Getting rid of the flat authentication file

2009-08-28 Thread Tom Lane
Joshua D. Drake j...@commandprompt.com writes: On Fri, 2009-08-28 at 11:52 -0400, Tom Lane wrote: I've thought of an easier way to handle this: if the given database name is invalid, connect to database postgres instead, and perform authentication using normal access to the pg_auth catalogs.

Re: [HACKERS] Getting rid of the flat authentication file

2009-08-28 Thread Robert Haas
On Fri, Aug 28, 2009 at 12:12 PM, Tom Lanet...@sss.pgh.pa.us wrote: Joshua D. Drake j...@commandprompt.com writes: On Fri, 2009-08-28 at 11:52 -0400, Tom Lane wrote: I've thought of an easier way to handle this: if the given database name is invalid, connect to database postgres instead, and

[HACKERS] Getting rid of the flat authentication file

2009-08-13 Thread Tom Lane
I've been looking into what it would take to eliminate the flat file for pg_auth info. The implication of doing that is that authentication has to be postponed until inside InitPostgres(), where we can read the actual system catalogs instead. The easy way to do it would be to postpone