Re: DBA Book - Not "postgresql book - practical or something newer?" - Mailing list pgsql-general

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.pgsql@shaw.ca
> <mailto:ron.pgsql@shaw.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/