Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgresql13 support #43

Open
forall opened this issue Oct 20, 2020 · 4 comments
Open

Postgresql13 support #43

forall opened this issue Oct 20, 2020 · 4 comments

Comments

@forall
Copy link

forall commented Oct 20, 2020

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

@ghost
Copy link

ghost commented Oct 20, 2020

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

@forall
Copy link
Author

forall commented Oct 20, 2020

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.

@ghost
Copy link

ghost commented Oct 21, 2020

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
Copy link

ghost commented Nov 2, 2020

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant