DCPM: Postgres

[Simon Waters]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Matthew Browning wrote:
>
> On a side note, what's the best book on Postgres?  Any suggestions
> welcome.

The online manual has only let me down once.

It was a tad vague on how to figure out where your tables, and indexes,
are on disk, which is really a big (old?) database admin mentality
thing. These days just stripe and mirror everywhere or let the RAID
controller optimise your disk IO HP style.

It was documented but buried away, and keeps changing from what I can
gather.

Q: I mean how much do you need to know about a relational database?
A: It talks SQL ;)

I know it has some funky features like HTML output, and unique abilities
when it comes to doing non-relational stuff (table hierarchies), but I
either never needed them, or wanted to do them in a portable fashion.

The only bit I have found causes any pause for thought are the way it
handles authentication, but once you get the hang it is remarkably
flexible, allowing me to trust "postgres" locally to do unattended
backup, but insist on passwords for all other connections to the database.

Oh and there was a recent security patch for the networking, but that
applies to everything these days as far as I can tell.
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/uoS/GFXfHI9FVgYRAl1rAJwPUc3aBevzO6pZp6q0T4Bsycv8LACg2SB3
4MsSfR2Lws0PcABpcJUdxNc=
=uaEh
-----END PGP SIGNATURE-----