A PostgreSQL powered database environment will help you increasing the profitability of your business and will help you to achieve your business goals.

PostgreSQL Administration

Cybertec Schönig & Schönig GmbH offers training courses covering all aspects of PostgreSQL administration and optimization. You will learn everything you need to handle giant PostgreSQL databases. You will get a general overview of all important topics and you will learn about countless specific yet important issues.

Required knowledge: Basic knowledge Windows or Linux / UNIX

duration: 3 days

Content:
Installation of PostgreSQL
Installation on Windows
Installation on Linux
Installing from source
Installing binaries
Updates
Solaris and AIX specifics
Creating and dropping databases
Encoding related issues
Adjusting kernel parameters n

The PostgreSQL database architecture
Overview
The Postmaster
Backends
The importance of shared memory
The stats collector
Checkpoint Subprocesses
Practical impacts of the PostgreSQL architecture

PostgreSQL Security
TCP vs. UNIX sockets
Managing network access
Using OpenSSL
Adjust user rights
The PostgreSQL role concept
Levels of user management
Central user authentication in server farms

PostgreSQL performance tuning
Optimizing storage
Tablespaces
Adjusting checkpoints
Adjusting storage parameters
Optimizing the background writer
The importance of fsync()
Indexes
Indexing concepts
Creating and dropping indexes
Space consumption of indexes
Partial indexes
Detecting unused indexes
Detecting slow queries
Using explain

Maintenance
VACUUM
Cleaning up storage
Preventing transaction wraparound
VACUUM FULL
VACUUM FREEZE
Rebuilding optimizer stats

Monitoring
Creating and using logfiles
Monitoring database activity
Gathering performance data
Cache hit rates
I/O statistics

Backup abd recovery
Performing backups
Disaster recovery
Point-In-Time-Recovery
Implementing standby systems

<< back