PostgreSQL

External Article

PostgreSQL High Availability Options

  • Article

We are deploying a new application that uses PostgreSQL database. My manager has asked me to design high availability into the implementation. As a SQL Server database administrator, I’ve been managing PostgreSQL databases for a while. However, I’m not sure which high availability options to implement. What are the different high availability options for PostgreSQL?

2025-08-27

SQLServerCentral Editorial

Giving Thanks

  • Editorial

My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]

5 (1)

You rated this post out of 5. Change rating

2024-11-24 (first published: )

47 reads

Blogs

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

By

I’m excited to announce the release of a new open-source project that fully automates...

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

By

I’m excited to announce the release of a new open-source project that fully automates...

Advice I Like: Praise

By

Don’t reserve your kindest praise for a person until their eulogy. Tell them while...

Read the latest Blogs

Forums

Is there a way to have dynamic table headers?

By water490

Hi everyone I have a SP which compares two tables and outputs mismatching entries:...

Learning a New Language

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learning a New Language

is there a way to "detect" schema like changes on a server?

By stan

Hi, we have a few people who like to experiment on our prod sql...

Visit the forum

Question of the Day

Copying Production Schema

If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?

See possible answers