Search Postgresql Archives

Reuse an existing slot with a new initdb

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

Thanks

David





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux