snapshot replication with pg_dump

From: Paul Silveira <plabrh1(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: snapshot replication with pg_dump
Date: 2006-08-11 12:23:25
Message-ID: 5761329.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-08-11 12:33:16 Re: Difference Between record and rowtype
Previous Message Peter Eisentraut 2006-08-11 11:53:21 Re: [PATCHES] extension for sql update