In this one intense tutorial, we'll go from a bare machine with just a PostgreSQL source tarball or RPM in hand to a fully-functional, replicated, backed-up, tuned database installation. We'll cover: Installing the base PostgreSQL package and important additional modules; How to lay out the installation and the various components of PostgreSQL in the right places in the file system; Basic PostgreSQL tuning and optimization for particular hardware.; Getting PostgreSQL streaming replication/hot standby set up.; Doing backups; Monitoring and performance checking once your database is in production; Disaster planning and recovery. Only basic system administration experience is required; if you can type commands into bash, you're qualified.

More Presentations