Re: dropping all databases and starting afresh

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: Zoltan Szecsei <zoltans(at)geograph(dot)co(dot)za>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: dropping all databases and starting afresh
Date: 2015-02-04 12:02:06
Message-ID: CAJghg4KMgC9JxXhsvysacd8q6iud1u2_X88xF7+YTTjmFo73BQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Feb 4, 2015 at 9:23 AM, Zoltan Szecsei <zoltans(at)geograph(dot)co(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Zoltan Szecsei 2015-02-04 12:15:40 Re: dropping all databases and starting afresh
Previous Message Zoltan Szecsei 2015-02-04 11:23:23 Re: dropping all databases and starting afresh