Skip to content

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

Closed
Closed
Default publication status is not preserved after backup/restore#7800
Assignees
dyemanov
Labels
affect-version: 4.0.0affect-version: 4.0.1affect-version: 4.0.2affect-version: 4.0.3affect-version: 5.0 Beta 1affect-version: 5.0 Initialaffect-version: 5.0 RC 1affect-version: 6.0 Initialcomponent: replicationfix-version: 4.0.5fix-version: 5.0 RC 2fix-version: 6.0 Alpha 1qa: done successfullyrlsnotes60: noIntentionally not added to the Firebird 6.0 release notes.type: bug
@pavel-zotov

Description

@pavel-zotov
pavel-zotov
opened on Oct 12, 2023
  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

Metadata

Metadata