Netherlands

4 days / 26 talks
Awesome and great speakers

October 5-10
https://i1.wp.com/www.omnisworld.co.uk/wp-content/uploads/2023/07/thumbnail_MirkoPepa.jpg?fit=320%2C320&ssl=1

Mirko Pepa

Mirko Pepa has been developing with Omnis since Version 3. He studied at Swiss Federal Institute of Technology (ETH) and took courses with Pascal language creator Professor Wirth. Afterward, he founded Profile GmbH, an IT company in Winterthur, Switzerland. Initially, the company sold Apple Computers, developed software and supported customers. Later the company focused on its own software called Helper; an ERP-software solution for small and medium printing and prepress-companies.

Helper now uses Studio 11 wth PostgreSQL. It is a workflow system for large volume document scanning with modules for generating PDFs, branding pages, adding bookmarks, and injecting metadata. To complement Omnis, his company’s software stack includes MantisBT, Mediawiki, NSIS, Sentry, OmnisTAP, PostgreSQL, Jenkins, Apache Archiva, Gitea, and more.

Mirko also serves as an exam expert in the Canton of Zürich for application developer apprentices.

He lives in Winterthur, Switzerland, growing up bilingual, with roots in Italy and Germany. His passions include travelling to the beautiful ‘Riviera del Conero’ on the Adriatic Coast of Italy to enjoy good food and nice weather. Having already learned a few European languages, lately he started to learn Japanese and discover Japan. He is also interested in architecture and art, especially art nouveau, but is also fascinated by all complicated and big machines.


Backing up PostgreSQL

What are my Options?

Overview:

Backing up databases is crucial.   Postgres offers options for different needs and situations, each with its own advantages and disadvantages.

What You’ll Learn:

In this session, you’ll learn about different backup approaches and which to select based on your needs:

  • Simple SQL pg_gump backups via scripts for MacOS and Windows, with automatic restore.
  • Point-In-Time backup and recovery.   You can restore a postgres database to an exact point in time that might precede an action taken by a user, or a specific event.
  • Backup strategies for postgres-docker-containers
  • Streaming replication for high availability and disaster recovery
  • The new incremental backup-feature in Postgres 17 for point in time recovery
  • Using tools to manage your backup processes like pgbackrest or barman on Linux

Why you should attend

If you are new to PostgreSQL and are wondering about all the backup possibilities after reading the Postgres manuals about utilities like pg_dump, pg_restore, pg_basebackup etc. then this is the session for you.   The discussion will provide backup options that cover most situations.

Or if you already use postgres in production and already have some backup-techniques (of course you have!!) but want to hear about other possibilities.




Make

Connection

Follow Mirko


Meet

Company



About workshops

Format

You’ll sign up for the session you want to attend on a first-come, first-served basis. Up to 6 participants may attend a session, if full, you can sign up for the same topic at a different time. During the session, the speaker will guide the audience through the main topic but you will be able to ask him/her to deviate and cover related areas. Sometimes participants offer new ideas and solutions to a problem.



Check the

Speakers

Pursue any question or area not directly related to the core topic. Every speaker hosts at least 4 sessions which means there are about 11 to 12 simultaneous sessions running all the time with an average of 5 or 6 participants

Meet the Speakers


Check the

Schedule

Flexible conference format means you can choose the best classes for you and at the best time. Some sessions will be repeated, so when you miss one, you can attend the same session later in the day or the week.

Check the Schedule