SYNOPSIS
PostgreSQL and PostGIS are the favorite database combo for spatial data processing.
This training session will allow you to know the main points, concepts, whys and wherefores linked to PostgreSQL/PostGIS administration in a production environment
This session is dedicated to database administrators.
GOALS
The course will give you the following skills :
-
- Know the main concepts linked to PostgreSQL/PostGIS server administration
- Be able to install and configure a server in a production context
- Be able to manage the main administration tasks
PROGRAM
Ce programme est donné à titre indicatif. Il peut être adapté selon les besoins:
-
PostgreSQL administration
- Installation (pgdg or compilation)
- PostgreSQL cluster organization
- Database creation, using templates
- Using the psql client
-
Spatial databases administration
- PostGIS and GEOS administration and compilation
- PostGIS metadata (geometry_columns, spatial_ref_sys)
- PostgreSQL schemas and spatial data
-
Log management
- System log setup
- Log queries and analyze them with PgBadger
-
User right management
- USER, ROLE and GROUP
- Authentication methods and pg_hba.conf
- GRANT and REVOKE
-
Performances
- Rtree and GIST indexes
- CLUSTER the data
- postgresql.conf tuning
- Vaccum and autovaccum
-
Backup and restore
- pg_dump and pg_dumpall
- Restore from WAL
- Upgrade of PostgreSQL clusters containing PostGIS databases
DURATION
3 days
PRE-REQUISITE
Good SQL 92 knowledge
RDBMS administration notions recommanded
The next courses (Lyon or Paris):
---
Contact us for on-site trainings at your office (dates are flexible to your needs).
You want to participate in this training ?
Please give us the details below if you can:
* Training
Place of training, Number of people involved, Initial level of participants, Time constraints, Specific expectations
* Contact details
Organization, Address, Contact, Email, Intracommunity VAT
