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

Re: [HELP] Reset postgres server

Hello, Yes, both are part of dev. Should I clean the data directory on both servers or only on master ? On Wed, Jun 10, 2020 at 7:50 PM Adrian Klaver 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 >

Re: [HELP] Reset postgres server

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 replicatio

Re: [HELP] Reset postgres server

Providing more details. OS is Ubuntu 16.04 and postgres is installed from APT. logical and physical replication slots configured on master. No WAL archiving configured. Streaming replication is enabled on master. Slave is hot-standby On Wed, Jun 10, 2020 at 6:03 PM Praveen Kumar K S wrote: > Hel

[HELP] Reset postgres server

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. -- *Regards,* *K