Server administration. Configuration. Binary logs and memory.
The statistics collector and activity logs.
Maintenance and operating tasks. Analyzing queries with Explain.
Analyzing and cleaning up table and index spaces with Vacuum.
Reconstructing indexes with Reindex.
8
» Backups and restores
Backups with pg_dump and pg_dumpall.
Restores with pg_restore and psql.
Binary logs: Write Ahead Logging (WAL).
Customer reviews
4,1 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
DOMINIKA M.
16/11/26
4 / 5
As far as I’m concerned, some explanations are missing from the slides. Several important options for completing the exercises are explained only verbally and do not appear in the course materials. This means I have to take additional notes to understand how to use them. Adding these explanations to the slides would make it easier to follow along and complete the exercises.
ALEXANDRE P.
16/11/26
5 / 5
An excellent trainer; the course is very theory-based and requires prior knowledge of DBMS. The content of the course materials is really good – it covers all the main functions and will be very useful for learnt the relevant commands!
ENORA M.
16/11/26
4 / 5
It could have been made clear that the course would be run primarily on Linux and that a working knowledge of it was a prerequisite. This made it more difficult for me to understand the course.
YOANN F.
16/11/26
4 / 5
The course is top-notch, and the lecturer’s technical expertise on PostgreSQL is excellent. However, I regret that we cannot spend much time on the exercises or the chapters covered.I realise that the lecturer is torn between spending time with us on the exercises and finishing the course in three days. I think PostgreSQL would need five days for us to really have time to test and practise. The lecturer therefore rushes through these chapters without having time to [
RAMI W.
16/11/26
5 / 5
It would be better to extend this course to include more content relating to the administration of the PostgreSQL database. For a start, for example, more on backups and restores, and how to generate a performance report.
SYLVAINE C.
16/11/26
3 / 5
It was very technical; the topics that interested me most were covered on the last day. I probably didn’t have enough knowledge to fully take in the information. It was interesting nonetheless, with an experienced trainer who shared some fascinating anecdotes.
CLOVIS G.
16/11/26
4 / 5
I had a good trainer who knows the subject well and is a good listener; the course materials are quite comprehensive, although we weren’t able to cover everything over the three days as some sections took longer to explain. There wasn’t much practical work; we were given exercises on a USB stick without any explanations or feedback.
LORIS R.
30/09/26
4 / 5
We didn’t really do any exercises; the trainer did the exercises and we simply copied and pasted the answers. The trainer was very enthusiastic, but numerous technical issues caused us to waste a lot of time, which is why it felt as though we were rushing through everything and only skimming the surface of the topics.
NICOLAS H.
30/09/26
5 / 5
A very good trainer; theinteractive%20course%20material%20is%20a%20very%20good%20idea.
EDDY C.
30/09/26
5 / 5
A bit disappointed with the course materials
VANKEI C.
30/09/26
5 / 5
A very effective and friendly trainer. The course content is satisfactory.
YOUSSEF N.
30/09/26
4 / 5
The trainer answered all our questions. The course materials are comprehensive.
GUILLAUME G.
30/09/26
4 / 5
Too much time was spent on the exercises.
ZAHIR B.
30/09/26
5 / 5
Uninteresting training course; the trainer has a good grasp of the material
ANTOINE N.
30/09/26
5 / 5
A very good training course. Comprehensive and precise.
DAVID C.
29/06/26
4 / 5
Appropriate content and teaching methods
ELODIE V.
25/06/26
4 / 5
The content is interesting; however, I think that from the summary alone, it’s not immediately clear which topics will be covered in depth. For example, as an Oracle DBA, there are concepts I’m familiar with that we’ve spent time on (tablespaces, statistics, etc.). The problem isn’t the content of the course, but rather the clarity of what it covers and the expectations one might have of it. For instance, I thought the section on backup and restore would be more detailed.
JULIEN J.
25/06/26
3 / 5
The training is too theoretical, with a lot of content
GABIN O.
25/06/26
3 / 5
The course content would be interesting if it were covered in full; the course cannot be completed in three days (unlike the Level 1 course); the resources (PDFs, exercises, answer keys, etc.) are good, but there is absolutely no time to make the most of them. Whenever we ask to cover a specific topic, the response is ‘Oh no, that’s in another course’, even though we’re all keen to cover it.
GREGORY M.
27/05/26
5 / 5
The trainer was very clear and was able to answer all the questions.
JUSTIN M.
27/05/26
5 / 5
A very good course for getting to grips with PostgreSQL. A good introduction to the subject.
BOURDAIS SÉBASTIEN L.
27/05/26
5 / 5
A little more time for practice would be desirable.
ABDELMAJID L.
27/05/26
4 / 5
The training programme seems particularly intensive for a three-day course. Extending it to four or five days would allow for a more in-depth exploration of the topics and make the learning experience more comfortable.
CHRISTELLE D.
27/05/26
4 / 5
An excellent course and a very good trainer; I would have liked more exercises.
JEREMY B.
27/05/26
4 / 5
Over the course of the two days (out of the three scheduled), I found the content interesting, although we only covered half of the course material. I think we didn’t get enough practical work. Our trainer knew his subject, but when we asked him questions, his answers were usually either that we needed to attend another training course, or a response accompanied by long digressions, which could be quite frustrating. I do hope, however, that he will b
ALICE C.
27/05/26
3 / 5
The training course could not be completed, as the trainer unfortunately injured himself on arrival on the morning of the third day. In the part that was covered, we managed less than half the course content in two days. It was too slow-paced and there were too many digressions. This meant that the whole section of the course that interested me was left out. The first part wasn’t relevant to me anyway. It was also a shame to get stuck on Linux; I only work on Windows and don’t know Linux (this p
JULIEN J.
27/05/26
3 / 5
It was a very interesting course, but unfortunately we only had two days of training and covered less than half of the course material (125 pages out of 270). From a professional point of view, I would have really liked to have covered the entire course. I hope the trainer is feeling better following his fall.
LAURENT A.
18/03/26
5 / 5
an excellent teaching approach, comprehensive course materials, examples that can be reused
PIERRE T.
18/03/26
4 / 5
I found it difficult to complete the exercises because I wasn’t able to fully get to grips with the tools and the technical environment.
SWAEL G.
18/03/26
5 / 5
A brilliant trainer – he answers our questions thoroughly, gives plenty of examples and tailors the course to our needs and any issues we face. The course materials are comprehensive (including the archive content).
BENOIT V.
18/03/26
3 / 5
This course was not at all suited to what I consider to be basic PostgreSQL administration in a production IT environment.We didn’t cover any scenarios involving the recovery from complicated situations (server overload, unexpected shutdowns, etc.), which, for me, should have been the main focus of the course.The PostgreSQL documentation is very comprehensive. What I needed was advice on how to apply it to a real-world context.
BONNIEC SYLVAIN L.
18/03/26
5 / 5
The content is comprehensive and precise. The trainer is a skilled teacher and was able to answer all our questions.
JÉROME B.
15/12/25
3 / 5
on the whole it was interesting, the trainer had a very good grasp of his subject but we spent a lot of time on details that won't be of much interest.
VIRGINIA N.
15/12/25
5 / 5
Training that perfectly met my expectations
ANN-GAËL M.
15/12/25
4 / 5
The trainer was perfect, but 3 days was too short to put the exercises into practice.
AGNÈS G.
15/12/25
5 / 5
Very interesting content and appropriate teaching methods
JIMMY B.
08/12/25
4 / 5
Theory is given greater priority than practice, which does not help in understanding certain elements. What's more, some elements are pushed to a high technical level, while others are skimmed over or even ignored. The most striking example is the subject of backups. I understand that Orsys has a special course dedicated to this subject, but that doesn't mean that it shouldn't be approached in a simple way, because backups are a fundamental part of administration.
NOUREDDINE G.
08/12/25
3 / 5
The trainer is competent in his field, but the training lacks structure and pedagogical progression, and practical exercises. I did not acquire the necessary knowledge.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES • The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.
Dates and locations
Dernières places
Date garantie en présentiel ou à distance
Session garantie
No session at the moment, we invite you to consult the schedule of distance classes.
12
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.