All geek questions in one place

Postgres Replication

Now I have a database (about 2-3 GB) in PostgreSQL that serves as the data store for an application like LRR / Python.

What tools exist that are simple enough and reliable enough to replicate the main database to a second machine?

I looked through some packages (Slony-I, etc.), but it would be great to hear real stories as well.

Now I do not do load balancing, etc. I am thinking about using the simple Write-Ahead-Log strategy for now.

+4
source share
2 answers

If you are not replicating, Write Forward Logs is the easiest solution.

+1
source

If you can upgrade to pg 9, I would look at streaming replication - a very simple setup. Or if you can’t upgrade, you can just look at the hot spare (which you can request).

See here: http://eggie5.com/15-setting-up-pg9-streaming-replication

+2
source

Source: https://habr.com/ru/post/1276800/

More articles:


All Articles