PostgreSQL Administration and Performance Tuning
Dates & Duration
See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.
This training can also be held at your place or as online training especially for your company. In this case the course agenda can also be adapted to suit your needs best.
Learn more about our customized training >>
This course takes 3 days with 8 hours each (on site) or 5 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.
Audience
This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmis. We will deal with administration and performance tuning related topics.
Available Language
This course can be held in English, German, Spanish, Polish, Estonian, Ukrainian and Russian.
COURSE CONTENT
Day 1
- The PostgreSQL projekt, support, community, release management
- Architecture – overview
- Installation, starting and stopping the server, connection to the client
- Basics about “psql”
- Indexing with B-Tree indexes
- EXPLAIN
- Transactions: Atomicity, Isolation, Locking
Day 2
- Transactions: optimistic vs pessimistic locking
- Multiversioning
- VACUUM
- Autovacuum
- Logical Backup, data export and import (pg_dump)
- Physical Backup, Transaction log archiving
- Point-in-time Recovery
Day 3
- Configuration parameter
- Logging
- Resource m anagement
- Parameter tuning
- User management, authentification
- Remote access
- Role management
- Security
- Upgrade
- Statistics and monitoring
Contact us to sign up for this course >>
Other courses that might interest you
We offer these services
PostgreSQL Security Audit
In our security audit, our PostgreSQL consultants will review your system, document any vulnerabilities, and recommend ways to secure those weaknesses.
PostgreSQL Security
PostgreSQL makes achieving security goals easy: It has all tools to ensure maximum efficiency and superior security. We at CYBERTEC can help to protect your most valuable asset: Your data.
PostgreSQL Update & Upgrade
CYBERTEC can assist you in performing updates and upgrades, also during non-working hours, in order to avoid interruptions in your business operations.