Re: [firebird-support] Re: Changing the database owner in Firebird 3

2019-12-04 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Re: Changing the database owner in Firebird 3

2019-12-04 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

[firebird-support] Re: Changing the database owner in Firebird 3

2019-12-04 Thread kga...@dgcs.pl [firebird-support]
Carlos, thank you for the information. Indeed, in our case we have to change the owner of the existing database objects. Is there any tool/script/etc., which could be used to either change the owner of the existing database objects or pump the data into the new database? Kind

Re: [firebird-support] Changing the database owner in Firebird 3

2019-12-04 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Changing the database owner in Firebird 3

2019-12-04 Thread kga...@dgcs.pl [firebird-support]
Thank you for the response. We will try backup-restore and let you know. We have to change the owner of database, because a user, who had been using SYSDBA account, has decided to create and use another account due to security reasons. Kind regards, Krzysztof Gałka

Re: [firebird-support] Changing the database owner in Firebird 3

2019-12-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.12.2019 12:11, kga...@dgcs.pl [firebird-support] wrote: > Is there any other way to change the database owner in Firebird 3? Backup-restore. Could you provide an example of practical purpose for this action? -- WBR, SD.

[firebird-support] Changing the database owner in Firebird 3

2019-12-04 Thread kga...@dgcs.pl [firebird-support]
Hello, in Firebird 2.5, there was a possibility to change the database owner by updating values in the system tables (RDB$...). However, in Firebird 3, updating the system tables is not allowed. Is there any other way to change the database owner in Firebird 3? Kind regards,

Re: [firebird-support] Re: Nagle Algorithm

2019-12-04 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
You didn't say what version of Firebird you are using. If it is not 3.x, you can expect very bad performance transferring data over WAN. FB 3 implemented changes in the wire protocol making things much faster in high latency networks. The only remaining "problem" is if you need to transfer blobs

Re: [firebird-support] Re: Nagle Algorithm

2019-12-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.12.2019 05:22, nvat...@yahoo.com [firebird-support] wrote: > Am I missing something here or what is slowing down these firebird > communications??? Firebird uses protocol with full acknowledgment. In combination with badly designed application the result is predictable. -- WBR, SD.

Re: [firebird-support] Nagle Algorithm

2019-12-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-03 23:20, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 03.12.2019 22:28, nvat...@yahoo.com [firebird-support] wrote: >> I see that NoNagle can be Enabled on the server by setting True in the >> Firebird Server Config file. > >On contrary, it can be Disabled

Re: [firebird-support] installing firebird 2.5 on Suse linux enterprise 12.1

2019-12-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.12.2019 04:16, Ferry Sumendap ferry_new2...@yahoo.com [firebird-support] wrote: > Is there any step installation I missed ? Installing and running xinetd. > How execute firebird server to run manually ? There is no way for Firebird Classic Server 2.5. -- WBR, SD.