David F. Skoll wrote:
>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.
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>
>