Streaming Rep 101 questions

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Streaming Rep 101 questions
Date: 2011-02-02 15:52:02
Message-ID: 482E80323A35A54498B8B70FF2B87980048248A1CD@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?
2) Is replication transaction based? That is to say, does the act of replicating a transaction wait until the commit on the server side?
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)?
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?
5) Is there a step-by-step "how to" document for this?

Thanks in Advance !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray Stell 2011-02-02 16:07:31 Re: Streaming Rep 101 questions
Previous Message Wouter D'Haeseleer 2011-02-02 15:47:58 Re: Hot-Standby and sequences