snapshot replication with pg_dump - Mailing list pgsql-hackers

From Paul Silveira
Subject snapshot replication with pg_dump
Date
Msg-id 5761329.post@talk.nabble.com
Whole thread Raw
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] extension for sql update
Next
From: Tom Lane
Date:
Subject: Re: Difference Between record and rowtype