Message-ID: <427F8D12.7020102@navarik.com>
Date: Mon, 09 May 2005 09:17:22 -0700
From: Louisa Thue - Navarik <lthue@navarik.com>
Organization: Navarik Corp
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: unsubscribe
References: <427A5472.8060004@roaringpenguin.com>
	<20050505174936.GA19346@dcc.uchile.cl>
	<427A60A9.7080309@roaringpenguin.com>
In-Reply-To: <427A60A9.7080309@roaringpenguin.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


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
>
>
>  
>