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

PostgreSQL for database
application administrators

For people who have to administer a PostgreSQL based application we offer special training courses. The idea is provide people with enough knowledge about PostgreSQL so that it is possible to run and optimize the database.

Required knowledge: Basic knowledge Windows or Linux / UNIX

Duration: 2 days

Content:
Installation of PostgreSQL
Installation on Windows
Installation on Linux
Installing PostgreSQL add-ons

PostgreSQL basics
Create databases
Drop databases
Encoding related issues

PostgreSQL security
PostgreSQL updates
Defining user permissions
Managing remote access

PostgreSQL performance tuning
Using and understanding indices
Indexing concepts
Creating and dropping indexes
Partial indexes
Detecting unused indexes
Using tablespaces
Tracking slow queries
Tweaking "postgresql.conf"
Understanding VACUUM

Monitoring
Creating and using logfiles
Tracking running queries
Collecting performance relevant data

Backup and recovery
Performing backups
Replaying backups
Using Point-In-Time-Recovery

<< back