2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • PT
    • EN
    • FR
    • IT
    • ES
    • DE
  • Support & Services
    • Support
      • 24/7 PostgreSQL Support
      • Developer Support
    • DBA Services
      • Remote DBA
      • Database Monitoring
    • Consulting Services
      • Health Check
      • Performance Tuning
      • Database Security Audit
      • PostgreSQL Upgrade
    • Migration Services
      • Migrate to PostgreSQL
      • Migration Assessment
  • Products
    • Postgres BDR
    • PostgreSQL High Availability
    • Kubernetes Operators for BDR & PostgreSQL
    • Managed PostgreSQL in the Cloud
    • Installers
      • Postgres Installer
      • 2UDA
    • pglogical
    • Barman
    • repmgr
    • OmniDB
    • SQL Firewall
    • Postgres-XL
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices
    • 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
      • Security Best Practices
    • Blog
    • Training
      • Course Catalog
    • 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 Wegner 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
    • What does “2ndQuadrant” mean?
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
Você está aqui: 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

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

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

Nothing Found

Sorry, no posts matched your criteria

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.

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