[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 <praveenssit@gmail.com>
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.

--

*Regards,*

*K S Praveen Kumar*

--

*Regards,*

*K S Praveen Kumar*

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

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

--

*Regards,*

*K S Praveen Kumar*

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