Hoi all,

I am unable to restore a 23GB firebird database because /tmp (2GB) is
too small (see below)... parameters from /etc/firebird2/firebird.conf:

DefaultDbCachePages = 204800
SortMemBlockSize = 16777216 (16MB)
SortMemUpperLimit = 268435456 (256MB)

I've just started another restore with:

DefaultDbCachePages = 204800
SortMemBlockSize = 268435456 (256MB)
SortMemUpperLimit = 2147483648 (2GB)

(yep plenty of RAM in this machine: 8GB; however Firebird doesn't seem
to use it all; gbak uses 1060MB which seems to be consistent with the
max amount of memory fb_inet_server allocates)

Backup: gbak -b emails.fdb /dev/stdout | gzip emails.fbk.gz
Restore: gunzip emails.fbk.gz
gbak -c emails.fbk emails.fdb

Any suggestions how to proceed (except from rearranging the partitions
on this machine and making /tmp bigger)?

cheers,
Jan


office:/lvms/db# gbak -c emails.fbk emails.fdb
gbak: ERROR: I/O error for file "/tmp/fb_sort__Ja5sOc"
gbak: ERROR: Error while trying to write to file
gbak: ERROR: No space left on device
gbak: ERROR: sort error
gbak: Exiting before completion due to errors
office:/lvms/db#