Query a database specific configuration parameterDatabase Exceptions with Jetty 8.1.0 with BTMMigrating a database from one PostgreSQL server to another cleanlypostgres query performance: view vs functionpostgres_fdw and postgres version upgradeHow do I write IPv4 slash notation in IPV6How do I prevent changes to my database?PgBouncer cannot connect to serverChanging Postgres 9.6 to behave more like 9.5How does Postgresql determine sort keys into the sort node?Npgsql Timeout for simple query when run in parallel

What is GPS' 19 year rollover and does it present a cybersecurity issue?

How can I fix this gap between bookcases I made?

Can I legally use front facing blue light in the UK?

What does "rabbited" mean/imply in this sentence?

Does it makes sense to buy a new cycle to learn riding?

Why is it "Tumoren" and not "Tumore"?

Poison Arrows Piercing damage reduced to 0, do you still get poisoned?

Apex Email Validation

Is "plugging out" electronic devices an American expression?

Why isn't airport relocation done gradually?

What does 'script /dev/null' do?

Patience, young "Padovan"

Why do we use polarized capacitors?

Dual Citizen. Exited the US on Italian passport recently

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

"To split hairs" vs "To be pedantic"

Fractional alignment

What happens when a metallic dragon and a chromatic dragon mate?

Java: Is there a common interface or superclass for arrays and collections?

Does a dangling wire really electrocute me if I'm standing in water?

Explicitly parse JSON string vs JSON.deserialize

Short story: alien planet where slow students are executed

Filling an area between two curves

Extreme, but not acceptable situation and I can't start the work tomorrow morning



Query a database specific configuration parameter


Database Exceptions with Jetty 8.1.0 with BTMMigrating a database from one PostgreSQL server to another cleanlypostgres query performance: view vs functionpostgres_fdw and postgres version upgradeHow do I write IPv4 slash notation in IPV6How do I prevent changes to my database?PgBouncer cannot connect to serverChanging Postgres 9.6 to behave more like 9.5How does Postgresql determine sort keys into the sort node?Npgsql Timeout for simple query when run in parallel






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








2















I have a postgres 9.6 server with > 100 databases on it. When doing a mass-migrate, I use statements like this:



ALTER DATABASE mydatabase SET default_transaction_read_only = false;


Which works great. However, occasionally I get into a state where I'm not sure which databases are read only and which aren't. How do I query this parameter? I know how to query it server-wide:



SHOW default_transaction_read_only;


But not at a database specific level.






postgresql postgresql-9.6 read-only-database







