Re: question about readonly instances

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 user credentials.

With the way PostgreSQL works the "data directory" is the limiting factor so any multiple-server/single-data configuration is undesirable even if it were technically possible (which I do not believe it is).

David J.

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Ireneusz Pluta
> Sent: Wednesday, May 18, 2011 4:22 PM
> To: Szymon Guz
> Cc: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org) To make
> changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general