Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2017
    Posts
    16

    Unanswered: Postgresql hot standby and/or load balancing

    Looking to implement a cluster consisting of VM's running postgresql 9.6
    We would like to implement either a hot standby or a active/active load balancing solution.
    Does postgresql support a dual-active mode or is hot standby the only option?

    Where can I find step-by-step instructions on how to configure a postgres environment for either of these modes?
    Im running on CentOS 7.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,993
    Provided Answers: 23
    Quote Originally Posted by usao View Post
    Looking to implement a cluster consisting of VM's running postgresql 9.6
    We would like to implement either a hot standby or a active/active load balancing solution.
    Does postgresql support a dual-active mode or is hot standby the only option?
    Out of the box, Postgres only supports only hot standby but the standby can be used for queries.

    So you can distribute read-queries across a cluster of hot standby servers (e.g. using pgBouncer).
    But write request need to go to the master.

    Another option for write-scaling is to use Postgres-XL or shard data using foreign data wrappers.

    Where can I find step-by-step instructions on how to configure a postgres environment for either of these modes?
    Im running on CentOS 7.
    https://www.postgresql.org/docs/curr...ilability.html
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Jan 2017
    Posts
    16
    Thanks, the hot standby will be sufficient for our needs as long as all transactions are synchronously replicated to the secondary server.
    We don't want to loose any transactions between the primary going down and the hot standby taking over.
    Thanks.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •