PostgreSQL Review

Slot-based streaming replication can be done either live or as a purposely delayed task.


Valuable Features:

  • Hassle-free, low maintenance operation
  • Free
  • SQL compliance
  • Slot-based streaming replication - live and purposely delayed are available
  • Robustness
  • Performance
  • Low maintenance
  • Decent Windows management GUI
  • Cross-platform

Improvements to My Organization:

It's improved security by allowing us to switch from an unsecure file-based database to a secure SQL database without license payments. Also, it provides us with multiple disaster recovery options with streaming replication.

Room for Improvement:

It requires better management tools.

Use of Solution:

I've been using it for 12 years.

Deployment Issues:

We have had no issues with the deployment.

Stability Issues:

It's been a stable product.

Scalability Issues:

It's been deployed on >180 machines within the organization, ranging from Windows XP to Windows 2012 R2 and Ubuntu v12 to v16, and it's been stable.

Other Advice:

Well worth the effort! I've been using it in my professional capacity without a single incident.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
Add a Comment
Guest