omnipitr icon indicating copy to clipboard operation
omnipitr copied to clipboard

Published 20 hours ago • verified publisher icon omniti-labs

Postgresql13 support

Open forall opened this issue 4 years ago • 4 comments

Hi Depesz, It's possible to add a support for a new postgresql-13 for omnipitr?

forall avatar Oct 20 '20 11:10 forall

Hi, I can look into it, but I don't have any system with OmniPITR now. Is there specific problem that you're seeing?

ghost avatar Oct 20 '20 12:10 ghost

The configuration between 9.3 and 13 is different. I was able to configure the replication with the script omnipitr-synch, the standby server doesnt know about the replication slot, even the manual creation doesnt work. It works only if pg_basebackup is used, which creates a configuration file for recovery. After that, the omnipitr-restore starts to work correctly and then the switch to synchronous replication. Is it possible to add a support for 13, to do not have the above workarounds.

forall avatar Oct 20 '20 19:10 forall

So, I'm not sure what would be the correct fix. The thing is that recovery.conf is gone, and instead one should put the values in postgresql.conf. Modification of postgresql.conf by omnipitr are unlikely to happen, for many reasons.

Will think some more on it, and let you know what I will decide. It will not happen soon, though. Sorry.

ghost avatar Oct 21 '20 17:10 ghost

I tried to debug the problem, but I think my knowledge of omnipitr got a bit rusty due to years of not using it.

Can you please write me:

  1. What is the exact command, with all options, that you run to create the replica?
  2. What did you have to do, after running omnipitr-synch on pg 9.3 to the replica dir? Create some file(s)? Add some config?

ghost avatar Nov 02 '20 16:11 ghost