CODEWITHSUNDEEP
ruby-on-rails-3postgresqlreplicationmaster-slave
Miriam H.
Miriam H.

Reputation: 681

What database replication model do I need?

I am on Rails 3 with a local Postgres database. What we want to do is replicate the entire database onto a second server in real time. We are thinking of using Octopus.

I'm confused about what model I'm looking for and how the master-slave model applies.

Upvotes: 0

Views: 247

Answers (1)

jcern
jcern

Reputation: 7848

Postgres 9.1 and later comes with streaming replication built in (for master-slave configurations). Check out http://www.postgresql.org/docs/9.2/static/warm-standby.html#STREAMING-REPLICATION for more information on configuration and setup.

There are other third-party solutions for configuration, but I'd start there and see if that meets your needs.

Upvotes: 2

Related Questions