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 <mabew...@gmail.com> wrote: > > > On 18 May 2011 22:22, Ireneusz Pluta <ipl...@wp.pl> 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 >
