Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YIysP-0005Pz-Cf for pgsql-admin@arkaria.postgresql.org; Wed, 04 Feb 2015 12:16:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YIysO-0000nk-DF for pgsql-admin@arkaria.postgresql.org; Wed, 04 Feb 2015 12:16:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YIysN-0000nd-5z for pgsql-admin@postgresql.org; Wed, 04 Feb 2015 12:16:11 +0000 Received: from smtp02-smtpout03.jh.za.mtnbusiness.net ([41.181.159.139]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YIysH-0003Cf-Kp for pgsql-admin@postgresql.org; Wed, 04 Feb 2015 12:16:08 +0000 Received: from [105.236.250.101] (helo=gs0.localdomain) by smtp.mtnbusiness.co.za with esmtps (Blowfish SMTP) (envelope-from ) id 1YIysA-00059G-VQ for pgsql-admin@postgresql.org; Wed, 04 Feb 2015 14:15:59 +0200 Received: from [192.168.0.91] (gs01.geograph.co.za [192.168.0.91]) by gs0.localdomain (Postfix) with ESMTP id E8E35180060 for ; Wed, 4 Feb 2015 14:15:40 +0200 (SAST) Message-ID: <54D20D6C.9050504@geograph.co.za> Date: Wed, 04 Feb 2015 14:15:40 +0200 From: Zoltan Szecsei Organization: Geograph (Pty) Ltd User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: dropping all databases and starting afresh References: <54CFAB3C.2020700@geograph.co.za> <54D2012B.5040309@geograph.co.za> In-Reply-To: Content-Type: multipart/alternative; boundary="------------090607070703020808030905" X-Spam-Score: -1.1 (-) X-Spam-Report: BAYES_00=-1.9,HTML_MESSAGE=0.001,RDNS_NONE=0.793, * -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% * [score: 0.0000] * 0.0 HTML_MESSAGE BODY: HTML included in message * 0.8 RDNS_NONE Delivered to internal network by a host with no rDNS X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------090607070703020808030905 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit OK - cool - thanks for the tips. Regards, Zoltan On 02/04/2015 02:02 PM, Matheus de Oliveira wrote: > > On Wed, Feb 4, 2015 at 9:23 AM, Zoltan Szecsei > wrote: > > In the end I just rm -rf'd the files, as suggested by others on > this list. I was initially concerned about that simple approach, > as I figured that many postgres conf files will still point to > that deleted area - but as postgres will not run again until I do > an initdb -D command, it (should) goes to follow that those conf > files will then be correctly updated. > > > Yeah, I understand your concern, and I do agree. On installation from > packages on Debian/Ubuntu-like, you should keep with the cluster > management tools provided, like pg_createcluster instead of initdb, > pg_ctlcluster instead of pg_ctl, pg_dropcluster instead of rm, and so on. > > Regards, > -- > Matheus de Oliveira > Analista de Banco de Dados > Dextra Sistemas - MPS.Br nível F! > www.dextra.com.br/postgres > --------------090607070703020808030905 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit OK - cool - thanks for the tips.
Regards,
Zoltan
On 02/04/2015 02:02 PM, Matheus de Oliveira wrote:

On Wed, Feb 4, 2015 at 9:23 AM, Zoltan Szecsei <zoltans@geograph.co.za> wrote:
In the end I just rm -rf'd the files, as suggested by others on this list. I was initially concerned about that simple approach, as I figured that many postgres conf files will still point to that deleted area - but as postgres will not run again until I do an initdb -D command, it (should) goes to follow that those conf files will then be correctly updated.

Yeah, I understand your concern, and I do agree. On installation from packages on Debian/Ubuntu-like, you should keep with the cluster management tools provided, like pg_createcluster instead of initdb, pg_ctlcluster instead of pg_ctl, pg_dropcluster instead of rm, and so on.

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres


--------------090607070703020808030905--