Gbak ultra slow when restoring on remote server ?

[Yordan Yanakiev]

Hello.

I am trying to automatize some processes, and I wish to restore a local backup on remote server. 

If i am restoring it directly locally or on the server it goes quite fast - a few seconds, but if i do it from local to the server with the follow command :

gbak -c F:\Migrator\test6_MIG.fbk remote_server_ip/3050:C:\base\test2\test2.fdb -user test2 -password test2

it taking tens of minutes for a database with size just 22 mb.

What I am doing wrong ?

[Dimitry Sibiryakov]

Yordan Yanakiev wrote 05.11.2023 11:52:
> gbak -c F:\Migrator\test6_MIG.fbk remote_server_ip/3050:C:\base\test2\test2.fdb
> -user test2 -password test2
> it taking tens of minutes for a database with size just 22 mb.
> What I am doing wrong ?

Nothing but in this situation you would better use fbsvcmgr like this:

fbsvcmgr.exe remote_server_ip/3050:service_mgr user test2 password test2
action_restore dbname C:\base\test2\test2.fdb bkp_file stdin
<F:\Migrator\test6_MIG.fbk

--
WBR, SD.

[Yordan Yanakiev]

Good lords ! This doing it almost like on my local PC ! :O

Is there something bad which can happens using  fbsvcmgr instead of gbak ?

[Dimitry Sibiryakov]

Yordan Yanakiev wrote 05.11.2023 12:16:
> Is there something bad which can happens using fbsvcmgr instead of gbak ?

No. It uses the same gbak only on remote side sending backup file there as whole.

I guess your database has a lot of BLOBS and perhaps they have small
segments. This is known problem for Firebird over high latency network.

--
WBR, SD.

[Mark Rotteveel]

Alternatively, use gbak with the `-se` switch, but in that case the
backup file must be on the remote server, not on your machine.

Mark
--
Mark Rotteveel

[Yordan Yanakiev]

Lovely ! Thank You   Dimitry Sibiryakov  and  Mark Rotteveel !!