Re: DBA Book - Not "postgresql book - practical or something newer?"

Olexandr Melnyk wrote:
> Joe Celko's "SQL Programming Style" is a good not vendor-specific book.

And maybe a bit too Developer/User-ish but very good his "SQL for Smarties".

Rod
--
>
> As for PostgreSQL-specific books, I can only speak for one I read
> before: Bruce Momjian's "PostgreSQL: Introduction and Concepts". It is a
> good introductionary book, although it isn't based on PostgreSQL 8 series.
>
> On 2/6/08, *Ron St-Pierre* <ron(dot)pgsql(at)shaw(dot)ca
> <mailto:ron(dot)pgsql(at)shaw(dot)ca>> wrote:
>
> Unfortunately there isn't a current version of Joshua Drake's book out
> there (which I do own along with PostgreSQL Essential Reference by
> Stinson), so alternatively, can anyone recommend a good DBA book
> outlining best practices, physical design, etc? I would like something
> that is relevant to PostgreSQL even though it won't likely be PostgreSQL
> specific. Based on current best practices I could then investigate which
> tools postgres has available to implement them.
>
> Currently our small company has a single redhat server for the database
> and web server, backups obviously are on a separate box. We want to add
> hardware over the next few months and would like to/need to separate
> functions and take advantage of things like: replication, PITR,
> clustering, failover, plgpsql, material view perhaps, and likely more
> which would be useful to speed up and protect our data.
>
> I want to increase my DBA and postgres skills prior to the upgrade, and
> would like some direction from somewhere (book, group) on where to go
> from here. Our current database is about 50G large and is a fairly
> straightforward setup. I am the DBA and am also one of the developers,
> and my practical DBA knowledge comes from setting up our database and
> administering it. I make use of views and plpgsql, but from following
> the lists realize that there are many more tools available in postgres
> that could be used.
>
> Two possible references I found are:
> - "Physical Database Design: the database professional's guide to
> exploiting indexes, views, storage, and more" by S. Lightstone, T.
> Teorey, T. Nadeau
> http://www.amazon.com/Physical-Database-Design-professionals-exploiting/dp/0123693896
> - "Database Administration: The Complete Guide to Practices and
> Procedures" by Craig S. Mullins
> http://www.amazon.com/Database-Administration-Complete-Practices-Procedures/dp/0201741296/ref=sr_1_1?ie=UTF8&s=books&qid=1202257162&sr=8-1
> <http://www.amazon.com/Database-Administration-Complete-Practices-Procedures/dp/0201741296/ref=sr_1_1?ie=UTF8&s=books&qid=1202257162&sr=8-1>
> Can anyone recommend these, or others?
>
>
> Any and all suggestions welcome.
>
> Thanks
>
> Ron
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>
>
> --
> Sincerely yours,
> Olexandr Melnyk <><
> http://omelnyk.net/