Hope this  below  mentionsed on the restrictions  to be useful on the database schema and DDL commands are not replicated 

https://www.postgresql.org/docs/current/logical-replication-restrictions.html
Another useful link on  enabling replication

https://dev.to/raselmahmuddev/how-to-set-up-postgresql-logical-replication-use-cases-and-step-by-step-guide-536b





From: Wasim Devale <[email protected]>
Sent: Saturday, June 14, 2025 8:23 PM
To: Ron Johnson <[email protected]>
Cc: pgsql-admin <[email protected]>; Pgsql-admin <[email protected]>
Subject: Re: Upgrade from 12.22 to 16

You don't often get email from [email protected]. Learn why this is important
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.

Thanks everyone.

Is there the restriction in logical replication because the database we have has all of it shown in the screenshot.


On Wed, 11 Jun, 2025, 8:59 pm Ron Johnson, <[email protected]> wrote:
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!