Re: [HELP] Reset postgres server

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: [HELP] Reset postgres server
Дата
Msg-id d127e966-242d-f415-8799-1acc00b65d50@aklaver.com
обсуждение исходный текст
Ответ на Re: [HELP] Reset postgres server  (Praveen Kumar K S <praveenssit@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Praveen Kumar K S
Дата:
Сообщение: Re: [HELP] Reset postgres server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Parallel safety of contrib extensions