> We mounted a tmpfs filesystem on /tmp using defaults, which means the
> max size would have been 1 GB. When we restored a 9 GB database after
> four hours we received an error that there was no more space on /tmp.
> How much temporary space should a restore take?
> In firebird.conf we had TempDirectories set to /tmp;/var/tmp but it
> didn't switch to /var/tmp which had plenty of room. I think I remember
> reading that multiple directories for TempDirectories doesn't work. Is
> that correct?

Yes.

http://tracker.firebirdsql.org/browse/CORE-2422
http://tracker.firebirdsql.org/browse/CORE-2321

Although I haven't found an evidence that it is broken in your used
V1.5.1 version.

Anyway. Marked as fixed in V2.5.



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!