How to Handle Sequences in Logical Bi-Directional Replication

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

 



Hi Experts,

I am reaching out to seek your guidance and expertise on handling sequences in a bi-directional logical replication setup.

I am planning to set up two PostgreSQL-16 database servers with logical bi-directional replication, using the `origin=none` configuration. In this setup, my application will be connecting to either of the database servers for DML operations.

Given this scenario, I am looking for the best practices to handle sequence values to ensure consistency and avoid conflicts. Specifically, I would like to understand:

1. How to configure sequences to avoid duplicate values in both database servers.
2. Whether there are specific settings or configurations in PostgreSQL that facilitate the management of sequences in a bi-directional replication environment.
3. Any recommendations or strategies to ensure smooth and consistent sequence management across the two servers.

I appreciate any guidance you can provide on this matter.

Thank you!

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux