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

PostgreSQL

graphic
Downloads Contact  
Cybertec product family
line
Library
line
Success stories
line
News
line
Sample Movies
line
How to buy
line
--- Training and
certification ---

line
Services
line
Support
Training and certification

pixelPostgreSQL 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
pixelInstalling from source
pixelInstalling binaries
pixelUpdates
Solaris and AIX specifics
Creating and dropping databases
Encoding related issues
Adjusting kernel parameters n

The PostgreSQL database architecture
Overview
pixelThe Postmaster
pixelBackends
pixelThe importance of shared memory
pixelThe stats collector
pixelCheckpoint Subprocesses
Practical impacts of the PostgreSQL architecture

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

PostgreSQL performance tuning
Optimizing storage
pixelTablespaces
pixelAdjusting checkpoints
pixelAdjusting storage parameters
pixelOptimizing the background writer
pixelThe importance of fsync()
Indexes
pixelIndexing concepts
pixelCreating and dropping indexes
pixelSpace consumption of indexes
pixelPartial indexes
pixelDetecting unused indexes
Detecting slow queries
Using explain

Maintenance
VACUUM
pixelCleaning up storage
pixelPreventing transaction wraparound
pixelVACUUM FULL
pixelVACUUM FREEZE
Rebuilding optimizer stats

Monitoring
Creating and using logfiles
Monitoring database activity
Gathering performance data
pixelCache hit rates
pixelI/O statistics

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

<< back

  Who we are
line
  Cybertec is a leading vendor of PostgreSQL based solutions.
Rely on our expertise and contact us.
   
  Related links
line
 
Cybertec Schönig & Schönig Gmbh (Europe) www.postgresql.at
PostgreSQL documentation
PostgreSQL on Wikipedia
Contact us for help
line
help
E-mail us
Extending PostgreSQL
line
extending postgresql
Use PostgreSQL to solve complex business problems.
Learn about how PostgreSQL can be extended and customized. -->> more
Training events
line
training events
Stay up to date on the latest training classes and book your personal workshop.
-->> more
Cybertec PostgreSQL US Services Division