Re: [HELP] Reset postgres server

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: [HELP] Reset postgres server
Дата
Msg-id 9f9e27c8-4f75-8d33-c6be-8e06d86d70a1@aklaver.com
обсуждение исходный текст
Ответ на [HELP] Reset postgres server  (Praveen Kumar K S <praveenssit@gmail.com>)
Ответы Re: [HELP] Reset postgres server
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Help with plpython3u
Следующее
От: "Winfield, Steven"
Дата:
Сообщение: Parallel safety of contrib extensions