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@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Ireneusz Pluta > Sent: Wednesday, May 18, 2011 4:22 PM > To: Szymon Guz > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxxxx) To make > changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
