Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Tom Lane
Adrian Klaver writes: > On 04/25/2016 05:29 PM, Stephen Frost wrote: >> It's not an option *to* initdb, it's an option which is used *by* >> initdb. > That really did not clear things up:) Does it mean that you can > pre-populate the $DATA directory with a postgresql.conf that has > allow_syste

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread David G. Johnston
On Monday, April 25, 2016, Melvin Davidson wrote: > > > On Mon, Apr 25, 2016 at 8:41 PM, Adrian Klaver > wrote: > >> On 04/25/2016 05:29 PM, Stephen Frost wrote: >> >>> * Melvin Davidson (melvin6...@gmail.com >>> ) wrote: >>> Hmmm, if you go back a few comments, you will note that per initd

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Melvin Davidson
On Mon, Apr 25, 2016 at 8:41 PM, Adrian Klaver wrote: > On 04/25/2016 05:29 PM, Stephen Frost wrote: > >> * Melvin Davidson (melvin6...@gmail.com) wrote: >> >>> Hmmm, if you go back a few comments, you will note that per initdb --help >>> there is no such option available. >>> >> >> It's not an o

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Adrian Klaver
On 04/25/2016 05:29 PM, Stephen Frost wrote: * Melvin Davidson (melvin6...@gmail.com) wrote: Hmmm, if you go back a few comments, you will note that per initdb --help there is no such option available. It's not an option *to* initdb, it's an option which is used *by* initdb. That really did

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Stephen Frost
* Melvin Davidson (melvin6...@gmail.com) wrote: > Hmmm, if you go back a few comments, you will note that per initdb --help > there is no such option available. It's not an option *to* initdb, it's an option which is used *by* initdb. I'm afraid I'm done with this particular discussion. Hopefull

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Melvin Davidson
On Mon, Apr 25, 2016 at 8:18 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, April 25, 2016, Stephen Frost wrote: > >> Melvin, >> >> * Melvin Davidson (melvin6...@gmail.com) wrote: >> > So in essence "*Allows modification of the structure of system tables" >> does >> > NOT

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread David G. Johnston
On Monday, April 25, 2016, Stephen Frost wrote: > Melvin, > > * Melvin Davidson (melvin6...@gmail.com ) wrote: > > So in essence "*Allows modification of the structure of system tables" > does > > NOT allow _structural_ changes (probably only dml changes) > > and the documentation should be chang

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Stephen Frost
Melvin, * Melvin Davidson (melvin6...@gmail.com) wrote: > So in essence "*Allows modification of the structure of system tables" does > NOT allow _structural_ changes (probably only dml changes) > and the documentation should be changed to clarify. That would imply that other changes are acceptab

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Melvin Davidson
On Mon, Apr 25, 2016 at 8:05 PM, Stephen Frost wrote: > * Melvin Davidson (melvin6...@gmail.com) wrote: > > Then could you please clarify exactly what structural mods are permitted > by > > *"* > > *Allows modification of the structure of system tables" ?* > > I would say, in short, those modific

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Stephen Frost
* Melvin Davidson (melvin6...@gmail.com) wrote: > Then could you please clarify exactly what structural mods are permitted by > *"* > *Allows modification of the structure of system tables" ?* I would say, in short, those modifications which are implemented by PG developers who know what's safe to

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Tom Lane
"David G. Johnston" writes: > On Monday, April 25, 2016, Melvin Davidson wrote: >> I need clarification on allow_system_table_mods parameter > If it's going to prevent the action it should be able to do so without > crashing the server..and I doubt it's intended to be opinionated aside from > co

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Melvin Davidson
On Mon, Apr 25, 2016 at 7:57 PM, Stephen Frost wrote: > David, Melvin, > > * David G. Johnston (david.g.johns...@gmail.com) wrote: > > On Monday, April 25, 2016, Melvin Davidson wrote: > > > I need clarification on allow_system_table_mods parameter > > > Per the documentation: > > > *Allows modi

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Melvin Davidson
On Mon, Apr 25, 2016 at 7:50 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, April 25, 2016, Melvin Davidson wrote: > >> I need clarification on allow_system_table_mods parameter >> Per the documentation: >> *Allows modification of the structure of system tables.* This is

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Stephen Frost
David, Melvin, * David G. Johnston (david.g.johns...@gmail.com) wrote: > On Monday, April 25, 2016, Melvin Davidson wrote: > > I need clarification on allow_system_table_mods parameter > > Per the documentation: > > *Allows modification of the structure of system tables.* This is used by > > init

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread David G. Johnston
On Monday, April 25, 2016, Melvin Davidson wrote: > I need clarification on allow_system_table_mods parameter > Per the documentation: > *Allows modification of the structure of system tables.* This is used by > initdb. This parameter can only be set at server start. > > However, attempting to mo

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Melvin Davidson
On Mon, Apr 25, 2016 at 4:26 PM, Melvin Davidson wrote: > >my previous answer did not make sense as postgresql.conf is set up by > initdb > Yeah, that kind of puzzles me too. > > >-O allow_system_table_mods = on > Thanks, I'll give that a try and create a new cluster, then get back to > you

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Melvin Davidson
>my previous answer did not make sense as postgresql.conf is set up by initdb Yeah, that kind of puzzles me too. >-O allow_system_table_mods = on Thanks, I'll give that a try and create a new cluster, then get back to you afterwards. On Mon, Apr 25, 2016 at 4:05 PM, Adrian Klaver wrote: >

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Adrian Klaver
On 04/25/2016 09:30 AM, Melvin Davidson wrote: I need clarification on allow_system_table_mods parameter Per the documentation: *Allows modification of the structure of system tables.* This is used by initdb. This parameter can only be set at server start. A millisecond after hitting enter I re

Re: [GENERAL] Clarify "allow_system_table_mods"

2016-04-25 Thread Adrian Klaver
On 04/25/2016 09:30 AM, Melvin Davidson wrote: I need clarification on allow_system_table_mods parameter Per the documentation: *Allows modification of the structure of system tables.* This is used by initdb. This parameter can only be set at server start. I am reading the above as meaning that