Training

Command Prompt has been providing on-demand training since 1997 and unlike most training providers Command Prompt can cater the training to your specific business requirements. Do you only need a short course on backup and recovery? What about a five day course on overall PostgreSQL Administration or perhaps you would like an 8 hour interactive on-line course on configuring Point in Time Recovery? Whatever your PostgreSQL Training needs are. We can help.

Don't hesitate to contact us, if you would like to know more about our training.

Training

  •  The postgresql.conf from A-Z

Everybody uses it, almost nobody knows what each parameter means. Just like the Pacific Crest Trail, most people have heard of it but few people have taken the 3-4 months to seek inner peace and understanding by hiking this gorgeous section of the United States. Let's take a 3-4 hour hike and explore the postgresql.conf. We will cover the desert of memory settings, to the mountains of the background writer and autovacuum. We will walk the Sierras of random_page_cost and experience the sunsets of effective_cache_size. From A-Z, you will walk away from this training with a firm understanding of the postgresql.conf.

  • Elevating your confidence with PostgreSQL's restoration capabilities

Learn the nuances of PostgreSQL's built in backup and restore capabilities as well as external abilities brought about by technologies such as snapshots and pgBackrest. There will be instruction on pg_dump/all and restore including a full understanding of the different backup/restore formats, when to use them and how to reduce potential production issues running long backups. Lastly, the students will be shown how to use basebackups, PITR as well as filesystem snapshots and other well known utilities to properly manage the Elephant's data.

  • PostgreSQL performance and maintenance

Get a comprehensive look at proper PostgreSQL maintenance, how it relates to Performance and tying to the two together for proper provisioning and stringent uptime requirements. Students will leave this talk with full understanding of topics such as the background writer, wal writer, shared buffers, system views for monitoring, and provisioning properly within a Linux LTS environment.

  • PostgreSQL for Oracle people

 A highly popular talk discussing the in and out of PostgreSQL for Oracle folks. This training is for technical folks considering making the switch from Oracle. It discusses the subtle differences of Oracle from a business and technical standpoint. How to work with differences between data types, and other features such as replication.