Re: Streaming Rep 101 questions

On 02/02/2011 07:52 AM, Gauthier, Dave wrote:
> Hi:
>
> I'm going to be experimenting with streaming replication using v9.0.1.
> Here are a few questions I have at the onset...
>
> 1) Is it possible to replicate one database out of many that exist in
> the DB instance? Or do you have to replicate them all?

It replicates the cluster.

>
> 2) Is replication transaction based? That is to say, does the act of
> replicating a transaction wait until the commit on the server side?

It is shipping WAL records, so when they are recorded they ship,
assuming streaming replication.

>
> 3) I will be replicating to a DB server 2 timezones away initially, but
> perhaps from the US-> India at some future point. Is the PG replication
> solution meant to do something like this (given sufficient bandwidth of
> course)?

Not sure.

>
> 4) The slave DB instance will also be v9.0.1 on linux, but it wil be a
> virtual machine. Do you see any problem with that?

FYI 9.0.3 was just released. I have tried it on an EC2 instance as a
test and did not see any problems.

>
> 5) Is there a step-by-step "how to" document for this?

http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial

>
> Thanks in Advance !
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com