Subject | RE: [firebird-support] endless backup |
---|---|
Author | Alan McDonald |
Post date | 2005-02-24T09:34:57Z |
> Hello,gbak runs in it's own transaction context, whatever you do to the server of
>
> I have got few quite basic questions about usage of gbak backup utility.
>
> gbak is version LI-V1.5.1.4500 Firebird 1.5
>
> 1)
> Is it safe (regarding to database being backed up) to interrupt
> gbak by signalling? Is SIGINT fine?
> If I do this, fbserver thread that worked for gbak seems to continue
> in its work. Is there a way to stop this thread safely at runtime?
> If no, is it safe to restart the database server in such a state?
> In case of safe restart, will I get rid of this post-mortem
> activity permanently?
the thread running gbak will have the same effect as stopping any other
transaction.
in the case of gbak, it's a read only transaction over the database so
stopping it or the server mid stream will have very litle risk of corrupting
the db.
>no you can name a firebird database as you like - any extension is fine
> 2)
> Has database filename extension ".gdb" any specific influence on gbak?
> Could gbak behave differently if the extension was ".fdb" or
> whatever else?
>
> 3)again - it runs in it's own transaction context so you can run as many gbaks
> Is it safe to run 2 instances of gbak on the same database?
> Perhaps when I find out that backup with garbage collecting
> will take hours, can I safely run another "gbak -g ..." ?
>
> TIA, Ferda
>
simultaneously as you like or as the server resources permit.
just remember - quorted from Helen recently:
"Yup. Do the backup *without* the -g switch, so that you clean out your
garbage. I know this switch is confusing, but -g means "no garbage
collection". All that deleting will have accumulated a mountain. Allow
plenty of time - it will take hours."
Alan