MaterializedPostgreSQL pg_publication_tables have equal name in column pubname for two db in one cluster.

Describe what's wrong

I have cluster clichouse. I create db via MaterializedPostgreSQL(master db name = 'db_test') with name my_db_1 with default table titles, then i attach tables catalog1, and catalog2. Then i create second db my_db_2 with equal master postgres db with table titles. then i going to postgres and do select * from pg_publication_tables ;, i see that my_db_2 rewrite all publications of my_db_1, and in the end i have only one publication with name db_test_ch_publication | public | titles, so then i got stop replication of my_db_1.

Maybe you can add perfix for publications name?

expected behavior

The two database (mydb_1, and mydb_2) with engine MaterializedPostgreSQL, and with equals parameters(host, login, password, dbname), have different name of publications in master postgres, copied and then replicating as normal.

System properties

master version: PostgreSQL 14.11 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20231014) 13.2.1 20231014, 64-bit

slave version:

VERSION_FULL	ClickHouse 24.8.4.13
VERSION_DESCRIBE	v24.8.4.13-stable
VERSION_INTEGER	24008004
SYSTEM	Linux
VERSION_GITHASH	53195bc189b587afaabc52c4ca765aa54beea84f
VERSION_REVISION	54492
BUILD_TYPE	RelWithDebInfo
SYSTEM_PROCESSOR	x86_64
CMAKE_VERSION	3.30.2
C_COMPILER	/usr/bin/clang-18
C_COMPILER_VERSION	18.1.8
CXX_COMPILER	/usr/bin/clang++-18
CXX_COMPILER_VERSION	18.1.8
C_FLAGS	 --gcc-toolchain=./cmake/linux/../../contrib/sysroot/linux-x86_64 -fdiagnostics-color=always -Xclang -fuse-ctor-homing -Wno-enum-constexpr-conversion  -gdwarf-aranges -pipe -mssse3 -msse4.1 -msse4.2 -mpclmul -mpopcnt -fasynchronous-unwind-tables -ffile-prefix-map=.=. -ftime-trace -falign-functions=32 -mbranches-within-32B-boundaries -ffp-contract=off  -fdiagnostics-absolute-paths -Wframe-larger-than=65536 -Weverything -Wpedantic -Wno-zero-length-array -Wno-c++98-compat-pedantic -Wno-c++98-compat -Wno-c++20-compat -Wno-sign-conversion -Wno-implicit-int-conversion -Wno-implicit-int-float-conversion -Wno-ctad-maybe-unsupported -Wno-disabled-macro-expansion -Wno-documentation-unknown-command -Wno-double-promotion -Wno-exit-time-destructors -Wno-float-equal -Wno-global-constructors -Wno-missing-prototypes -Wno-missing-variable-declarations -Wno-padded -Wno-switch-enum -Wno-undefined-func-template -Wno-unused-template -Wno-vla -Wno-weak-template-vtables -Wno-weak-vtables -Wno-thread-safety-negative -Wno-enum-constexpr-conversion -Wno-unsafe-buffer-usage -Wno-switch-default -O2 -g -DNDEBUG -O3 -g  -flto=thin -fwhole-program-vtables -fno-pie
CXX_FLAGS	 --gcc-toolchain=./cmake/linux/../../contrib/sysroot/linux-x86_64 -fdiagnostics-color=always -Xclang -fuse-ctor-homing -Wno-enum-constexpr-conversion -fsized-deallocation  -gdwarf-aranges -pipe -mssse3 -msse4.1 -msse4.2 -mpclmul -mpopcnt -fasynchronous-unwind-tables -ffile-prefix-map=.=. -ftime-trace -falign-functions=32 -mbranches-within-32B-boundaries -ffp-contract=off  -fdiagnostics-absolute-paths -fstrict-vtable-pointers -Wall -Wextra -Wframe-larger-than=65536 -Weverything -Wpedantic -Wno-zero-length-array -Wno-c++98-compat-pedantic -Wno-c++98-compat -Wno-c++20-compat -Wno-sign-conversion -Wno-implicit-int-conversion -Wno-implicit-int-float-conversion -Wno-ctad-maybe-unsupported -Wno-disabled-macro-expansion -Wno-documentation-unknown-command -Wno-double-promotion -Wno-exit-time-destructors -Wno-float-equal -Wno-global-constructors -Wno-missing-prototypes -Wno-missing-variable-declarations -Wno-padded -Wno-switch-enum -Wno-undefined-func-template -Wno-unused-template -Wno-vla -Wno-weak-template-vtables -Wno-weak-vtables -Wno-thread-safety-negative -Wno-enum-constexpr-conversion -Wno-unsafe-buffer-usage -Wno-switch-default -O2 -g -DNDEBUG -O3 -g  -flto=thin -fwhole-program-vtables -fno-pie
LINK_FLAGS	 --gcc-toolchain=./cmake/linux/../../contrib/sysroot/linux-x86_64 --ld-path=/usr/bin/ld.lld-18 -Wl,--no-export-dynamic -Wl,--gc-sections -Wl,--build-id=sha1 -Wl,--time-trace -no-pie -Wl,-no-pie  -flto=thin -fwhole-program-vtables
BUILD_COMPILE_DEFINITIONS	
USE_EMBEDDED_COMPILER	ON
USE_GLIBC_COMPATIBILITY	ON
USE_JEMALLOC	1
USE_ICU	1
USE_H3	1
USE_MYSQL	1
USE_RDKAFKA	1
USE_CAPNP	1
USE_BASE64	1
USE_HDFS	1
USE_SNAPPY	1
USE_PARQUET	1
USE_PROTOBUF	1
USE_BROTLI	1
USE_SSL	1
OPENSSL_VERSION	
OPENSSL_IS_BORING_SSL	
USE_VECTORSCAN	1
USE_SIMDJSON	1
USE_ODBC	1
USE_GRPC	1
USE_LDAP	1
TZDATA_VERSION	2024a
USE_KRB5	1
USE_FILELOG	1
USE_BZIP2	1
USE_AMQPCPP	1
USE_ROCKSDB	1
USE_NURAFT	1
USE_NLP	1
USE_LIBURING	1
USE_SQLITE	1
USE_LIBPQXX	1
USE_AZURE_BLOB_STORAGE	1
USE_AWS_S3	1
USE_CASSANDRA	1
USE_YAML_CPP	1
USE_SENTRY	1
USE_DATASKETCHES	1
USE_AVRO	1
USE_ARROW	1
USE_ORC	1
USE_MSGPACK	1
USE_QPL	1
USE_QATLIB	1
GIT_HASH	53195bc189b587afaabc52c4ca765aa54beea84f
GIT_BRANCH	HEAD
GIT_DATE	2024-09-05 15:11:08 +0000
GIT_COMMIT_SUBJECT	Merge pull request #68699 from ClickHouse/backport/24.8/68412

Thanks a lot for your job!