Logical Replication

/**
* Berikut ini script yang akan dijalankan di database taskhub
*/
CREATE PUBLICATION taskhub_publication
    FOR TABLE m_product,
                m_group_product,
                m_ctgr_product,
                m_sub_ctgr_product,
                m_brand,
                m_uom,
                m_product_weight_dimension,
                m_product_custom,
                m_product_consignment_supp_info,
                m_product_specs,
                m_product_assembly,
                m_product_attr_code,
                m_product_attr_comp,
                m_product_barcode,
                m_product_catalog,
                m_product_ctgr_tree,
                m_product_def_warranty,
                m_product_keyword,
                m_product_ou,
                m_product_parts,
                m_product_parts_warranty,
                m_product_serial_number,
                m_product_status,
                m_product_uom_cnv,
                m_product_vat,
                m_product_warranty,
                m_sell_price_product_for_so,
                m_device_merchant,
                m_device_merchant_ou,
                m_product_formula_recipe;

/**
* Berikut ini script yang akan dijalankan di database webclinic
*/

CREATE SUBSCRIPTION webclinic_subscription_to_taskhub
         CONNECTION 'host=192.168.0.100 port=5435 user=postgres dbname=erp_delovley_dev'
        PUBLICATION taskhub_publication;