Thread: [HELP] Reset postgres server

[HELP] Reset postgres server

From
Praveen Kumar K S
Date:
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

Re: [HELP] Reset postgres server

From
Praveen Kumar K S
Date:
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

Re: [HELP] Reset postgres server

From
Adrian Klaver
Date:
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



Re: [HELP] Reset postgres server

From
Praveen Kumar K S
Date:
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

Re: [HELP] Reset postgres server

From
Adrian Klaver
Date:
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