Re: initdb execution

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: initdb execution
Date: 2018-02-09 17:50:46
Message-ID: CA+bJJbwvqmM7OMyrgEhhacEOCEN4bdKHF0zhsw-psMqw_HAMFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Azim

On Fri, Feb 9, 2018 at 6:36 PM, Azimuddin Mohammed <azimeiu(at)gmail(dot)com> wrote:
> Hello I have a question regrading initdb,
> My understanding of initdb is when we execute it it will create the
> directory structure in /data.
> My question is when we run initdb when we already have a database running
> and for some reason I run this command what happens to my existing actual
> data does it get flushed out ? In that case what is the best practice here?

I think initdb refuses to run when given an existent non empty
directory, but cannot find anything in its doc page...

Ok, after a little googling I've found "initdb will refuse to run if
the data directory exists and already contains files; this is to
prevent accidentally overwriting an existing installation." in the
server setup / creating cluster docs (
https://www.postgresql.org/docs/10/static/creating-cluster.html ).

Francisco Olarte.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Azimuddin Mohammed 2018-02-09 18:06:05 Re: initdb execution
Previous Message Azimuddin Mohammed 2018-02-09 17:36:44 initdb execution

Browse pgsql-general by date

  From Date Subject
Next Message Azimuddin Mohammed 2018-02-09 18:06:05 Re: initdb execution
Previous Message Francisco Olarte 2018-02-09 17:43:30 Re: Odd behavior with 'currval'