{"repo":"pierreforstmann/pg_readonly","free":true,"listed":false,"github":"https://github.com/pierreforstmann/pg_readonly","clone":"git clone https://github.com/pierreforstmann/pg_readonly.git","description":"PostgreSQL extension to set all cluster databases read only.","language":"C","stars":19,"topics":["c","postgresql","postgresql-extension"],"license":null,"category":"databases-storage","readme_excerpt":"pg readonly pg readonly is a PostgreSQL extension which allows to set all cluster databases read only. Note that version 1.0.4 is fixing a important bug regarding DML in CTE. Installation Installation with GNU/Linux package For example install RPM package with: sudo dnf install -y pg readonly 17 Extension must be loaded at server level with shared preload libraries parameter: shared preload libraries = 'pg readonly' Stop and restart PostgreSQL instance and create the extension with: create extension pg readonly; Compiling, installing and testing with PGXS This extension can be built using the standard PGXS infrastructure for example with pgenv : git clone https://github.com/pierreforstmann/pg readonly.git cd pg readonly export USE PGXS=1 make make install make installcheck Compiling, installing and testing without PGXS You can also build the extension without PGXS in the PostgreSQL source code tree: cd contrib git clone https://github.com/pierreforstmann/pg readonly.git cd pg readonly make Running make check is going to start a temporary instance used for running the test using only built binaries: make check Running make installcheck is going to use an existing PostgreSQL instance with installed binaries. You need to set shared preload libraires for this instance (see above): make install make installcheck Validated PostgreSQL versions This extension has been validated with PostgreSQL 9.5, 9.6, 10, 11, 12, 13, 14, 15, 16, 17, 18 and 19 beta 1. Usage pg readonly has no specif","default_branch":null,"files":null,"tree":[],"storefront":"/r/pierreforstmann","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pierreforstmann/pg_readonly/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}