Re: Postgresql 9 replication
| От | Thom Brown |
|---|---|
| Тема | Re: Postgresql 9 replication |
| Дата | |
| Msg-id | AANLkTiktceV0atpg-6UzD32kxg-K_e3kvTUd3GqoEFit@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgresql 9 replication (Machiel Richards <machielr@rdc.co.za>) |
| Список | pgsql-novice |
On 11 November 2010 11:28, Machiel Richards <machielr@rdc.co.za> wrote:
Hi
Basically we need replication to be done to a second machine in the instance that the master would fail.
I am trying to test streaming replication yes but I am not yet sure about the hot standby though. I am still awaiting confirmation on that.
I just need to get the replication working and a working document setup for it.
Thank you for the quick response by the way.
Well that wiki page I linked to should help get you up and started quickly. It covers the essentials.
You can also try: http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use
Bear in mind that if you have a pre-existing cluster you're trying to replicate, you need to perform a base backup first, which is outlined here: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#BACKUP-BASE-BACKUP
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
В списке pgsql-novice по дате отправления: