Re: [HELP] Reset postgres server

On 6/10/20 9:31 AM, Praveen Kumar K S wrote:
> Hello,
>
> Yes, both are part of dev. Should I clean the data directory on both
> servers or only on master ?

Both otherwise the standby will be working with out of date data and
will not sync.

>
> On Wed, Jun 10, 2020 at 7:50 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto: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 <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
> --
> *Regards,
>
> *
> *K S Praveen Kumar
>
> *

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com