Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    16

    Unanswered: PostgreSQL databases keep crashing-How to build failover

    Hey guys!

    I'm a SQL Server DBA, but have recently started at a company that is currently in a postgresQL enivorment and as of late their database has been crash at night.

    They are currently looking for a quick and dirty failover solution, while a long term solutioon is in place.
    What are some quick and dirty soultions that can be put in place for if the database goes down, we can still keep the frontend up and going with a switch over to another source?


    Any thouhts, ideas, and solutions I'm all open to hearing.

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Postgres crashing is something very unusual.
    You should first investigate what exactly is the reason for the crash. Very often bad hardware (harddisk, memory) can cause this and that should be fixed in the first place.

    Replication to a standby is built right into Postgres

    PostgreSQL: Documentation: 9.3: High Availability, Load Balancing, and Replication

    What you need is a tool to monitor the primary and do the actual switchover.

    There is another overview in the Postgres Wiki:

    https://wiki.postgresql.org/wiki/Rep...ection_Pooling
    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

Posting Permissions

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