[firebird-support] Firebird : find strign in all database

Hi all, I am looking for a procedure or a function to find a stirng in my database I have a DB with 200 tables and want to find a specific string (record) in a my DB I don't know the name of table / field. Thanks for any help

[firebird-support] find a string records in all my tables

Hi all, I am looking for a procedure or a function to find a stirng in my database I have a DB with 200 tables and want to find a specific string (record) in a my DB I don't know the name of table / field. Thanks for any help

Re: [firebird-support] Help: firebird and apache Processes doesn't die

<> The pseudo table MON$ATTACHMENTS will tell you. Regards Paul

Re: [firebird-support] Updating Firebird version and database compatibility issue

2017-01-10 5:23 GMT-03:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] : > > > On 9-1-2017 18:08, Leandro Melo de Sales leandromsa...@gmail.com > [firebird-support] wrote: > > Scenario: My customer has a Linux CentOS 5.7 with Firebird TCP/IP server > >

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

Dimitry, Thanks for your reply. The problem of backing up using gbak is that it is not possible to run incremental backups, right? By the way, i'm using nbackup 0-level per month and 1-level everyday, replacing the 1-level everyday by the new one. In this approach, if I run nbackup recover using

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

10.01.2017 16:30, Leandro Melo de Sales leandromsa...@gmail.com [firebird-support] wrote: > The database file size is huge as 56Gb. Is there any limitation of Firebird > as the size of > the database increase? No limitations at this level. 56Gb is quite small database. > any suggestion for

[firebird-support] Firebird database size is becoming huge (56Gb)

Hi folks, My customer asked to create a solution for backing up his Firebird database. I have developed a solution using nbackup and send a tar bz2 file of the NBK to an S3 bucket in the Amazon. The database file size is huge as 56Gb. Is there any limitation of Firebird as the size of the

Re: [firebird-support] Help: firebird and apache Processes doesn't die

Paul, thanks for your answer. I see two firebird processes, and I'm sure there is no real user connected, as apache server is down. How could I find out whether CACHE_WRITER and GARBAGE_COLLECTOR processes are active ? Thanks Aldo El 10/01/17 a las 11:50, 'Paul Beach'

Re: [firebird-support] Help: firebird and apache Processes doesn't die

Dimitry, thanks for your answer. I'll follow your advice. Nevertheless, its still a bit strange that, when more connections are established, memory keeps increasing up to nearly all the RAM available ( 4 GBytes ). My database size is only 150 MBytes. Shouldn't page cache and

Re: [firebird-support] Help: firebird and apache Processes doesn't die

<> SuperServer wil hold cached data as long as any connections exist. Only when the last "real" user disconnects from the database will the cache be cleared. Which two users are still connected to the database? CACHE WRITER and GARBAGE COLLECTOR? If so then these should also finish with the

Re: [firebird-support] Help: firebird and apache Processes doesn't die

Hi again, I tested it many times: after stopping Apache server, the quantity of Firebird processes decrease to 2, but the memory isn't released. Running "top -u firebird" command displays a lot of memory ( nearly 2 GBytes ) consumed by Firebird. Is this a bug in Firebird Super Server or

Re: [firebird-support] Updating Firebird version and database compatibility issue

On 9-1-2017 18:08, Leandro Melo de Sales leandromsa...@gmail.com [firebird-support] wrote: > Scenario: My customer has a Linux CentOS 5.7 with Firebird TCP/IP server > version LI-V2.5.2.26540 Firebird 2.5. I want to update his Linux server > to Ubuntu latest version. My customer uses a