Alvaro Herrera wrote: > Connect in standalone mode? Does not work. Tom Lane replied with the only thing that does work, which we independently discovered about 30 seconds before hearing from Tom. :-) The solution is to modify the PostgreSQL source code to skip the check, and run the modified binary in standalone mode just to reset the datallowconn flag to true. Once we did that, we quit and started the normal server to complete the maintenance work. I recommend having a postgres single-user-mode command-line option to disable the check, with a suitably stern warning in the man page not to use it. :-) Regards, David.
