On Thu, Jan 11, 2018 at 10:20 PM, Melvin Davidson <melvin6...@yahoo.com> wrote:
> > > > *PgAdminIII did/does have the facility to edit the postgresql.conf & > pg_hba.conf.However, as David G. Johnston pointed out, it was limited to > editing _local_ versionsof those files. * > No it wasn't. There were separate menu options for remote editing... > > > > > > > > *>i don't recommend doing this by hand, ...That statement implies that you > feel that using a GUI will protect you from makingerrors. That is untrue. > If you use a GUI to change the authentication method in the pg_hba.conf > (not to mention other critical parameters), you could easily lock out many > users upon reloading/restart. Likewise, the same applies for changing > valuesin postgresql.conf. Simply having an easy way to change values does > not mean you will* > *be protected from setting them too high(or wrong). EG: setting work_mem > to 1GB will be * > *very bad.* > > *It is better to learn and understand WHY you need to change values, than > just havingan easy way to do so.* > ...but you are otherwise correct - it was potentially dangerous and you could easily break a system doing it. It was also quite fragile, as it required the adminpack package which it used to completely re-write the config files, which had to be manually parsed and re-generated in order to (attempt) to keep any comments etc. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company