From: Zoltan Szecsei <zoltans@geograph.co.za>
To: pgsql-admin@postgresql.org
Subject: Re: dropping all databases and starting afresh
Date: Wed, 04 Feb 2015 13:23:23 +0200
Message-ID: <54D2012B.5040309@geograph.co.za> (raw)
In-Reply-To: <CAJghg4JhCsT4mcip-97+PUBn=QDi+YewhOG8n693DCmVpV91jQ@mail.gmail.com>
References: <54CFAB3C.2020700@geograph.co.za>
<CAJghg4JhCsT4mcip-97+PUBn=QDi+YewhOG8n693DCmVpV91jQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
> <mailto: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
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: zoltans@geograph.co.za
Subject: Re: dropping all databases and starting afresh
In-Reply-To: <54D2012B.5040309@geograph.co.za>
* 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