2ndQuadrant | PostgreSQL
Bases de Datos de Misión Crítica
  • Contacto
  • ES
    • EN
    • FR
    • IT
    • DE
    • PT
  • Soporte & Servicios
  • Descargas
    • Instaladores
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Caso de Negocio para Soporte PostgreSQL
      • Mejores Prácticas de Seguridad
    • Casos de Estudio
      • Migración de Bases de Datos
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Ajustes de Rendimiento
        • BenchPrep
        • tastyworks
      • Clústeres de Bases de Datos Distribuidas
        • ClickUp
        • Agencia Espacial Europea (ESA)
        • Animal Logic
        • Telefónica del Sur
      • Actualizaciones de Bases de Datos
        • Instituto Alfred Wegener (AWI)
      • Soporte & Administración de Bases de Datos
        • Met Office
        • Agilis Systems
        • London & Partners
  • Centro de Aprendizaje Postgres
    • Webinars
      • Próximos Webinars
      • Biblioteca de Webinar
    • Whitepapers
      • Caso de Negocio para Soporte PostgreSQL
      • Mejores Prácticas de Seguridad
    • Blog
    • Formación
      • Catálogo de los Cursos
    • Casos de Estudio
      • Ajustes de Rendimiento
        • BenchPrep
        • tastyworks
      • Clústeres Distribuidos
        • ClickUp
        • Agencia Espacial Europea (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Administración de Bases de Datos
        • Agilis Systems
      • Formación Profesional
        • Met Office
        • London Partners
      • Actualizaciones de Bases de Datos
        • Instituto Alfred Wegener (AWI)
      • Migración de Bases de Datos
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Libros
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2a Edición
      • PostgreSQL 9 Administration Cookbook – 3a Edición
      • PostgreSQL Server Programming Cookbook – 2a Edición
      • PostgreSQL 9 Cookbook – Edición en Chino
    • Videos
    • PostgreSQL
      • PostgreSQL – La historia
      • ¿Quién usa PostgreSQL?
      • Preguntas Frecuentes sobre PostgreSQL
      • PostgreSQL VS MySQL
      • Caso de Negocio para PostgreSQL
      • Información de Seguridad
      • Documentación
  • Sobre nosotros
    • Sobre 2ndQuadrant
    • La Pasión de 2ndQuadrant por PostgreSQL
    • Noticias
    • Trabaje con Nosotros
  • Blog
  • Instaladores
  • Menú Menú
Usted está aquí: Inicio1 / Alfred Wegener Institute (AWI)

Alfred Wegener Institute (AWI)

2ndQuadrant enlisted by internationally recognized polar and marine research institute

The Alfred Wegener Institute (AWI) is an internationally recognized institute known for expertise in polar and marine research. It is one of the very few scientific institutions in the world that is equally active in the Arctic and Antarctic. Combining innovative approaches, outstanding research infrastructure and years of expertise, AWI explores nearly all aspects of the Earth system – from the atmosphere to the ocean floor. AWI’s research is focused on the consequences of climate change and the pollution of the oceans, as well as early detection and warnings for seaquakes (tsunamis).

For their research, AWI operates on a variety of research stations including ships, aircrafts, buoys, and so on, which constantly collect an enormous amount of data. Databases are a critical building block of the AWI data flow and management framework. They facilitate each step of the data lifecycle – from the instrument/sensor level up to archival and data publication.

The Challenge

Over the years, as the demand presented itself, AWI invested in various PostgreSQL versions and operating systems for their applications – versions that were the latest & greatest at that point in time. This decision inevitably led to 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. Such a model requires a hefty investment, both in terms of time and expertise. One of the most persistent obstacles for AWI was the difficulty in maintaining consistency between versions, troubleshooting, and streamlining the processes of sporadic updates.

The Solution

Having homogenous PostgreSQL and OS versions with a standardized backup plan is conducive to a manageable system. After researching several possible vendors, AWI was most impressed by the world-class team of PostgreSQL experts at 2ndQuadrant, as well as their Platinum Sponsorship of the PostgreSQL project. They decided to engage 2ndQuadrant to work with their staff in developing a more structured architecture for the database.

During the consulting period, 2ndQuadrant consultants examined the processes, identified loopholes, and proposed a plan of action for an up-to-date and robust database infrastructure.

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

In addition, an experienced engineer 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. Lastly, the performance and functionality of the databases were tested and tuned individually against their respective applications.

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.

We got an excellent training on the job and during short interspersed tutorials, and could easily proceed ourselves on the newly gained, sound knowledge. 2ndQuadrant‘s friendly consultant delivered an extremely good job. Within only one week, he 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. 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.

Christian Schäfer-Neth, Deputy Head of IT infrastructure at AWI

About 2ndQuadrant

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases. This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.

Recent Posts

  • PG Phriday: 10 cosas que Postgres podría mejorar – Parte 3 noviembre 8, 2020
  • Búsqueda de texto completo desde PostgreSQL 8.3 noviembre 5, 2020
  • Webinar: Mejores prácticas para la carga masiva de datos en PostgreSQL [continuación] noviembre 4, 2020
  • Números aleatorios noviembre 4, 2020
  • ¿Qué partición de mi base de datos PostgreSQL contiene una fila determinada? noviembre 1, 2020
  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Soporte y Servicios

Soporte de producción 24/7

Soporte para desarrolladores

DBA remoto para PostgreSQL

Monitoreo para bases de datos PostgreSQL

Health Check para PostgreSQL

Ajustes de Rendimiento para PostgreSQL

Auditoría de seguridad para bases de datos

Actualice PostgreSQL

Evaluación de Migración hacia PostgreSQL

Migre desde Oracle

Productos

PostgreSQL de alta disponibilidad

BDR

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

Firewall SQL

Postgres-XL

OmniDB

Postgres Installer

2UDA

Centro de Aprendizaje Postgres

PostgreSQL

Blog

Webinars

Libros

Videos

Formación

Casos de Estudio

Eventos

Sobre nosotros

Sobre 2ndQuadrant

¿Qué significa «2ndQuadrant»?

Noticias

Trabaje con nosotros

Nuestro equipo

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Desplazarse hacia arriba
×