share|improve this question




























    2















    I have a postgres 9.6 server with > 100 databases on it. When doing a mass-migrate, I use statements like this:



    ALTER DATABASE mydatabase SET default_transaction_read_only = false;


    Which works great. However, occasionally I get into a state where I'm not sure which databases are read only and which aren't. How do I query this parameter? I know how to query it server-wide:



    SHOW default_transaction_read_only;


    But not at a database specific level.






    postgresql postgresql-9.6 read-only-database







    share|improve this question
























      2












      2








      2








      I have a postgres 9.6 server with > 100 databases on it. When doing a mass-migrate, I use statements like this:



      ALTER DATABASE mydatabase SET default_transaction_read_only = false;


      Which works great. However, occasionally I get into a state where I'm not sure which databases are read only and which aren't. How do I query this parameter? I know how to query it server-wide:



      SHOW default_transaction_read_only;


      But not at a database specific level.






      postgresql postgresql-9.6 read-only-database







      share|improve this question














      I have a postgres 9.6 server with > 100 databases on it. When doing a mass-migrate, I use statements like this:



      ALTER DATABASE mydatabase SET default_transaction_read_only = false;


      Which works great. However, occasionally I get into a state where I'm not sure which databases are read only and which aren't. How do I query this parameter? I know how to query it server-wide:



      SHOW default_transaction_read_only;


      But not at a database specific level.






      postgresql postgresql-9.6 read-only-database




      postgresql postgresql-9.6 read-only-database






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 3 hours ago









      spookypeanutspookypeanut

      1185




      1185




















          1 Answer
          1






          active

          oldest

          votes


















          2














          These settings are stored in the pg_catalog.pg_db_role_setting system catalog. You can search for the databases that have the above setting like



          SELECT datname 
           FROM (SELECT datname, unnest(setconfig) AS setting
           FROM pg_db_role_setting 
           JOIN pg_database AS d ON setdatabase = d.oid) AS t 
           WHERE setting = 'default_transaction_read_only=false';





          share|improve this answer























            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "182"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234280%2fquery-a-database-specific-configuration-parameter%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            2














            These settings are stored in the pg_catalog.pg_db_role_setting system catalog. You can search for the databases that have the above setting like



            SELECT datname 
             FROM (SELECT datname, unnest(setconfig) AS setting
             FROM pg_db_role_setting 
             JOIN pg_database AS d ON setdatabase = d.oid) AS t 
             WHERE setting = 'default_transaction_read_only=false';





            share|improve this answer



























              2














              These settings are stored in the pg_catalog.pg_db_role_setting system catalog. You can search for the databases that have the above setting like



              SELECT datname 
               FROM (SELECT datname, unnest(setconfig) AS setting
               FROM pg_db_role_setting 
               JOIN pg_database AS d ON setdatabase = d.oid) AS t 
               WHERE setting = 'default_transaction_read_only=false';





              share|improve this answer

























                2












                2








                2







                These settings are stored in the pg_catalog.pg_db_role_setting system catalog. You can search for the databases that have the above setting like



                SELECT datname 
                 FROM (SELECT datname, unnest(setconfig) AS setting
                 FROM pg_db_role_setting 
                 JOIN pg_database AS d ON setdatabase = d.oid) AS t 
                 WHERE setting = 'default_transaction_read_only=false';





                share|improve this answer













                These settings are stored in the pg_catalog.pg_db_role_setting system catalog. You can search for the databases that have the above setting like



                SELECT datname 
                 FROM (SELECT datname, unnest(setconfig) AS setting
                 FROM pg_db_role_setting 
                 JOIN pg_database AS d ON setdatabase = d.oid) AS t 
                 WHERE setting = 'default_transaction_read_only=false';






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 3 hours ago









                dezsodezso

                22.6k116097




                22.6k116097



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Database Administrators Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid …


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234280%2fquery-a-database-specific-configuration-parameter%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    -

                    Popular posts from this blog

                    acmart: Multiple authors: all with same affiliation, one author an additional affiliationHow to Write Names of Multiple Authors with Shared Affiliation in ACM 2017 Template?Multiple authors with different primary affiliation, but same additional affiliationSame affiliation for all authors without extra packagesIOS-Book-Article.cls: one author with multiple affiliationacmart: Shared Author AffiliationMultiple authors with different primary affiliation, but same additional affiliationAuthor affiliation with only 1 authorAdding Multiple Authors with Different Affiliation in LaTeX ArticleLaTeX: Multiple authors stays on same lineHow to Label Multiple Authors with Same DescriptionHow to make two authors use the same affiliationTwo authors with same affiliation on finished front page

                    Image
                    Check if two datetimes are between two others What happens when a metallic dragon and a chromatic dragon mate? Need help identifying/translating a plaque in Tangier, Morocco Piano - What is the notation for a double stop where both notes in the double stop are different lengths? What to wear for invited talk in Canada Pristine Bit Checking Lied on resume at previous job Does it makes sense to buy a new cycle to learn riding? Re-submission of rejected manuscript without informing co-authors Where to refill my bottle in India? How to answer pointed "are you quitting" questioning when I don't want them to suspect Is it wise to focus on putting odd beats on left when playing double bass drums? Copycat chess is back "My colleague's body is amazing" Why is the design of haulage companies so “special”? Information to fellow intern about hiring? How would photo IDs work for shapeshifters? Crop image to path created in TikZ? Does a...
                    Read more

                    How to write “ä” and other umlauts and accented letters in bibliography?Accents in BibTeXSorting references with special characters alphabeticallyUse ae ligature in bibliographyEastern European nameInverted circumflex in BibTexBibTex, non-ascii initials and nameptr fproblems with accent in LatexHow to add a Ø to my bibliography from Jabref?References without accentsTroubles when trying to cite St“omer-Verlet in ”title" field of a bib entryComprehensive list of accented charactersHow to type the letter “i” with two dots (diaeresis) in math mode?Problem with glossary text and accented lettersSpecial character in bibliographyAccented letters, Unicode and LaTeX accentsHow to stop natbib from modifying bibliography styleCitation of a paper with non-standard characters by BibtexWrite accented characters to file using writeHow to group the bibliography alphabetically, if some surnames start with “accented” characters?How can I automatically capitalize significant words in my bibliography?

                    Image
                    Information to fellow intern about Hiring? Are tax years 2016 & 2017 back taxes deductible for tax year 2018? Why a const reference doesn't extend the life of temporary object passed via function? Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941? I see my dog run How to avoid repetitive long generic constraints in Rust How can I fix this gap between bookcases I made? What are these boxed doors outside store fronts in New York? How would photo IDs work for shapeshifters? What does "enim et" mean? What is the meaning of "of trouble" in the following sentence? How to determine if window is maximised or minimised from bash script Calculate Levenshtein distance between two strings in Python Why do we use polarized capacitors? How to answer pointed "are you quitting" questioning when I don't want them to suspect Extreme, but not acceptable situation and I can't start the work tomorrow...
                    Read more

                    Problem using RevTeX4-1 with “! Undefined control sequence. @bibitemShut”

                    Image
                    What is the difference between lands and mana? Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size? Did the UK lift the requirement for registering SIM cards? Why do Radio Buttons not fill the entire outer circle? How much of a Devil Fruit must be consumed to gain the power? Confused about Cramer-Rao lower bound and CLT Can I cause damage to electrical appliances by unplugging them when they are turned on? Is there a RAID 0 Equivalent for RAM? Make a Bowl of Alphabet Soup Non-trope happy ending? Will the Sticky MAC access policy prevent unauthorized hubs from connecting to a network? Is this toilet slogan correct usage of the English language? What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them? Has the laser at Magurele, Romania reached a tenth of the Sun's power? Do we have to expect a queue for the shuttle from Watford Junction to Harry Po...
                    Read more