Administración de PostgreSQL y ajustes de Performance
Fechas
¡Consulta las fechas disponibles para el curso!
Si no hay fecha y hora disponibles para cierta capacitación que le interesa, comuníquese con nosotros. contacto.
Ver fechas >>
Este curso dura 4 días. Además, es posible reservar un día más, durante el cual abordaremos cuestiones individuales.
Audiencia
Este curso está dirigido principalmente hacia administradores de bases de datos (Linux / Windows / Solaris / Mac OS X) y sysadmis. Nos enfocaremos en temas relacionados con la administración de bases de datos y los ajustes de performance.
Contenido
Día 3
- The PostgreSQL project, support, community, release- and version management
- Overview architecture
- Installation, start and stop the server, connect to the client
- Client “psql”
- Indexing with B-Tree indexes
- EXPLAIN
- Transactions: Atomicity, Isolation, Locking
Día 2
- Transactions: optimistic and pessimistic “locks”
- Multiversioning
- VACUUM
- Autovacuum
- Logical backup, data export and import (pg_dump)
- physical backup, Transaction log archiving
- Point-in-time Recovery
Día 3
- Streaming Replication
- Synchrone Replication
- Hot Standby and conflict management
- Failover
- High Availability, concept of Patroni
- User management, authentification
- Remote access to the database
- Permissions
Día 4
- Configuration parameters
- Logging
- Resource management
- Parameter tuning
- Security
- Upgrade
- Statistics and monitoring
- Statement tuning
- EXPLAIN (ANALYZE, BUFFERS)
- Extended Statistic
REGISTRESE AL CURSO
Other courses that might interest you
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Infrastructure
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.