Search Postgresql Archives

Re: [HELP] Reset postgres server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux