The basic setup can do that.
Configure one Postgres user to have read/write access to all database tables
Configure another Postgres user to have read-only access to all database tables
Clients that need read-only access are given the read-only user credentials while the writers are given the read-write
usercredentials.
With the way PostgreSQL works the "data directory" is the limiting factor so any multiple-server/single-data
configurationis undesirable even if it were technically possible (which I do not believe it is).
David J.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@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 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?
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make
> changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
