Re: [ADMIN] streaming replication

2011-11-30 Thread senthilnathan
Just check the following thread for more details: http://postgresql.1045698.n5.nabble.com/Timeline-Conflict-td4657611.html > We have system(Cluster) with Master replicating to 2 stand by servers. > > i.e > > M |---> S1 > > |---> S2 > > If master failed, we do a trigger file at S1 to

[ADMIN] Read Only Role

2011-11-30 Thread senthilnathan
Is there any simple way to define read only roles. Basically that user should be able to login and be able to do *select* statements alone. It should be applied for all tables in all schemas in a database. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5

Re: [ADMIN] Read Only Role

2011-12-02 Thread senthilnathan
Its a session variable. It can be reset(Read Write Mode) by the user itself -- View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5040717.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (p