Re: [GENERAL] question about readonly instances

2011-05-19 Thread Szymon Guz
On 19 May 2011 04:08, Craig Ringer cr...@postnewspapers.com.au wrote: On 05/19/2011 04:33 AM, Szymon Guz wrote: On 18 May 2011 22:22, Ireneusz Pluta ipl...@wp.pl mailto:ipl...@wp.pl wrote: W dniu 2011-05-18 13:21, Szymon Guz pisze: Hi, I've got a question about quite a

Re: [GENERAL] question about readonly instances

2011-05-19 Thread John R Pierce
On 05/18/11 11:39 PM, Szymon Guz wrote: thanks for the answer. It is not a problem to have 3 oracle instances, in fact there will be hundreds of them probably, but could also be hundreds of Postgres instances :) do you have any idea how EXPENSIVE 100s of Oracle RAC nodes are annually? to

Re: [GENERAL] question about readonly instances

2011-05-19 Thread Szymon Guz
On 19 May 2011 09:05, John R Pierce pie...@hogranch.com wrote: On 05/18/11 11:39 PM, Szymon Guz wrote: thanks for the answer. It is not a problem to have 3 oracle instances, in fact there will be hundreds of them probably, but could also be hundreds of Postgres instances :) do you have

Re: [GENERAL] question about readonly instances

2011-05-19 Thread John R Pierce
I have no idea how expensive it is, but fortunately that's not my problem :) I was only asked about the possibility of running Postgres that way. And by the way: how expensive is that? something like US$23000 per CPU core for the RAC option for Oracle Enterprise. so a 100 node cluster

Re: [GENERAL] question about readonly instances

2011-05-19 Thread Craig Ringer
On 05/19/2011 03:25 PM, John R Pierce wrote: I have no idea how expensive it is, but fortunately that's not my problem :) I was only asked about the possibility of running Postgres that way. And by the way: how expensive is that? something like US$23000 per CPU core for the RAC option for

Re: [GENERAL] question about readonly instances

2011-05-19 Thread Albe Laurenz
Szymon Guz wrote: 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

[GENERAL] question about readonly instances

2011-05-18 Thread Szymon Guz
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? regards Szymon

Re: [GENERAL] question about readonly instances

2011-05-18 Thread Vick Khera
On Wed, May 18, 2011 at 7:21 AM, Szymon Guz mabew...@gmail.com wrote: 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

Re: [GENERAL] question about readonly instances

2011-05-18 Thread Ireneusz Pluta
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

Re: [GENERAL] question about readonly instances

2011-05-18 Thread Szymon Guz
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

Re: [GENERAL] question about readonly instances

2011-05-18 Thread David Johnston
...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Ireneusz Pluta Sent: Wednesday, May 18, 2011 4:22 PM To: Szymon Guz Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] question about readonly instances W dniu 2011-05-18 13:21, Szymon Guz pisze: Hi, I've

Re: [GENERAL] question about readonly instances

2011-05-18 Thread Terry Schmitt
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

Re: [GENERAL] question about readonly instances

2011-05-18 Thread Craig Ringer
On 05/19/2011 04:33 AM, Szymon Guz wrote: On 18 May 2011 22:22, Ireneusz Pluta ipl...@wp.pl mailto: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,