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.

All the Perl that's Practical to Extract and Report

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

Postgres Ahoy! 6 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.

  • Alternatives (Score:3, Interesting)

    by djberg96 (2603) on 2002.08.05 21:05 (#11436) Journal
    I saw sap-db [sapdb.org] for the first time today, and it looks interesting. Thought I'd pass it along. It may have what you want.

    • Re:Alternatives (Score:2, Informative)

      by jjohn (22)

      First, thank you for the tip.

      Saw that /. item too. SAP doesn't look that enticing to me. It looks like an ailing product that wanted some opensource fairy dust sprinkled on it. I read a fair amount of the comments and looked around at the docs on the site.

      • The code is a weird blend of pascal and C++. It uses a proprietary "transpiler" to compile the pascal into C. Jesus.
      • It supports Perl through ODBC. Ick.
      • Despite marketing hype, many users reported a fairly negative experience on install.

      Postg

  • This is a run time setting, in /var/lib/pgsql/data/postgresql.conf. You can configure a number of useful things in there. All of them require a server restart, though.

    There's good documentation on that in the postgresql manual somewhere.

    It does kind of suck that you can't change the host based access from inside the database, but hopefully, it's not something you'll be changing too often anyway...

    -Dom

  • 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

    • 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?

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