Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Question Unanswered: Can I Replicate Databases

    I have a database server running PostgreSQL 8.4 on Debian Linux and today we suffered a catastrophic hardware failure. The server literally died to a point we couldn't recover regardless of RAID. So now we've got two brand new identical Dell servers which I just performed the O.S. install on both systems but my question is it possible to replicate the data from PostgreSQL across the network to a slave PostgreSQL server?

    I did do a search for clustering PostgreSQL however I think my terminology is off. Is there support for such a process and if so, has anyone done easy to follow write-ups?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Cluster unfortunately has several meanings especially in the PostgreSQL world.

    You want a stand-by server using replication.

    This is possible with 8.4, see here:
    http://www.postgresql.org/docs/8.4/s...ilability.html

    But things got a lot easier with 9.0 and 9.1. Using streaming replication minimizes the possible loss of data in case the server goes down.

    http://www.postgresql.org/docs/9.1/s...ilability.html

    A good overview of all your possibilities is in the Postgres Wiki:

    http://wiki.postgresql.org/wiki/Repl...ection_Pooling

    I would recommend you upgrade to 9.x and use streaming replication with a hot or warm standby server.

    Whether or not you need synchronous replication is something you need to decide. Synchronous means you will never lose any data, but the downside is that it has a performance impact on the main server.

    If you start implementing that, I strongly recommend to subscribe to the Postgres mailing lists (-general and -admin)
    You'll get excellent help there (directly from the developers!)

  3. #3
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1
    Great information. Thank you!

Posting Permissions

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