Re: [HELP] Reset postgres server

From: Praveen Kumar K S <praveenssit(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [HELP] Reset postgres server
Date: 2020-06-10 16:31:41
Message-ID: CANSiNp6Z-Crx9O=UKbD4zqZeHo19brXu-BEansLKOSJcvFntGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Yes, both are part of dev. Should I clean the data directory on both
servers or only on master ?

On Wed, Jun 10, 2020 at 7:50 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 6/10/20 5:33 AM, Praveen Kumar K S wrote:
> > Hello,
> >
> > I have a master and slave setup running and sometimes we have to do a
> > complete refresh on dev environments. How can I reset postgres server so
> > that it wipes out everything including WAL ? So that I configure
> > master/slave streaming replication again from scratch ? TIA.
>
> Are both servers part of the dev setup?
>
> If so would deleting the content of $PGDATA and then doing an initdb on
> it work?
> To make above easier I would keep a copies of the *.conf files where you
> could copy them back into $PGDATA after the initdb.
>
> >
> > --
> > *Regards,
> >
> > *
> > *K S Praveen Kumar
> >
> > *
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--

*Regards,*

*K S Praveen Kumar*

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-06-10 16:33:42 Re: [HELP] Reset postgres server
Previous Message Adrian Klaver 2020-06-10 16:17:43 Re: Help with plpython3u