gstat is not included in the Firebird release I downloaded:

C:\Firebird>dir
 Volume in drive C has no label.
 Volume Serial Number is FA80-0C12

 Directory of C:\Firebird

09/29/2014  02:25 PM    <DIR>          .
09/29/2014  02:25 PM    <DIR>          ..
09/29/2014  01:16 PM           105,717 Firebird-2.1-ErrorCodes.pdf
09/29/2014  01:06 PM         1,159,676 Firebird-2.5-LangRef-Update.pdf
09/29/2014  01:06 PM           245,583 Firebird-2.5-QuickStart.pdf
09/29/2014  01:00 PM        10,467,361 Firebird-2.5.3.26778-0_Win32.zip
09/29/2014  01:01 PM        12,259,685 Firebird-2.5.3.26778-0_x64.zip
09/29/2014  01:00 PM         6,973,448 Firebird-2.5.3.26778_0_Win32.exe
09/29/2014  12:58 PM        10,282,876 Firebird-2.5.3.26778_0_x64.exe
09/29/2014  01:14 PM            85,664 Firebird-fbmgr.pdf
09/29/2014  01:16 PM            71,972 Firebird-File-Metadata-Security.pdf
09/29/2014  01:12 PM           133,557 Firebird-gbak.pdf
09/29/2014  01:15 PM            90,111 Firebird-Generator-Guide.pdf
09/29/2014  01:13 PM           133,621 Firebird-gfix.pdf
09/29/2014  01:11 PM            89,144 Firebird-gsec.pdf
09/29/2014  01:14 PM            47,968 Firebird-gsplit.pdf
09/29/2014  01:13 PM            90,958 Firebird-gstat.pdf
09/29/2014  01:11 PM           225,636 Firebird-isql.pdf
09/29/2014  01:12 PM           102,220 Firebird-nbackup.pdf
09/29/2014  01:15 PM           309,643 Firebird-Null-Guide.pdf
09/29/2014  01:14 PM            39,907 Firebird-on-Ubuntu.pdf
09/29/2014  01:13 PM            56,914 Firebird-shell-scripts.pdf
09/29/2014  01:15 PM           109,705 MSSQL-to-Firebird.pdf
09/29/2014  01:16 PM           195,585 Using-Firebird_(wip).pdf
              22 File(s)     43,276,951 bytes
               2 Dir(s)  697,431,232,512 bytes free

C:\Firebird>gstat 192.168.1.252:/bfl/smtbdb/customer
'gstat' is not recognized as an internal or external command,
operable program or batch file.

It has been 20+ years since I have done much with Unix.  If you can tell me the directory Firebird is installed in on Linux, I will run the gstat on the Linux server.  Otherwise, it will take me a while to locate it.... which I will start now.

Thanks,
Jack


C:\Firebird>

 

> The databases are backed up between midnight and 6 am when no one is
> using them. However, the databases are still open in multiple
> programs. The backup is:
>
> C:\"program files"\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA
> -pas masterkey 192.168.1.252:/bfl/smtbdb/customer
> C:\backups\Buford\Thursday\customer.bak
>
> and the restore is:
>
> C:\"program files"\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA
> -pas masterkey C:\backups\Buford\Thursday\customer.bak
> localhost:c:\temp\customer

What is the result of gstat -h on the production database?

Thomas

> Jack
>
>
>
> On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' ts@...
> [firebird-support] wrote:
>>
>>
>> > The databases reside on a Linux Mint server, but we back them up to a
>> > Windows 7 system. Both are running the same release of Firebird. We
>> > use Linux as the server because Linux is far more reliable than Windows
>> > for everything, but it is the only Linux computer we use. Everything
>> > else is Windows because of other software we run. So, to back up the
>> > databases, we put the backups on a Windows 7 computer, blandly assuming
>> > it is just a file that can be restored by the same program that backed
>> > it up, gbak on Windows 7.
>>
>> You mean a physical file copy from Linux to Windows while the database
>> is in use?
>>
>> > We had the same problem two years ago, and it never got resolved, it
>> > just disappeared, so we assumed we had done something wrong and were no
>> > longer doing whatever that was.
>>
>> And you don't call a different gbak version by accident, e.g. due to a
>> set PATH environment variable etc.?
>>
>> Regards,
>> Thomas
>>
>> > Jack
>> >
>> > On 6/11/2015 3:02 AM, Thomas Steinmaurer ts@...
>> > [firebird-support] wrote:
>> >>
>> >> Hello,
>> >>
>> >> > We have backed up our databases daily for two years using
>> Firebird 2.52
>> >> > Superserver and its associated gbak. We now need to restore one
>> of the
>> >> > databases and gbak fails to do the restore, giving the following
>> error:
>> >> >
>> >>
>> >> [snip gbak output]
>> >>
>> >> > gbak: ERROR:action cancelled by trigger (3) to preserve data
>> integrity
>> >> > gbak: ERROR: table/procedure has non-SQL security class defined
>> >> > gbak:Exiting before completion due to errors
>> >> >
>> >> >
>> >> > We have no procedures defined in or for our database. It appears gbak
>> >> > has restored the database except for something at the end. The
>> database
>> >> > is working correctly every day. Is this copy of the database backup
>> >> toast?
>> >> >
>> >> >
>> >> > Should we be using a different backup tool like nbackup? Can we use
>> >> > Interbase gbak to recreate the database?
>> >> >
>> >> >
>> >> > We are backing up our databases on Windows 7 using 2.52 Superserver.
>> >> > The databases are on a Linux Mint server.
>> >>
>> >> I'm confused. The databases are hosted on Linux (InterBase or
>> Firebird?)
>> >> but you are running a backup from Win7?
>> >>
>> >> You asked something similar > 2 years ago:
>> >> http://comments.gmane.org/gmane.comp.db.firebird.user/7145
>> >>
>> >> --
>> >> With regards,
>> >> Thomas Steinmaurer
>> >> http://www.upscene.com/
>> >>
>> >> Professional Tools and Services for Firebird
>> >> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>> >>
>> >> > However, when we are trying
>> >> > to do the restore, we are restoring it to a directory on Windows 7
>> >> > because we don't trust restoring it over the currently running
>> >> > database. So, the backup and restore are both on the same Windows 7
>> >> > computer using the same 2.52 Superserver.
>> >> >
>> >> >
>> >> > We need some data from the database from yesterday, so we just
>> wanted to
>> >> > restore that long enough to pull the data. The table we want,
>> ON_ORDER,
>> >> > appears to have been restored but we cannot open the restored
>> database
>> >> > to access it.
>> >> >
>> >> >
>> >> > Help?
>> >> >
>> >> >
>> >> > ------------------------------------
>> >> > Posted by: Jack Mason <jackmason@...>
>> >> > ------------------------------------
>> >> >
>> >> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> >> >
>> >> > Visit http://www.firebirdsql.org and click the Documentation item
>> >> > on the main (top) menu. Try FAQ and other links from the left-side
>> >> menu there.
>> >> >
>> >> > Also search the knowledgebases at
>> >> http://www.ibphoenix.com/resources/documents/
>> >> >
>> >> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> >> > ------------------------------------
>> >> >
>> >> > Yahoo Groups Links
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> > --
>> > "Our Constitution was made only for a moral and religious people. It is
>> > wholly inadequate to the government of any other." -- John Adams, Oct.
>> > 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>> >
>>
>>
>
> --
> "Our Constitution was made only for a moral and religious people. It is
> wholly inadequate to the government of any other." -- John Adams, Oct.
> 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>

--
"Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other." -- John Adams, Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18