Hi, Pawel!

Paweł Sulkowski wrote:

>Hello,
>Recently I've encoutered following problem while restoring database:
>-----------
>gbak: cannot commit index RDB$PRIMARY93
>gbak: ERROR: I/O error for file "/tmp/fb_sort__GaEcCk"
>gbak: ERROR: Error while trying to write to file
>gbak: ERROR: No space left on device
>gbak: ERROR: sort error
>gbak: ERROR: action cancelled by trigger (3) to preserve data integrity
>gbak: ERROR: Cannot deactivate primary index
>gbak: Exiting before completion due to errors
>-------------
>The db I've tried to restore was so huge (3GB) that tmp partition ran
>out of space while restoring indexes.
>
>To restore database I had to umount the tmp partition (umount /tmp), run
>restore and mount tmp partition again.
>It's worth to mention that I've tmp directory on separate partition (due
>to security issues) and I've allocated only 1GB for it.
>Have you ever had similar problem?
>
>
>---
>Regards,
>Pawel Sulkowski
>
>

you don't need to umount the partition, you could change the temp file
location on firebird.conf

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br