| *** KermitTheFragger has joined #ingres | 00:52 | |
| *** jennyf has joined #ingres | 00:58 | |
| *** jennyf has quit IRC | 00:59 | |
| *** gerhard has joined #ingres | 02:41 | |
| gerhard | Hi all, I have tweaked a customer's Linux / 9.2.1 / P13804 server like this http://www.ingres.com/kb/article/417655 | 02:44 |
|---|---|---|
| pboro | yup? | 02:45 |
| gerhard | ...to use compressed checkpoints. ckpdb works like expected and checkpoints are significantly smaller... | 02:45 |
| pboro | and? :D | 02:47 |
| gerhard | ...wait, customer call... | 02:47 |
| pboro | ahaha :D | 02:47 |
| gerhard | now back to topic. alterdb -delete_oldest_ckp says... | 02:51 |
| gerhard | ... checkpoint number xxx deleted... | 02:52 |
| gerhard | ... but the .gz files will stay in the checkpoint folder | 02:52 |
| pboro | ah, there's a mistake in the template then, lemme check the kbdoc whether it is correct... | 02:53 |
| pboro | hmm... apparently it's not possible to customize the deletion of checkpoint files :o | 02:56 |
| pboro | it always assumes that the name is %A | 02:56 |
| pboro | I would leave .gz off from the package name if possible | 02:58 |
| pboro | instead of... | 02:59 |
| pboro | WSDD: cd %D; GZIP="-1"; export GZIP; /bin/tar cvzf %A.gz . | 02:59 |
| pboro | use | 02:59 |
| pboro | WSDD: cd %D; GZIP="-1"; export GZIP; /bin/tar cvzf %A . | 02:59 |
| pboro | same with WRDD | 02:59 |
| pboro | not sure if it will work for tar/gz tho', lemme try that on Linux | 02:59 |
| pboro | it's bit nasty that the compression is not visible in the file extension tho :/ | 03:00 |
| gerhard | So if the .gz suffix would not be there, it would work ...? | 03:01 |
| pboro | yup | 03:01 |
| gerhard | and no possibility in the cktmpl.def to tweak alterdb behaviour? | 03:01 |
| pboro | not at least what I can see, I can check the source code too | 03:01 |
| pboro | just a sec | 03:02 |
| grantc | this is what I use on a machine: | 03:02 |
| grantc | WSDD:cd %D; /bin/tar czf %A * | 03:02 |
| grantc | WRDD:cd %D; /bin/tar zxf %A | 03:02 |
| grantc | i skip the "v" option as you don't need the output from tar | 03:03 |
| pboro | yup | 03:03 |
| pboro | the kbdoc is misleading | 03:03 |
| pboro | since it causes a situation where the checkpoints are not deleted | 03:03 |
| pboro | apparently alterdb doesn't even bother to check, whether it succeeded in deleting the file or not... | 03:04 |
| grantc | gerhard, put a comment on the document saying that alterdb -delete_oldest_ckp fails to delete | 03:05 |
| pboro | all checkpoint deletions fail | 03:05 |
| pboro | since Ingres always expects checkpoints to be named using %A pattern... | 03:05 |
| grantc | Once you log the comment i'll notify the person who published the doc to get them to correct it | 03:08 |
| pboro | there's no way to customize the filename for deletion | 03:17 |
| pboro | so best think is to leave .gz off from WSDD and WRDD... | 03:17 |
| pboro | the best thing | 03:17 |
| gerhard | I have done this in the moment | 03:18 |
| gerhard | So with your WSDD / WRDD settings ckpdb + rollforwarddb + alterdb all would work? | 03:20 |
| pboro | grantc's example work ok also for the deletion | 03:20 |
| grantc | you might want to change "*" to . | 03:21 |
| gerhard | OK, thank, will try. | 03:21 |
| gerhard | change "*" into what? into "."? | 03:21 |
| pboro | yea, that better too, if you have many tables * might cause the command parameter processing to fail because of too long argument list (* is expanded to the list of filenames) | 03:22 |
| gerhard | Yes, I can remember. I had this with another customer with many tables in the db and argument list was too lang for tar or somethins like that. | 03:22 |
| pboro | too long for the operating system :) | 03:23 |
| pboro | iirc limit for Linux is 32k chars | 03:23 |
| gerhard | OK, too lang for the OS | 03:23 |
| Vroomfondle | xargs ;) | 03:23 |
| *** atrofast has joined #ingres | 03:28 | |
| pboro | hi atrofast | 03:29 |
| atrofast | Good morning pboro :) | 03:30 |
| pboro | hehee, I'm heading for lunch :) | 03:31 |
| atrofast | I should pr obably grab some breakfast | 03:38 |
| * grantc is away: Away | 03:40 | |
| *** DarylM has quit IRC | 04:06 | |
| *** bonsaikitten has quit IRC | 04:06 | |
| *** DarylM has joined #ingres | 04:09 | |
| *** bonsaikitten has joined #ingres | 04:09 | |
| *** thiagomz has joined #ingres | 04:21 | |
| thiagomz | Guys... Morning.. I have a doubt about license... I have to migrate a legacy database from 2.6 to a Free Version... What version should I use ? Community ? | 04:23 |
| *** javahorn has joined #ingres | 04:30 | |
| *** javahorn has left #ingres | 04:30 | |
| pboro | thiagomz, jes, only the community versions are released under GPL license | 04:33 |
| thiagomz | pboro: tkz.. i will try to do this migration... | 04:33 |
| * grantc is back (gone 00:54:50) | 04:35 | |
| *** Mud has joined #ingres | 04:45 | |
| *** Dejan has joined #ingres | 05:43 | |
| *** gerhard has quit IRC | 05:44 | |
| Dejan | hi guys | 05:44 |
| *** rossand has joined #ingres | 05:46 | |
| *** ChanServ sets mode: +o rossand | 05:46 | |
| Dejan | hiya Andrey | 05:57 |
| Dejan | ups | 05:57 |
| Dejan | Andrew | 05:57 |
| *** cthibert has joined #ingres | 06:10 | |
| *** mull has joined #ingres | 06:46 | |
| *** gerhard has joined #ingres | 07:07 | |
| *** cthibert has quit IRC | 07:15 | |
| gerhard | Hi all | 07:18 |
| gerhard | pbore, grantc: we had some discussion this afternoon about cktmpl.def, you gave me a hint about using "." instead of "*" | 07:19 |
| gerhard | I have talked to Bilgihan Bircan from German tech support and he told me that usage of "." may cause problems when using table-level rollforwarddb | 07:20 |
| pboro | hmm oh, I can imagine why... | 07:26 |
| pboro | . will include files as ./file1, ./file2 instead of file1, file2... | 07:26 |
| *** gerhard has quit IRC | 08:15 | |
| *** Alex| has quit IRC | 08:20 | |
| *** Dejan has quit IRC | 09:06 | |
| *** cthibert has joined #ingres | 09:38 | |
| *** cthibert1 has joined #ingres | 10:14 | |
| *** cthibert has quit IRC | 10:16 | |
| *** grantc has quit IRC | 10:27 | |
| *** KermitTheFragger has quit IRC | 10:27 | |
| *** cthibert1 has left #ingres | 10:32 | |
| *** cthibert has joined #ingres | 10:38 | |
| *** J-eh has joined #ingres | 11:25 | |
| *** DerMeister has joined #ingres | 11:25 | |
| *** rossand has quit IRC | 11:44 | |
| *** rossand has joined #ingres | 11:45 | |
| *** ChanServ sets mode: +o rossand | 11:45 | |
| *** thiagomz has left #ingres | 13:40 | |
| *** DerMeister has quit IRC | 13:51 | |
| *** J-eh has quit IRC | 13:52 | |
| *** cthibert has left #ingres | 14:11 | |
| *** mull has quit IRC | 15:08 | |
| *** Mud has quit IRC | 15:14 | |
| *** mull has joined #ingres | 18:20 | |
| *** atrofast has quit IRC | 18:50 | |
| *** cytrinox_ has joined #ingres | 19:20 | |
| *** cytrinox has quit IRC | 19:24 | |
| *** cytrinox_ is now known as cytrinox | 19:24 | |
| *** rossand has quit IRC | 19:42 | |
| *** Alex| has joined #ingres | 22:37 | |
| *** ChanServ sets mode: +o Alex| | 22:37 | |
| *** Alex| has quit IRC | 23:28 | |
| *** Alex| has joined #ingres | 23:43 | |
| *** ChanServ sets mode: +o Alex| | 23:43 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!