|
29.7. Restrictions # Logical replication currently has the following restrictions or missing functionality. These might be addressed in future releases. The …
www.postgresql.org
|
|
Real-World Use Case 2: E-commerce Platforms Use Case: An e-commerce platform uses logical replication to keep the data in sync between the main database (handling customer transactions) and a separate reporting database (used for analytics).This ensures that
the system can generate real-time reports and insights without affecting the performance of the website or app.
dev.to
|
|
You don't often get email from [email protected].
Learn why this is important
|
Thanks everyone.
Is there the restriction in logical replication because the database we have has all of it shown in the screenshot.
On Wed, Jun 11, 2025 at 2:57 AM Domen Šetar <[email protected]> wrote:You can use logical replication if new version of your postgres is on other host.
Are you sure? There _shouldn't_ be any problem with replicating to a new instance on the same machine.--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobster!