Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YIy3l-0003eF-7e for pgsql-admin@arkaria.postgresql.org; Wed, 04 Feb 2015 11:23:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YIy3k-0007M2-OA for pgsql-admin@arkaria.postgresql.org; Wed, 04 Feb 2015 11:23:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YIy3j-0007JL-Cr for pgsql-admin@postgresql.org; Wed, 04 Feb 2015 11:23:51 +0000 Received: from smtp02-smtpout03.jh.za.mtnbusiness.net ([41.181.159.139]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YIy3d-0002If-Rz for pgsql-admin@postgresql.org; Wed, 04 Feb 2015 11:23:49 +0000 Received: from [105.236.250.101] (helo=gs0.localdomain) by smtp.mtnbusiness.co.za with esmtps (Blowfish SMTP) (envelope-from ) id 1YIy3Y-000BQq-3E for pgsql-admin@postgresql.org; Wed, 04 Feb 2015 13:23:40 +0200 Received: from [192.168.0.91] (gs01.geograph.co.za [192.168.0.91]) by gs0.localdomain (Postfix) with ESMTP id F2375180060 for ; Wed, 4 Feb 2015 13:23:23 +0200 (SAST) Message-ID: <54D2012B.5040309@geograph.co.za> Date: Wed, 04 Feb 2015 13:23:23 +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> In-Reply-To: Content-Type: multipart/alternative; boundary="------------090204090209080801030201" 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. --------------090204090209080801030201 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 02/04/2015 12:07 PM, Matheus de Oliveira wrote: > > On Mon, Feb 2, 2015 at 2:52 PM, Zoltan Szecsei > wrote: > > neither: > > postgres@gs01:/etc$ pg_dropcluster –-stop 9.4 gisdata > Usage: /usr/bin/pg_dropcluster [--stop] > > nor > > postgres@gs01:/etc$ pg_dropcluster –-stop 9.4 postgres > Usage: /usr/bin/pg_dropcluster [--stop] > > works. > I've done no createdb commands, so dopdb shouldn't be what I want > for this cleanup (I'd think). > > > If you copied+pasted the exact command you run, then no wonder it is > wrong. If you look closer you are not calling "--stop", the first dash > is another character (not minus/hyphen character). One is "EN DASH" > with code 0xe28093 [1], while the correct one is "HYPHEN-MINUS" with > code 0x2d [2]. > AWESOME !! Well spotted. I must have copy&pasted it from one of the online pdf manuals. 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. Big thanks to all who contributed. Kind regards, Zoltan --------------090204090209080801030201 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
On 02/04/2015 12:07 PM, Matheus de Oliveira wrote:

On Mon, Feb 2, 2015 at 2:52 PM, Zoltan Szecsei <zoltans@geograph.co.za> wrote:
neither:
postgres@gs01:/etc$ pg_dropcluster –-stop 9.4 gisdata
Usage: /usr/bin/pg_dropcluster [--stop] <version> <cluster>
nor
postgres@gs01:/etc$ pg_dropcluster –-stop 9.4 postgres
Usage: /usr/bin/pg_dropcluster [--stop] <version> <cluster>
works.
I've done no createdb commands, so dopdb shouldn't be what I want for this cleanup (I'd think).

If you copied+pasted the exact command you run, then no wonder it is wrong. If you look closer you are not calling "--stop", the first dash is another character (not minus/hyphen character). One is "EN DASH" with code 0xe28093 [1], while the correct one is "HYPHEN-MINUS" with code 0x2d [2].

AWESOME !!
Well spotted.
I must have copy&pasted it from one of the online pdf manuals.

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.

Big thanks to all who contributed.

Kind regards,
Zoltan



--------------090204090209080801030201--