2ndQuadrant | PostgreSQL
Mission Critical Databases
+39 0574 159 3000
  • Contact us
  • IT
    • EN
    • FR
    • ES
    • DE
    • PT
  • Supporto e Servizi
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case per il Supporto su PostgreSQL
      • BDR
    • Case Studies
      • Migrazione del Database
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Tuning delle prestazioni
        • BenchPrep
        • tastyworks
      • Cluster distribuiti di database
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Aggiornamento del Database
        • Alfred Wegener Institute (AWI)
      • Supporto e Amministrazione del Database
        • Met Office
        • Agilis Systems
        • London & Partners
  • Centro di Apprendimento PostgreSQL
    • Webinars
      • Archivio Webinar
    • Whitepapers
      • Business Case per il Supporto su PostgreSQL
      • Buone prassi per la sicurezza
    • Blog
    • Formazione Professionale
      • Catalogo dei corsi
    • Case Studies
      • Tuning delle prestazioni
        • BenchPrep
        • tastyworks
      • Cluster distribuiti
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Amministrazione del Database
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Aggiornamento del Database
        • Alfred Wegener Institute (AWI)
      • Migrazione del Database
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Libri
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2 Edizione
      • PostgreSQL 9 Administration Cookbook – 3 Edizione
      • PostgreSQL Server Programming Cookbook – 2 Edizione
      • PostgreSQL 9 Cookbook – Edizione in lingua Cinese
    • Video
    • PostgreSQL
      • PostgreSQL – La storia
      • Chi usa PostgreSQL?
      • PostgreSQL FAQs
      • PostgreSQL vs MySQL
      • Business Case per PostgreSQL
      • Informazioni di Sicurezza
      • Introduzione a PostGIS
      • Documentazione
  • Chi siamo
    • Chi è 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • Notizie
    • Lavora con noi
  • Blog
  • Installers
  • Menu Menu
Sei in: Home1 / Services2 / Upgrade PostgreSQL

Upgrade PostgreSQL

To ensure your mission critical database runs optimally, it is important to ensure you are running the most up-to-date version of PostgreSQL. The Postgres experts at 2ndQuadrant can help you upgrade your mission critical database systems with almost zero downtime.

On This Page

  1. Why Upgrade?
  2. Upgrade PostgreSQL with Zero Downtime
  3. Knowledge Base
  4. Get in touch
Upgrade PostgreSQL Zero Downtime

Why Upgrade?

Some of the top reasons you should upgrade your PostgreSQL database are:

  • Access to new features
  • Community support
  • Increase robustness
  • Improve performance
  • Keep up to date with patches
  • Upgrade PostgreSQL Zero Downtime

In order to receive continuous community support, your system must be running on a supported version. Each major version of PostgreSQL is supported by the community for 5 years, until it reaches End of Life (EOL).

Want to learn how you can achieve a zero downtime upgrade? Get in Touch!

Back to top

Upgrade PostgreSQL with Zero Downtime

Performing a PostgreSQL Upgrade for a large or high-volume database using logical replication can minimize downtime to almost zero. The PostgreSQL engineers at 2ndQuadrant developed the code for logical replication, which forms the basis of the popular PostgreSQL extension, pglogical.

pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.With first-hand knowledge of the code-base, 2ndQuadrant is able to help upgrade your current PostgreSQL database with almost zero downtime.

Back to top

Database Upgrade Knowledge Base

Case Studies

Leading Polar & Marine Research Institution Upgrades to Highly Efficient Database Infrastructure

AWI

Internationally recognized institute known for expertise in polar and marine research, AWI, invested in various PostgreSQL versions and operating systems for their applications. 2ndQuadrant helped AWI set up a homogenous PostgreSQL and OS versions environment with a standardized backup plan to better operate in a variety of polar and marine research stations, which are constantly collecting an enormous amount of data.

Download Case Study

Blogs

Nessun risultato

Spiacente, nessun articolo corrisponde ai tuoi criteri

View All Blogs
Back to top
Back to Postgres Support & Services

Get in touch with us!

Please fill in the form below and we'll be in touch as soon as possible.

  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

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
Scorrere verso l’alto
×