On 19.03.24 16:24, vignesh C wrote:
The problem with this failure is that standby has been promoted
already and we will have to re-create the physica replica again.
If you are not planning to have the checks for name length, this could
alternatively be fixed by including database id also while querying
pg_subscription like below in set_replication_progress function:
appendPQExpBuffer(str,
"SELECT oid FROM pg_catalog.pg_subscription \n"
"WHERE subname = '%s' AND subdbid = (SELECT oid FROM
pg_catalog.pg_database WHERE datname = '%s')",
dbinfo->subname,
dbinfo->dbname);
Yes, this is more correct anyway, because subscription names are
per-database, not global. So you should be able to make
pg_createsubscriber use the same subscription name for each database.
