<p>Right now I have a database (about 2-3 GB) in PostgreSQL, which serves as a data storage to RoR/Python LAMP-like application.</p>

<p>What kind tools are there that are simple and robust enough for replication of the main database to a second machine?</p>

<p>I looked through some packages (Slony-I and etc.) but it would be great to hear real-life stories as well.</p>

<p>Right now I'm not concerned with load balancing and etc. I am thinking about using simple Write-Ahead-Log strategy for now.</p>

[{'answer_id': 81596, 'author': 'Justin Cormack', 'author_id': 15495, 'author_profile': 'https://Stackoverflow.com/users/15495', 'pm_score': 2, 'selected': True, 'text': '<p>If you are not doing replication, Write ahead Logs are the simplest solution.</p>\n'}, {'answer_id': 4872087, 'author': 'eggie5', 'author_id': 304926, 'author_profile': 'https://Stackoverflow.com/users/304926', 'pm_score': 2, 'selected': False, 'text': '<p>If you can upgrade to pg 9 I would looking to streaming replication - very simple setup. Or if you can\'t upgrade you can just look at a hot-standby (which you can query to).</p>\n\n<p>See here: <a href="http://eggie5.com/15-setting-up-pg9-streaming-replication" rel="nofollow">http://eggie5.com/15-setting-up-pg9-streaming-replication</a></p>\n'}]
['https://Stackoverflow.com/questions/81404', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/11104/']