Subject Re: [ib-support] Creating a multi-file database
Author Markus Ostenried
At 03:19 Friday, 21.02.2003 +0000, you wrote:
>I have a database that has reached the 2GB limit and when I try to
>add an extra file it errors saying the db has reached its 2GB limit
>use a 64-bit version, etc. How can I correct this so I can add a file?
>Where can I find the 64-bit Linux ibserver binary? It is not in any
>firebird install, do I have to compile it myself?
>Andy Kallenbach

Hi Andy,

I'm not very familiar with multiple database files but I think you can
add more files only via backup-restore. Do a backup and then on
the restore use the gbak parameters for multiple files. Have a look
at the gbak syntax.
Examples from the operations guide (page 162, available at

For restoring to multiple files:
gbak {-C|-R} [options] source dbfile1 size1 dbfile2 [size2 dbfile3 …]

For restoring from multiple files:
gbak {-C|-R} [options] source1 source2 [source3 …] dbfile

By extension, you can restore from multiple files to multiple files using
the following syntax:
gbak {-C|-R} [options] source1 source2 [source3 …] dbfile1 size1 dbfile2
[size2 dbfile3 …]

You can get the firebird versions with 64bit I/O at SourceForge:
under "firebird-linux-i386" you find downloads with "64IO" in the file names.
But I don't know what you have to do to convert your database to
64bit - I assume a backup with your current firebird version and then a
restore with the 64bit version.