LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - News > Syndicated Linux News
User Name
Password
Syndicated Linux News This forum is for the discussion of Syndicated Linux News stories.

Notices


Reply
  Search this Thread
Old 08-27-2018, 12:03 AM   #1
LXer
LXer NewsBot
 
Registered: Dec 2005
Posts: 112,337

Rep: Reputation: 118Reputation: 118
LXer: How to create a hot standby with PostgreSQL


Published at LXer:

PostgreSQL is an open source RDBMS (Relational DataBase Management System), and with any databases, the need may arise to scale and provide HA (High Availability). A single system providing a service is always a possible single point of failure - and even with virtual systems, there may be a time when you can't add more resources to a single machine to cope with the ever-increasing load. There also may be a need to another copy of the database contents that can be queried for long-running analytics, that are not fit to be run on the highly transaction-intensive production database. This copy could be a simple restore from the most recent backup on another machine, but the data would be outdated as soon as it is restored.

Read More...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: How to Install and Configure PostgreSQL Replication with Hot Standby on Ubuntu 15.04 LXer Syndicated Linux News 0 08-05-2016 02:41 PM
Implementing real time hot standby ravishchugh Programming 9 03-24-2016 06:27 AM
Northbridge hot on standby oskar Linux - Hardware 9 03-24-2015 05:17 PM
Best practice for postgresql 9.1 DB replication for cold standby purpose NicholasHee Linux - Software 0 02-01-2012 01:40 AM
LXer: How To Set Up A PostgreSQL 9.0 Hot Standby Streaming Replication Server With Repmgr On OpenSUS LXer Syndicated Linux News 0 07-01-2011 08:10 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - News > Syndicated Linux News

All times are GMT -5. The time now is 02:17 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration