snapshot replication with pg_dump

Поиск
Список
Период
Сортировка
От Paul Silveira
Тема snapshot replication with pg_dump
Дата
Msg-id 5761329.post@talk.nabble.com
обсуждение исходный текст
Список pgsql-hackers
Hello,

Does anyone have any good examples of implementing "snapshot" replication. 
I know that PostgreSQL does not have snapshot replication and that Slony-I
is the recomended replication senario but I've configured it and it seems
rather advanced for a shop that is implementing PostgreSQL for the first
time.  I have an application that will be mostly reads and snapshot
replication would probably be simple enough and would work.  I was thinking
about just using pg_dump to do the trick because the DB should not get very
large.  Does anyone have any advanced examples of doing something like this? 
Also, does anyone have any comments they'd like to share about this...

Thanks in advance,

Paul


-- 
View this message in context: http://www.nabble.com/snapshot-replication-with-pg_dump-tf2090351.html#a5761329
Sent from the PostgreSQL - hackers forum at Nabble.com.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [PATCHES] extension for sql update
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Difference Between record and rowtype