Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Postgres Ahoy! More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Auth changes (Score:1)

by petdance (2468) <andy@petdance.com> on 2002.08.06 9:00 (#11455) Homepage Journal

I'm not fond the postgres authorization system. I prefer the MySQL style of internal SQL tables to manage access to the databases rather than an external, UNIXy text file database. SIGHUPs to postmaster for authorization changes? Eek.
That there needs to be any notification of the server at all seems suboptimal to me. I can't tell you how many times in the past few years I've been bitten by forgetting to do a FLUSH PRIVILEGES in MySQL after updating permissions. :-(

--
--
xoa

Reply to This
- Re:Auth changes (Score:1)
  
  by jjohn (22)
  
  I've been bitten by forgetting to do a FLUSH PRIVILEGES in MySQL after updating permissions
  As have I. I believe that using the GRANT statement eliminates the need for a FLUSH or mysqladmin reload.
  But, yes. It's annoying. Does Oracle handle this more gracefully?
  - Re:Auth changes (Score:1)
    
    by petdance (2468)
    
    I'm pretty sure that GRANT does not force a flush. Maybe it does.
    
    --
    --
    xoa

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.