Copy the structure using PG Dump

logical replication DDL command support nathi kartu. aapde je publisher ma structure apply karyu ae same structure subscriber ma bhi setup karsu sub database ma.

aa mate aapde pg_dump ne pipe kari sakie psql sathe jethi pub (publisher cluster) na dump ne directly execute kari sakie sub (subscriber) database ma.

tame exit command ni madad thi sauthi pehla postgres environment mathi bahar nikdi jao.

have pg_dump command ne use karo

pg_dump -t table_1 -s pub -p 5433 | psql -p 5434 sub

aa command publisher cluster na pub database na table_1 nu same structure subscriber cluster na sub database ni andar create karse.

pg_dump vagar pan aatla simple table ne aapde easily subscriber cluster ma sub database ma create kari sakta hata, pan aapde ek practice mate pg_dump no use karyo.

aapde joi sakie 6ie k aa subscriber cluster na sub database ma table_1 ma haju koi record nathi. pg_dump ni madad thi simple table j create thayu 6e, aema record insert nathi thya.

aana mate aapde publication and subscription no use karsu.