Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication

2017-10-16 Thread Feike Steenbergen
On 11 October 2017 at 20:38, rverghese wrote: > I guess there is nothing at the database level. Although not safe (as the user can reset this parameter), you could set default_transaction_read_only for the application user. postgres=# ALTER USER jdoe IN DATABASE postgres SET default_transaction

Re: [GENERAL] Catalog table which stores database level information

2017-01-08 Thread Feike Steenbergen
On 8 January 2017 at 05:18, Adrian Klaver wrote: > > On 01/07/2017 08:12 PM, Shrikant Bhende wrote: >> >> which are applicable to the respective >> database only, where can I get the info about the values of all >> parameters specified at database level. > > > Maybe this?: > https://www.postgresql