New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Allow remote nbackup like gbak [CORE6263] #6505
Comments
Modified by: Chau Chee Yang (cheeyang)description: I have a Firebird Server install on Linux machine at service endpoint: 192.168.0.198/3050. I can use *gbak* or *service manager* to remote backup database hosted on the Linux machine in Windows client. Both *gbak* command: {code:dos} or *fbsvcmgr* works: {code:dos} It is also possible to use nbackup action in *fbsvcmgr* but backup to local file system only: {code:dos} Unfortunately, send the backup to `stdout` doesn't work: {code:dos} => I have a Firebird Server install on Linux machine at service endpoint: 192.168.0.198/3050. I can use gbak or service manager to remote backup database hosted on the Linux machine in Windows client. Both gbak command: c:\> gbak -b -user sysdba -password masterkey 192.168.0.198:employee stdout > c:\employee.fbk or fbsvcmgr works: c:\> fbsvcmgr 192.168.0.198:service_mgr user sysdba password masterkey action_backup dbname employee bkp_file stdout > "c:\employee.fbk" It is also possible to use nbackup action in fbsvcmgr but backup to local file system only: c:\> fbsvcmgr 192.168.0.198:service_mgr user sysdba password masterkey action_nbak dbname employee nbk_level 0 nbk_file /tmp/employee.nbk Unfortunately, send the backup to stdout doesn't work: c:\> fbsvcmgr 192.168.0.198:service_mgr user sysdba password masterkey action_nbak dbname employee.fdb nbk_level 0 nbk_file stdout > c:\employee.nbk |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff I'm far unsure that feature is worth using (and implementing). Yep, it appears fine at first look but it has a number of serious disadvantages: |
Commented by: Chau Chee Yang (cheeyang) Sending nbackup copy via service manager or network won't suite all use cases. But it do a number of needed cases: 1. Usually backup are perform in a high speed LAN environment, sending large database over LAN isn't an issue at all. Moreover, backup are usually perform during non peak hour. It won't bring much impact on delta files. 2. Backup is more important than restore in database management. A database administrator usually perform backup in timely fashion but restoring only perform when disaster happen. 3. If multi level backup is an issue, may be we can perform level 0 nbackup over stdout first. |
Modified by: @AlexPeshkoff |
Commented by: @AlexPeshkoff Complete duplicate of CORE4442 |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Chau Chee Yang (cheeyang)
Duplicates CORE4442
I have a Firebird Server install on Linux machine at service endpoint: 192.168.0.198/3050.
I can use gbak or service manager to remote backup database hosted on the Linux machine in Windows client.
Both gbak command:
c:\> gbak -b -user sysdba -password masterkey 192.168.0.198:employee stdout > c:\employee.fbk
or fbsvcmgr works:
c:\> fbsvcmgr 192.168.0.198:service_mgr user sysdba password masterkey action_backup dbname employee bkp_file stdout > "c:\employee.fbk"
It is also possible to use nbackup action in fbsvcmgr but backup to local file system only:
c:\> fbsvcmgr 192.168.0.198:service_mgr user sysdba password masterkey action_nbak dbname employee nbk_level 0 nbk_file /tmp/employee.nbk
time elapsed 0 sec
page reads 307
page writes 307
Unfortunately, send the backup to stdout doesn't work:
c:\> fbsvcmgr 192.168.0.198:service_mgr user sysdba password masterkey action_nbak dbname employee.fdb nbk_level 0 nbk_file stdout > c:\employee.nbk
The text was updated successfully, but these errors were encountered: