Skip to content

Default publication status is not preserved after backup/restore #7800

@pavel-zotov

Description

@pavel-zotov
  1. create database;
  2. enable publication:
alter database enable publication;
alter database include all to publication;
commit;
  1. check rdb$publications:
C:\FB\50SS\examples\empbuild\qa_replication>echo set list on; select * from rdb$publications; | C:\FB\50SS\isql /:C:\FB\50SS\examples\empbuild\qa_replication\DB_MAIN.FDB
Database: /:C:\FB\50SS\examples\empbuild\qa_replication\DB_MAIN.FDB, User: SYSDBA
SQL>
RDB$PUBLICATION_NAME            RDB$DEFAULT
 
RDB$OWNER_NAME                  SYSDBA
 
RDB$SYSTEM_FLAG                 1
RDB$ACTIVE_FLAG                 1
RDB$AUTO_ENABLE                 1
  1. make b/r:
C:\FB\50SS\examples\empbuild\qa_replication>C:\FB\50SS\gbak -b /:C:\FB\50SS\examples\empbuild\qa_replication\DB_MAIN.FDB stdout | C:\FB\50SS\gbak -rep stdin /:C:\FB\50SS\examples\empbuild\qa_replication\DB_MAIN.tmp
  1. check rdb$publications in just restoredDB:
C:\FB\50SS\examples\empbuild\qa_replication>echo set list on; select * from rdb$publications; | C:\FB\50SS\isql /:C:\FB\50SS\examples\empbuild\qa_replication\DB_MAIN.TMP
Database: /:C:\FB\50SS\examples\empbuild\qa_replication\DB_MAIN.TMP, User: SYSDBA
SQL>
RDB$PUBLICATION_NAME            RDB$DEFAULT
 
RDB$OWNER_NAME                  SYSDBA
 
RDB$SYSTEM_FLAG                 1
RDB$ACTIVE_FLAG                 0
RDB$AUTO_ENABLE                 0