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.klaver@gmail.com