2010-10-07T00:17:57 *** StephenGWills has quit IRC 2010-10-07T00:30:08 *** pmplett has quit IRC 2010-10-07T00:46:50 *** StephenGWills has joined #evergreen 2010-10-07T01:11:49 *** pmplett has joined #evergreen 2010-10-07T01:39:35 *** pmplett has quit IRC 2010-10-07T02:02:40 *** mrpeters-isl has quit IRC 2010-10-07T02:25:37 *** pmplett has joined #evergreen 2010-10-07T02:59:22 *** phasebb has quit IRC 2010-10-07T03:08:14 *** pmplett has quit IRC 2010-10-07T03:35:55 *** atz has joined #evergreen 2010-10-07T03:39:02 *** atz_ has quit IRC 2010-10-07T04:16:46 *** zigo-_- has quit IRC 2010-10-07T05:02:18 *** pmplett has joined #evergreen 2010-10-07T08:07:08 *** dbs has quit IRC 2010-10-07T08:32:57 *** Melissa has joined #evergreen 2010-10-07T08:36:24 *** mrpeters-isl has joined #evergreen 2010-10-07T08:38:50 *** mck9 has left #evergreen 2010-10-07T08:38:58 *** mck9 has joined #evergreen 2010-10-07T08:54:24 *** dbs has joined #evergreen 2010-10-07T08:54:24 *** dbs has joined #evergreen 2010-10-07T08:58:46 *** Dyrcona has joined #evergreen 2010-10-07T09:09:29 morning everyone. is anyone out there doing any sort of database replication for a seperate reports database? i had some high hopes that i could use the hot standby feature in postgres until i found out its not supported until version 9.0! :( 2010-10-07T09:10:16 several EG sites use slony for that purpose 2010-10-07T09:11:46 ok. we're having a LOT of downtime lately due to reports that seem to turn into never ending SELECT's and really would like to get a seperate reports only server up to avoid this 2010-10-07T09:12:38 i was looking at pgpool II with master/slave replication but Slony looks interesting too 2010-10-07T09:14:28 gmcharlt: slony seems to be the standard evergreen option 2010-10-07T09:14:36 s/gmcharlt/mrpeters-isl/ 2010-10-07T09:14:40 too tired, sorry 2010-10-07T09:14:47 ok! 2010-10-07T09:14:48 thanks guys 2010-10-07T09:15:17 dbs: wow! news! ;) 2010-10-07T09:16:23 gmcharlt: yeah, I'm a total broken record. sorry (again) 2010-10-07T09:16:31 congrats on the 3.2.0 release candidate, btw 2010-10-07T09:16:34 thanks 2010-10-07T09:18:09 * dbs peeks at http://ask.debian.net/ - built on shapado - maybe something to put into the web/communication committee's hopper to chew on? 2010-10-07T09:22:44 heh - I see that a question from somebody trying to install Koha is on the top of the list 2010-10-07T09:23:49 dbs: the interface looks interesting; I think the trick is getting enough people actively answering questions 2010-10-07T09:24:59 gmcharlt: yes, actively + usefully 2010-10-07T09:25:37 darn, I can't just write a script to supply '42' in response to every question? 2010-10-07T09:26:11 Although responses like "I have no clue, that interface is really confusing and I don't see any docs for it anywhere" could be interpreted as useful in a broader sense, I suppose 2010-10-07T09:28:07 moof. 2010-10-07T09:30:03 *** Melissa has left #evergreen 2010-10-07T09:30:17 wow that shapado site looks quite a bit like stackexchange. 2010-10-07T09:30:21 aha: http://blog.ricodigo.com/2009/9/27/shapado-a-foss-replacement-for-stackoverflow/shapado 2010-10-07T09:30:29 mrpeters-isl: re replication, yes, don't use pgpool's replication, it's not smart enough, but you can use it all day long for load balancing 2010-10-07T09:31:03 and even during nights, too! *rimshot(* 2010-10-07T09:31:30 :) 2010-10-07T09:31:47 *** kmlussier has joined #evergreen 2010-10-07T09:31:51 (two drums and a cymbal fall off a cliff...) 2010-10-07T09:32:14 jeff: yes, I imagine that's the point. stackexchange-ish but with code and data under the control of the community 2010-10-07T09:32:57 dbs: one of the comments on that blog post was somewhat critical, calling it "free-as-in-autocracy". i was amused. :) 2010-10-07T09:33:23 (though i'm not sure it's accurate) 2010-10-07T09:34:10 jeff: I'm just throwing out another option, in the past we've been criticized as not being approachable because we don't have web forums, this seems like a possible option for a middle way 2010-10-07T09:34:38 the stackexchange model does have a lot going for it over web forums. 2010-10-07T09:35:11 Or we could just put it all of Facebook. 2010-10-07T09:35:18 :P 2010-10-07T09:35:44 fwiw, there's another library community using the stackexchange framework here: http://answers.unshelved.com/ 2010-10-07T09:36:05 that is stackexchange incubated through their area51 site, not shapado. 2010-10-07T09:37:02 like apache's incubator, there are stages... they're in "bootstrap" mode. shapado would probably be the better option for evergreen at this point. 2010-10-07T09:43:47 heh. never good to get high load alerts from servers you've almost completely forgotten about. 2010-10-07T09:43:59 starved for attention. 2010-10-07T09:44:59 dbs: A few days ago I got a high load alert for a server I haven't logged into for years 2010-10-07T09:48:23 * tsbere wants to know why his email address is still in that server, given that he hasn't had login access to it for years 2010-10-07T09:49:37 *** collum has joined #evergreen 2010-10-07T09:51:29 tsbere: you're its last hope, obi-wan tsbere 2010-10-07T09:51:58 dbs: I don't have login access due to a desire to shut it off. For good. :P 2010-10-07T10:11:57 * tsbere starts work on circ matchpoint docs 2010-10-07T10:12:33 tsbere++ 2010-10-07T10:20:00 @later tell bshum thanks for your questions about the draft rules of governance; I was beginning to wonder if anyone had even read them 2010-10-07T10:20:00 dbs: The operation succeeded. 2010-10-07T10:28:09 docs++ 2010-10-07T10:28:12 tsbere++ 2010-10-07T10:50:28 *** mrpeters-isl has quit IRC 2010-10-07T11:01:46 MEMEBERSHIP => Meme-bership? or Me Me bership? # All about me. 2010-10-07T11:02:44 atz++ 2010-10-07T11:07:54 *** Melissa has joined #evergreen 2010-10-07T11:07:57 who do I petition for a membership nomination? ;) 2010-10-07T11:13:02 eeevil: I asked this question yesterday and on Friday, but I don't think you noticed, so I'll ask again. 2010-10-07T11:13:27 eeevil: Is r18151 going to be backported from trunk to rel_2_0? 2010-10-07T11:13:41 It was, apparently, backported to rel_1_6. 2010-10-07T11:14:38 Dyrcona: no, it will not 2010-10-07T11:14:58 because it's a significant new feature and schema change it will be 2.1 and 1.6.2 2010-10-07T11:15:13 ok. thanks. 2010-10-07T11:15:48 It looks like something I'd want to use. :) 2010-10-07T11:18:44 Dyrcona: and you'll be able to ;) 2010-10-07T11:21:21 *** moodaepo has quit IRC 2010-10-07T11:21:21 *** youdonotexist has joined #evergreen 2010-10-07T11:33:56 *** youdonotexist_ has joined #evergreen 2010-10-07T11:35:07 *** youdonotexist has quit IRC 2010-10-07T11:38:38 *** youdonotexist_ has quit IRC 2010-10-07T12:03:07 *** brendan2 has joined #evergreen 2010-10-07T12:10:47 *** parsr has joined #evergreen 2010-10-07T12:10:56 *** r123 has joined #evergreen 2010-10-07T12:14:46 *** b_bonner has joined #evergreen 2010-10-07T12:16:25 *** mrpeters-isl has joined #evergreen 2010-10-07T12:17:16 upgraded a test system from Ubu 8.04 to 10.04; but it knocked out my pgl install; now have PG 8.4 installed, started, then stopped to update *.conf files to match our system including custom db data directory; now restart of Mr Postgres gives me two errors: mydirectory/xx is "not a valid data directory" and mydirectory/PG_VERSION is missing. Tips for the newbie errors? 2010-10-07T12:19:47 parsr: could be a mess. here's a few thigns to check... 2010-10-07T12:19:59 parsr: do you now have two installs of postgres? 2010-10-07T12:20:32 parsr: you can't just copy an 8.3 data directory and use it with 8.4 without upgrading it -- but since postgres can't even find your data dir, we're not there yet. 2010-10-07T12:21:02 parsr: sounds like you've pointed postgres at a directory that either doesn't exist or doesn't contain PG_VERSION, which it expects to find. double-check your config changes? 2010-10-07T12:21:51 *** jamesrf has joined #evergreen 2010-10-07T12:22:23 parsr: the value for data_directory should point to a directory (mine does not have a trailing slash) such as the default /var/lib/postgresql/8.3/main (for 8.3 on ubuntu hardy) 2010-10-07T12:22:59 jeff: correct -- just 8.4 install; not copying any EG data from previous versions; working to start EG database from scratch 2010-10-07T12:23:05 parsr: that dir needs to have proper permissions also, in my case owner:group postgres:postgres and perms 0700 2010-10-07T12:23:17 *** pmplett has quit IRC 2010-10-07T12:23:39 parsr: aha. then in that case you'll need to create the data directory -- you can either move the contents of the system-installed directory, or... 2010-10-07T12:24:20 *** pmplett has joined #evergreen 2010-10-07T12:24:31 parsr: see here for directions on creating a new cluster in your preferred location on disk: http://www.postgresql.org/docs/8.4/interactive/creating-cluster.html 2010-10-07T12:26:05 parsr: there may be gotchas on charset/locale with calling initdb in this way -- you may want to copy/move the system installed default, or consult your previous install's charset/locale -- it may or may not have any impact when you create/restore your eg db. 2010-10-07T12:27:55 jeff: thanks -- will try both your suggestions ; data directory previous created with good perms for postgres user so copy or initdb should work. will try after munch time..Thx! 2010-10-07T12:35:57 *** b_bonner_phone has joined #evergreen 2010-10-07T12:40:34 *** b_bonner has left #evergreen 2010-10-07T12:58:49 *** parsr has quit IRC 2010-10-07T13:17:04 *** moodaepo has joined #evergreen 2010-10-07T13:18:42 *** bshum has joined #evergreen 2010-10-07T13:23:19 *** eby has quit IRC 2010-10-07T13:23:25 *** brian_f has joined #evergreen 2010-10-07T13:35:09 *** b_bonner_phone has quit IRC 2010-10-07T13:39:27 *** b_bonner_phone has joined #evergreen 2010-10-07T13:42:39 *** brian_f has quit IRC 2010-10-07T13:49:33 *** brian_f has joined #evergreen 2010-10-07T13:53:20 *** b_bonner_phone has quit IRC 2010-10-07T13:56:04 *** Dyrcona has quit IRC 2010-10-07T14:00:04 *** parsr has joined #evergreen 2010-10-07T14:06:13 jeff: your initdb suggestion worked, then I ran into "server.crt: No such file or directory" error which in turn could be solved by either running these openssl steps: http://tinyurl.com/3464h4b ; or in my case creating links for server.crt and server.key to /etc/ssl/certs/ssl-cert-snakeoil.pem and /etc/ssl/private/ssl-cert-snakeoil.key respectively. Back up now. Thanks for the tips! 2010-10-07T14:08:00 parsr: your domain looks a little fishy 2010-10-07T14:08:13 "haddock.kyleandjessica.com" eh? 2010-10-07T14:11:08 dbs: yes, the things we have to do to access IRC from my employer's network! Note to employer: please open port for me and it's ok to log/review my posts (yes, I'm trying to work here!) 2010-10-07T14:11:29 parsr++ 2010-10-07T14:11:42 to those using slony: i've got the two servers talking to each other, but need some information on what tables need to be replicated 2010-10-07T14:14:49 mrpeters-isl: all of them? there's a script in support-scripts IIRC that will give you a list of tables and sequences that need to be added to the replication set 2010-10-07T14:16:11 eeevil: ok. I had assumed it would be all of them, but just checking. thanks for the clue I'll look there 2010-10-07T14:17:45 just not the tables in the replication setup schema ... that would be bad 2010-10-07T14:18:00 i'm not eeing anything obvious in there....do you have any idea which script it might be? 2010-10-07T14:18:08 looking in the 1.6.0.0 source tree 2010-10-07T14:19:13 Open-ILS/examples/build-eg-replication.sh in the trunk tree I'm looking at 2010-10-07T14:19:45 atz++ user group wishlist, ha :) 2010-10-07T14:20:06 eeevil: ok ill have a look 2010-10-07T14:29:45 eeevil: "NUMNODES" = server + # hosts or just # of hosts 2010-10-07T14:30:21 I don't recall 2010-10-07T14:30:40 ok 2010-10-07T14:31:07 dbs++ atz++ gmcharlt++ bshum++ # governance discussion 2010-10-07T14:43:15 gmcharlt: Hmm, have you had a chance to poke at pushing that fix you alluded to for the 1.6.0.x upgrades? 2010-10-07T14:43:32 bshum: not yet, should have a moment later today 2010-10-07T14:43:58 gmcharlt: Cool deal. Will keep my eyes open and test it out. Thanks! 2010-10-07T14:44:45 eeevil: do you happen to know what verison of Postgres this was written for? I'm getting some "No function matches" errors 2010-10-07T14:45:28 ERROR: function array_accum(text) does not exist as well 2010-10-07T14:47:21 mrpeters-isl: did you just use a blank database? 2010-10-07T14:47:32 mrpeters-isl: that's created by 002.functions.aggregate.sql ... perhaps you need to point it at your evergreen db 2010-10-07T14:48:00 dbs: no, i'm using the evergreen db, though, i don't ever recall applying 002.functions... after restoring it from a snapshot 2010-10-07T14:48:20 sounds like the restore might have gone poorly 2010-10-07T14:48:24 mrpeters-isl: you don't have to after restoring from a snapshot 2010-10-07T14:48:35 ok then something else is wrong 2010-10-07T14:48:37 if, by snapshot, you mean a backup 2010-10-07T14:48:43 yeah, a backup 2010-10-07T14:49:24 ok...i see my problem here 2010-10-07T14:49:36 postgres user is looking at the wrong cluster 2010-10-07T14:54:42 eeevil++ # pinpointing the problem immediately 2010-10-07T14:58:47 FWIW: passing "-d evergreen" into the embedded query you have in the script helped...not sure if thats just my setup or that's how it should read 2010-10-07T14:59:28 mrpeters-isl: PGDATABASE=evergreen on the command line should be enough 2010-10-07T14:59:50 ok, i had set that in my .bashrc so perhaps i had a typo 2010-10-07T15:03:06 if it's su'ing with a - or something, that won't work, obviously 2010-10-07T15:03:30 eeevil: thanks for taking the time to create this script...its quite helpful 2010-10-07T15:08:18 np ... no promises that it delivers 100% coverage. it's meant to be a starting point and an example 2010-10-07T15:08:51 just experimenting righ tnwo 2010-10-07T15:11:48 * LBA1 sneaking away 2010-10-07T15:18:24 *** mrpeters-isl has quit IRC 2010-10-07T15:18:32 *** mrpeters-isl has joined #evergreen 2010-10-07T15:28:50 *** Melissa1 has joined #evergreen 2010-10-07T15:29:18 *** Melissa has quit IRC 2010-10-07T15:34:35 *** Melissa has joined #evergreen 2010-10-07T15:36:23 *** Melissa1 has quit IRC 2010-10-07T15:42:01 *** finnapz has quit IRC 2010-10-07T15:42:10 *** parsr has quit IRC 2010-10-07T15:42:32 *** finnapz has joined #evergreen 2010-10-07T15:43:19 *** finnapz has quit IRC 2010-10-07T15:43:42 *** finnapz has joined #evergreen 2010-10-07T15:47:40 *** collum has left #evergreen 2010-10-07T15:47:55 *** JMCraig has joined #evergreen 2010-10-07T15:54:16 *** artunit_ has joined #evergreen 2010-10-07T15:58:08 *** agJohn has quit IRC 2010-10-07T16:00:55 *** jhaig has joined #evergreen 2010-10-07T16:01:19 *** kmlussier_ has joined #evergreen 2010-10-07T16:01:39 *** _bott_1 has joined #evergreen 2010-10-07T16:02:51 *** kmlussier_ has quit IRC 2010-10-07T16:03:43 I'm just listening to the podcast on Floss Weekly from a few weeks ago. I had a look at koha some time ago and found it way, way too complicated. Is evergreen simpler? (Ie, usable by someone who is not already an expert librarian) 2010-10-07T16:06:04 *** csharp_GPLS has joined #evergreen 2010-10-07T16:06:40 *** kmlussier has quit IRC 2010-10-07T16:06:41 *** lisppaste has quit IRC 2010-10-07T16:06:41 *** csharp has quit IRC 2010-10-07T16:07:10 *** r123 has quit IRC 2010-10-07T16:08:08 Hmmm, koha has just been mentioned. :-) 2010-10-07T16:08:14 *** artunit has quit IRC 2010-10-07T16:08:14 *** _bott_ has quit IRC 2010-10-07T16:13:47 jhaig: there are some people on IRC like atz and gmcharlt who can do a much better comparison of koha vs. evergreen than I can. It's probably safe to say, though, that evergreen is as complicated, if not more complicated, than koha. 2010-10-07T16:14:13 It's the nature of libraries to demand that their systems be complicated, I think. 2010-10-07T16:14:27 EG is certainly more complicated that koha. but the main difference besides architecture is UNIMARC support. 2010-10-07T16:14:55 jhaig: dbs has it; both Koha and EG are systems used by professional librarians, however you wish to define the term 2010-10-07T16:15:00 OK, thanks. Since starting to look at library software I've come to realise that it is all a whole lot more complicated than I realised. 2010-10-07T16:15:30 I think I'm just going to have to learn it properly. :-) 2010-10-07T16:15:48 depending on your needs, there are other open source options that might be more suitable for managing a personal collection or one one with a small active patron population 2010-10-07T16:16:10 Heh. It all seems deceptively simple on the surface - then five years later you're realizing that your system doesn't index the 247 field as a title entry. ZOMG! :) 2010-10-07T16:16:52 also commercial software like delicious monster that more about ease of use for the individual 2010-10-07T16:17:00 *that is more about...* 2010-10-07T16:17:16 *** jamesrf has quit IRC 2010-10-07T16:17:53 *** bshum has quit IRC 2010-10-07T16:18:33 * phasefx wants to make EG easier for personal libraries. it's a side project (I keep getting more and more books:) 2010-10-07T16:19:12 dog_fooding++ 2010-10-07T16:19:32 gmcharlt: have you seen the "self-check" in my office? :) 2010-10-07T16:19:52 heh 2010-10-07T16:20:02 actually, I don't think I have 2010-10-07T16:20:12 (it's a clipboard) 2010-10-07T16:20:17 Until dbwells cuts the gordian knot between call numbers and bib records, I don't know how to catalogue the various ebooks on my phone. 2010-10-07T16:25:50 *** granitize has quit IRC 2010-10-07T16:26:28 *** granitize has joined #evergreen 2010-10-07T16:28:26 *** dbs has quit IRC 2010-10-07T16:31:20 *** brian_f has quit IRC 2010-10-07T16:33:35 *** brian_f has joined #evergreen 2010-10-07T16:43:39 *** tildeequals has quit IRC 2010-10-07T16:45:15 *** tildeequals has joined #evergreen 2010-10-07T16:48:03 *** Melissa has quit IRC 2010-10-07T17:22:51 *** pmplett has quit IRC 2010-10-07T17:23:47 *** jhaig has quit IRC 2010-10-07T17:31:02 *** brian_f has left #evergreen 2010-10-07T17:34:57 *** jamesrf has joined #evergreen 2010-10-07T17:35:14 *** jamesrf_ has joined #evergreen 2010-10-07T17:36:00 *** jamesrf_ has left #evergreen 2010-10-07T19:06:26 *** LBA has joined #evergreen 2010-10-07T19:07:18 *** LBA1 has quit IRC 2010-10-07T19:12:26 *** pmplett has joined #evergreen 2010-10-07T20:56:09 *** chrissharp123 has joined #evergreen 2010-10-07T21:36:02 *** jamesrf has quit IRC 2010-10-07T21:54:08 *** pmplett has quit IRC 2010-10-07T21:58:30 *** jamesrf has joined #evergreen 2010-10-07T22:36:27 *** atz_ has joined #evergreen 2010-10-07T22:40:23 *** atz has quit IRC 2010-10-07T23:15:51 *** chrissharp123 has quit IRC 2010-10-07T23:18:26 *** StephenGWills has quit IRC 2010-10-07T23:33:37 *** jamesrf has quit IRC 2010-10-07T23:34:58 dbs++ # fixing internal dummy warnings