Well day two here at PgEast has drawn to a close and it was
another
very informative day.
Today I concentrated on the more common tasks of a Pg DBA so I
attended three
talks (four if you count mine) that where rather heavy on the
technical side of being a Pg DBA
Keven Kempter drew me back again with his excellent talk on
Backup and recovery methods
this time giving some very good advice on how to use and abuse of
pg_Dump_all and
PG_restore. He also touched on three different recipes PITR on
ProstgreSQL and gave some handy
advice on when and why to use it.
I also caught another Mongo talk this time by Steve Francia it
was on the application of Mongo
in a real world web retail store. He presented a very convincing
argument for the NoSQL side of things in
the retail realm namely that RDBMS works great when you have but
a few similar products
such as books, CDs and …