Re: [GENERAL] Streaming Rep 101 questions

2011-02-02 Thread Magnus Hagander
On Wed, Feb 2, 2011 at 16:52, 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... You should use 9.0.3 > 1) Is it possible to replicate one database out of many that exist in the DB > instanc

Re: [GENERAL] Streaming Rep 101 questions

2011-02-02 Thread Adrian Klaver
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?

Re: [GENERAL] Streaming Rep 101 questions

2011-02-02 Thread Ray Stell
On Wed, Feb 02, 2011 at 08:52:02AM -0700, Gauthier, Dave wrote: > I'm going to be experimenting with streaming replication using v9.0.1. Here > are a few questions I have at the onset... why not 9.0.2? > 5) Is there a step-by-step "how to" document for this? http://wiki.postgresql.org/wiki/Bi

[GENERAL] Streaming Rep 101 questions

2011-02-02 Thread Gauthier, Dave
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