2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / News2 / November 29, 2017 – 2ndQuadrant enlisted by internationally recognized...

2ndQuadrant enlisted by internationally recognized polar and marine research institute

Alfred Wegener Institute (AWI) engages 2ndQuadrant to develop structured architecture for global PostgreSQL database

Oxford, United Kingdom, November 29, 2017

2ndQuadrant, world renowned PostgreSQL experts, today announced that the  Alfred Wegener Institute (AWI), an institute internationally recognized for their expertise in polar and marine research, chose 2ndQuadrant to develop a more structured architecture for their global PostgreSQL databases.

For their research, AWI operates on a variety of research stations including ships, aircrafts, buoys, and so on, which are all constantly collecting a large amount of data. This data is then analyzed to evaluate the consequences of climate change and the pollution of the oceans as well as early detection and warnings for seaquakes (tsunamis).

Over the years, AWI has invested in various PostgreSQL versions for their applications; choosing the most current version available at the time. After some time, AWI was left with a complex database infrastructure where a mixture of different PostgreSQL and OS versions were rarely working in sync due to the absence of a centralized maintenance system.

One of the most persistent obstacles for AWI was the difficulty in maintaining consistency between versions, troubleshooting, and streamlining the processes of sporadic updates. 2ndQuadrant was engaged to examine the processes, identify loopholes, and propose a plan of action to implement an up-to-date and robust database infrastructure for their  PostgreSQL database.

2ndQuadrant consultants worked closely with the DBAs at AWI to upgrade the existing PostgreSQL databases as well as their host operating system. Prior to the upgrade service, system and application requirements were thoroughly assessed – allowing 2ndQuadrant consultants to develop a customized migration plan.

As a part of the customized plan, 2ndQuadrant helped install and configure a central PostgreSQL backup system using Barman (Backup & Recovery Manager for PostgreSQL) to enable point in time recovery (PITR). The Barman server/backup host was installed to host multiple PostgreSQL servers.

To close the loop on sustainability, 2ndQuadrant consultants trained the AWI staff on installation, configuration and migration of the systems to carry out future updates and maintain smooth workflow processes.

“Within only one week, [our consultant] helped us migrate our four historically grown PostgreSQL servers, differing in respect to Linux platforms, PostgreSQL installation sources, and extensions, to a new, consolidated server landscape, and set up a centralised backup scheme based on Barman.” said Christian Schäfer-Neth, Deputy Head of IT infrastructure at AWI. “He acted very flexibly according to the ever-changing daily work in our scientific computing department, and had competent answers to any questions that would arise.”

View or download the PDF version of the case study here.

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and five continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. They have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Their focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×