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

QUESTION: Can I still use postgresql Physical replication after enabled pglogical? #457

Open
xytxyt opened this issue Jan 22, 2024 · 1 comment

Comments

@xytxyt
Copy link

xytxyt commented Jan 22, 2024

1: I have two main sever in different geolocation which is using pglogical for bi-directional replications
2: I want to have a full stream physical replica on each main server's location as hotstandby.
Can I still use the postgresql's built in physical replica method to do so? Or is it necessary.

I tried to do it, but somehow I did not manage to see the data in the replica postgres. So want to get some ideas/confidence to check before I dig into it.

Thanks in advance.

@aristocrates
Copy link

I have never used pglogical for BDR, but when I use it for postgres major version upgrades, usually the topology looks like:

  • Old writer
    • Old readers (physically replicating from old writer)
  • New/future writer (logically replicating from old writer)
    • New readers (physically replicating from new/future writer)

So the answer to the question of whether you can have a hot standby replicating physically from a pglogical subscriber is: yes.

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

2 participants