Re: Reuse an existing slot with a new initdb

On Wed, 2020-05-13 at 06:18 -0700, Support wrote:
> On 5/8/2020 1:51 PM, Support wrote:
> > I normalized my replislots with the name of my nodes.
> > I have 2 options in my recovery script that tries first pg_basebackup
> > to recover and sync the hot standby, but unfortunately big DB fails
> > sometimes due
> > to very slow or unstable network. So my second option is to completely
> > make a new inidb and import an sql file from pg_dumpall master as it
> > takes less bytes once compressed. But I'm facing an issue with the
> > slot complaining (obviously) about the ho standby node that does not
> > match the slot identifier. So my question is simple, is there a way to
> > reinitialize the slot to not renew the identifier with the new hot
> > standby initdb?
>
> No one has an answer to my question?

That may be because your question is hard to understand.

You cannot create a standby server using "pg_dumpall", so it is
unclear what exactly you are doing here.

Also, it is not clear what error message you get.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com