Re: question about readonly instances

[Terry Schmitt <terry.schmitt@xxxxxxxxx>]

I have no idea what type of storage that you are using, but we utilize 
NetApp storage and use Flexclones to create multiple read-only copies of
 a "master" database. The flexclone takes seconds to configure and 
essentially only consume delta space. Works great so far.


Terry

On Wed, May 18, 2011 at 1:33 PM, Szymon Guz <mabewlun@xxxxxxxxx> wrote:

On 18 May 2011 22:22, Ireneusz Pluta <ipluta@xxxxx> wrote:

W dniu 2011-05-18 13:21, Szymon Guz pisze:

Hi,
I've got a question about quite a strange configuration.
I was asked if we can have one storage, with one data directory where one postgresql instance writes data, and many other instances read those.
Is that possible without any replication and copying data?

Why do they think they need that?

They've got some quite nice and huge storage and it would be nice to use it from many different machines running postgreses.

Another option is Oracle which can do that. Replicating data to another directory is not an option, not for this amount of data and the way of loading/using data they need.

I've always done that using replication to different machines and running there Postgres on each, I've never heard of this kind of using Postgres. That's why I think this is "strange".

regards

Szymon