On Feb 6, 2008, at 11:54 AM, Ron St-Pierre 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.
I like The Art of SQL by Stephane Faroult (http://www.amazon.com/Art-
SQL-eacute-phane-Faroult/dp/0596008945/ref=pd_bbs_sr_1?
ie=UTF8&s=books&qid=1202330868&sr=1-1). It's a fairly in depth book
that covers many different advanced design topics and trade-offs.
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
