Re: [PATCHES] initdb authentication
Peter Eisentraut wrote: > Magnus Hagander wrote: > > Ok, here is another one. > > > > Doc patches coming up if/when this one is approved. > > I think this warning is seriously going to annoy me. Can we do without > it? What if we skip the warning if the user specifically asks for 'trust'? Would that help? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] initdb authentication
Magnus Hagander wrote: > Ok, here is another one. > > Doc patches coming up if/when this one is approved. I think this warning is seriously going to annoy me. Can we do without it? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [PATCHES] win32 readline
Magnus Hagander wrote: > Just for reference, what features are we losing without readline. Tab > completion, but what more? Command history, customizable key bindings, cut and paste, cursor keys come to mind. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] initdb authentication
>>Ok, here is another one. >> >>Doc patches coming up if/when this one is approved. >> >>//Magnus >> >> >> >> >> >+ /* Kerberos methods not listed because they are not supported >+* over local connections and are rejected in hba.c */ > >Is this true of all local connections, or only Unix socket >connections? >After all, this patch adjusts one 'local' line and 2 'host' >lines. Maybe >we would just need to tell people that if they want Kerberos >they would >have to do it by hand, rather than using this flag. It's true of 'local', meaning Unix socket connections. Something along that line about kerberos should go in the docs, yes :-) //Magnus ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [PATCHES] initdb authentication
I assume he means 'local' lines in the config file, not local INET connections. Maybe local needs quotes --- Andrew Dunstan wrote: > > > Magnus Hagander wrote: > > >Ok, here is another one. > > > >Doc patches coming up if/when this one is approved. > > > >//Magnus > > > > > > > > > > > + /* Kerberos methods not listed because they are not supported > +* over local connections and are rejected in hba.c */ > > Is this true of all local connections, or only Unix socket connections? > After all, this patch adjusts one 'local' line and 2 'host' lines. Maybe > we would just need to tell people that if they want Kerberos they would > have to do it by hand, rather than using this flag. > > cheers > > andrew > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PATCHES] initdb authentication
Magnus Hagander wrote: Ok, here is another one. Doc patches coming up if/when this one is approved. //Magnus + /* Kerberos methods not listed because they are not supported +* over local connections and are rejected in hba.c */ Is this true of all local connections, or only Unix socket connections? After all, this patch adjusts one 'local' line and 2 'host' lines. Maybe we would just need to tell people that if they want Kerberos they would have to do it by hand, rather than using this flag. cheers andrew ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] win32 readline
>Magnus Hagander wrote: >> Ok, then we're testing completely different things. I'm talking about >> the psql client when running under CMD.EXE, *not* in the msys shell. >> (backslash works fine in the bash shell) > >OK, I'll try that later. As an additional data point, running sh.exe >from within cmd.exe also gives a functional readline environment. So >either there are local difficulties with some people, or psql is not >using readline as well as it could. In any case, there is still hope >for readline on Windows. Right. sh does work for me. Just for reference, what features are we losing without readline. Tab completion, but what more? //Magnus ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PATCHES] initdb authentication
Ok, here is another one. Doc patches coming up if/when this one is approved. //Magnus >-Original Message- >From: Bruce Momjian [mailto:[EMAIL PROTECTED] >Sent: den 17 juli 2004 03:11 >To: Magnus Hagander >Cc: [EMAIL PROTECTED] >Subject: Re: [PATCHES] initdb authentication > > > >I got a new idea on this. I think we should add an initdb option that >takes a string to specify the local authentication method: > > initdb --localauth 'ident' > >or whatever the user wants. I think this is more flexible and more >compact. It would default to 'trust', and the packagers could >set it to >whatever they want. If their OS supports local ident, they can use >that. > >Also keep in mind you might want some ident map file: > > initdb --localauth 'ident mymap' > >so you would need to allow multiple words in the string. > >--- > > >Magnus Hagander wrote: >> Here's a version of this patch that includes documentation updates. >> >> //Magnus initdb_auth.patch Description: initdb_auth.patch ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] win32 readline
Magnus Hagander wrote: > Ok, then we're testing completely different things. I'm talking about > the psql client when running under CMD.EXE, *not* in the msys shell. > (backslash works fine in the bash shell) OK, I'll try that later. As an additional data point, running sh.exe from within cmd.exe also gives a functional readline environment. So either there are local difficulties with some people, or psql is not using readline as well as it could. In any case, there is still hope for readline on Windows. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PATCHES] win32 readline
> > Hmm. And this is a cvs pull that was before Bruce actually disabled > > readline? What locale are you in? > > Actually, I just just typed away in the bash shell, which > uses readline as well. Ok, then we're testing completely different things. I'm talking about the psql client when running under CMD.EXE, *not* in the msys shell. (backslash works fine in the bash shell) //Magnus ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [PATCHES] logfile subprocess and Fancy File Functions
Bruce Momjian wrote:
Here is what you can do:
SELECT filename,
(SELECT file_len FROM pg_file_stat(filename)),
(SELECT file_ctime FROM pg_file_stat(filename)),
(SELECT file_mtime FROM pg_file_stat(filename)),
(SELECT file_atime FROM pg_file_stat(filename))
FROM pg_dir_ls('/etc') AS d (filename text...)
WHERE filename like 's%'
Not really satisfying (pg_file_stat is volatile) but subselects give the
desired result.
Are we done? Seems pg_file_stat() works fine. Do we need other
adjustments?
The only single spot where performance could be improved is in
pg_file_stat, where attinmeta is created again and again; this may be
cached in a static memory context instead.
---(end of broadcast)---
TIP 8: explain analyze is your friend
