Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YIKEq-0003YB-F3 for pgsql-admin@arkaria.postgresql.org; Mon, 02 Feb 2015 16:52:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YIKEp-0001uA-RZ for pgsql-admin@arkaria.postgresql.org; Mon, 02 Feb 2015 16:52:39 +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 1YIKEp-0001u4-3V for pgsql-admin@postgresql.org; Mon, 02 Feb 2015 16:52:39 +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 1YIKEk-00034A-Bb for pgsql-admin@postgresql.org; Mon, 02 Feb 2015 16:52:38 +0000 Received: from [105.237.95.49] (helo=gs0.localdomain) by smtp.mtnbusiness.co.za with esmtps (Blowfish SMTP) (envelope-from ) id 1YIKEf-000Bwb-CF for pgsql-admin@postgresql.org; Mon, 02 Feb 2015 18:52:29 +0200 Received: from [192.168.0.91] (gs01.geograph.co.za [192.168.0.91]) by gs0.localdomain (Postfix) with ESMTP id 4D950180065 for ; Mon, 2 Feb 2015 18:52:13 +0200 (SAST) Message-ID: <54CFAB3C.2020700@geograph.co.za> Date: Mon, 02 Feb 2015 18:52:12 +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: dropping all databases and starting afresh Content-Type: multipart/alternative; boundary="------------010908040802030309030801" 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. --------------010908040802030309030801 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Hi, Just joined the list, and this is first time foray into SQL databases, so apologies for the (most likely) lame questions. I have installed 9.4 with PostGIS on Ubuntu 14.10 64bit Desktop. After install I didn't like where the default databases went to, so I did: mkdir /mnt/geo_md1/postgres chown postgres:postgres /mnt/geo_md1/postgres su postgres postgres@gs01:/home/geograph$ createuser -s -d -e --replication zls postgres@gs01:/home/geograph$ pg_dropcluster –stop 9.4 main postgres@gs01:/home/geograph$ pg_createcluster --start -d /mnt/geo_md1/postgres 9.4 gisdata After fiddling for a few days, I now want to start afresh, by deleting all data and creating a new area in a different directory, but: 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). Please can someone spot my oversight. I'd like to cleanup, change the mount-point for my RAID, and then create a fresh start. Thanks in advance, Zoltan postgres@gs01:/etc$ ls -la /mnt/geo_md1/postgres total 84 drwx------ 18 postgres postgres 4096 Feb 2 18:07 . drwxrwxrwx 4 staff staff 4096 Jan 29 18:32 .. drwx------ 5 postgres postgres 4096 Jan 29 18:34 base drwx------ 2 postgres postgres 4096 Feb 1 14:13 global drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_clog drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_dynshmem drwx------ 4 postgres postgres 4096 Jan 29 18:34 pg_logical drwx------ 4 postgres postgres 4096 Jan 29 18:34 pg_multixact drwx------ 2 postgres postgres 4096 Feb 1 14:13 pg_notify drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_replslot drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_serial drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_snapshots drwx------ 2 postgres postgres 4096 Feb 1 14:24 pg_stat drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_stat_tmp drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_subtrans drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_tblspc drwx------ 2 postgres postgres 4096 Jan 29 18:34 pg_twophase -rw------- 1 postgres postgres 4 Jan 29 18:34 PG_VERSION drwx------ 3 postgres postgres 4096 Jan 29 18:34 pg_xlog -rw------- 1 postgres postgres 88 Jan 29 18:34 postgresql.auto.conf -rw------- 1 postgres postgres 129 Feb 1 14:13 postmaster.opts --------------010908040802030309030801 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Hi,
Just joined the list, and this is first time foray into SQL databases, so apologies for the (most likely) lame questions.
I have installed 9.4 with PostGIS on Ubuntu 14.10 64bit Desktop.

After install I didn't like where the default databases went to, so I did:
    mkdir /mnt/geo_md1/postgres
    chown postgres:postgres /mnt/geo_md1/postgres
    su postgres
    postgres@gs01:/home/geograph$ createuser -s -d -e --replication zls
    postgres@gs01:/home/geograph$ pg_dropcluster –stop 9.4 main
    postgres@gs01:/home/geograph$ pg_createcluster --start -d /mnt/geo_md1/postgres 9.4 gisdata
After fiddling for a few days, I now want to start afresh, by deleting all data and creating a new area in a different directory, but:

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

Please can someone spot my oversight.
I'd like to cleanup, change the mount-point for my RAID, and then create a fresh start.

Thanks in advance,
Zoltan

postgres@gs01:/etc$ ls -la /mnt/geo_md1/postgres
total 84
drwx------ 18 postgres postgres 4096 Feb  2 18:07 .
drwxrwxrwx  4 staff    staff    4096 Jan 29 18:32 ..
drwx------  5 postgres postgres 4096 Jan 29 18:34 base
drwx------  2 postgres postgres 4096 Feb  1 14:13 global
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_clog
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_dynshmem
drwx------  4 postgres postgres 4096 Jan 29 18:34 pg_logical
drwx------  4 postgres postgres 4096 Jan 29 18:34 pg_multixact
drwx------  2 postgres postgres 4096 Feb  1 14:13 pg_notify
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_replslot
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_serial
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_snapshots
drwx------  2 postgres postgres 4096 Feb  1 14:24 pg_stat
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_stat_tmp
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_subtrans
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_tblspc
drwx------  2 postgres postgres 4096 Jan 29 18:34 pg_twophase
-rw-------  1 postgres postgres    4 Jan 29 18:34 PG_VERSION
drwx------  3 postgres postgres 4096 Jan 29 18:34 pg_xlog
-rw-------  1 postgres postgres   88 Jan 29 18:34 postgresql.auto.conf
-rw-------  1 postgres postgres  129 Feb  1 14:13 postmaster.opts



--------------010908040802030309030801--