Re: [HELP] Reset postgres server - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [HELP] Reset postgres server
Date
Msg-id d127e966-242d-f415-8799-1acc00b65d50@aklaver.com
Whole thread Raw
In response to Re: [HELP] Reset postgres server  (Praveen Kumar K S <praveenssit@gmail.com>)
List pgsql-general
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.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> 
> -- 
> *Regards,
> 
> *
> *K S Praveen Kumar
> 
> *


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Praveen Kumar K S
Date:
Subject: Re: [HELP] Reset postgres server
Next
From: Tom Lane
Date:
Subject: Re: Parallel safety of contrib extensions