Обсуждение: [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 S Praveen Kumar
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