From: Louisa Thue - Navarik <lthue@navarik.com>
To: pgsql-admin@postgresql.org
Subject: unsubscribe
Date: Mon, 09 May 2005 09:17:22 -0700
Message-ID: <427F8D12.7020102@navarik.com> (raw)
In-Reply-To: <427A60A9.7080309@roaringpenguin.com>
References: <427A5472.8060004@roaringpenguin.com>
<20050505174936.GA19346@dcc.uchile.cl>
<427A60A9.7080309@roaringpenguin.com>
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
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lthue@navarik.com
Subject: Re: unsubscribe
In-Reply-To: <427F8D12.7020102@navarik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox