Stephen Frost escribió: > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > What if you set a combination of parameters that prevents Postgres from > > starting? > > This was what I was trying to get at up-thread. Things that prevent PG > from being able to start (or, really, which cause PG to be started in a > completely different mode, ala recovery.conf) need to be able to be > modified outside of PG and therefore should, imv, be considered > configuration parameters and therefore live outside of $PGDATA (when > installed from a distro, blah, blah).
I think the way out of this situation is to have a postmaster and/or pg_ctl switch that disables reading of ALTER SYSTEM settings. Then the DBA can do ALTER SYSTEM RESET until it works again. No need to mess with "data" files. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers