Re: HA best pratices with postgreSQL

On Wed, Jun 18, 2008 at 8:44 PM, Albretch Mueller <lbrtchx(at)gmail(dot)com> wrote:
> ~
> I am developing a J2EE application that needs for users to only read
> DB tables. All queries are select ones, no updates, no inserts, no
> deletes for web users, so I keep this ro DB tables in certain
> partitions which I mount as ro
> ~
> For performance reasons I keet the DB in the same box as the server
> ~
> Now, the data in those tables need to actually be updated not by web
> users, but from the back end and not that often at all, say just once
> of twice a day in a totally controlled way and updates shouldn't take
> long. Just some insert stats in single tables

[very roundabout approach deleted]

> ~
> Has any of you guys heard of something like that or how to basically
> achieve the same thing by other, more standard means?

Create a user for the J2EE app, and configure that app to connect as
that user. Grant only SELECT privileges to that user on the tables it
needs to see. Create a second user for the backend app and grant it
SELECT, INSERT, UPDATE, and DELETE on those tables.

There should be no need to mess about with read-only partitions or
anything like that. SQL permissions should be all you need.

-Doug