2009-12-08T00:03:12 *** jamesrf_afk has quit IRC 2009-12-08T00:04:08 *** jamesrf has joined #evergreen 2009-12-08T00:06:52 *** twirlip has left #evergreen 2009-12-08T00:07:59 *** jamesrf has quit IRC 2009-12-08T00:29:00 *** jamesrf has joined #evergreen 2009-12-08T02:29:23 *** pmplett has quit IRC 2009-12-08T03:26:26 *** eguest309 has joined #Evergreen 2009-12-08T03:31:36 *** eguest309 has quit IRC 2009-12-08T03:43:28 *** eguest309 has joined #Evergreen 2009-12-08T04:10:53 *** plogik has quit IRC 2009-12-08T04:10:53 *** plogik_ has quit IRC 2009-12-08T05:42:17 *** eguest309_ has joined #Evergreen 2009-12-08T05:43:01 *** stompro__ has quit IRC 2009-12-08T06:00:27 *** eguest309 has quit IRC 2009-12-08T06:00:28 *** eguest309_ is now known as eguest309 2009-12-08T06:17:48 *** eguest309 has quit IRC 2009-12-08T06:17:48 *** jamesrf has quit IRC 2009-12-08T06:17:48 *** moodaepo has quit IRC 2009-12-08T06:17:48 *** brendan_ga has quit IRC 2009-12-08T06:17:48 *** rsinger has quit IRC 2009-12-08T06:17:48 *** chrissharp123 has quit IRC 2009-12-08T06:17:48 *** senator has quit IRC 2009-12-08T06:17:48 *** _dkyle_ has quit IRC 2009-12-08T06:17:48 *** AbizzalsX has quit IRC 2009-12-08T06:19:02 *** eguest309 has joined #evergreen 2009-12-08T06:19:02 *** jamesrf has joined #evergreen 2009-12-08T06:19:02 *** brendan_ga has joined #evergreen 2009-12-08T06:19:02 *** moodaepo has joined #evergreen 2009-12-08T06:19:02 *** rsinger has joined #evergreen 2009-12-08T06:19:02 *** senator has joined #evergreen 2009-12-08T06:19:02 *** _dkyle_ has joined #evergreen 2009-12-08T06:19:02 *** AbizzalsX has joined #evergreen 2009-12-08T06:19:02 *** chrissharp123 has joined #evergreen 2009-12-08T06:35:03 *** eguest309_ has joined #Evergreen 2009-12-08T06:43:37 *** eguest309 has quit IRC 2009-12-08T06:44:08 *** eguest309_ is now known as eguest309 2009-12-08T06:56:14 *** jamesrf has quit IRC 2009-12-08T06:56:14 *** moodaepo has quit IRC 2009-12-08T06:56:14 *** brendan_ga has quit IRC 2009-12-08T06:56:14 *** rsinger has quit IRC 2009-12-08T06:56:14 *** chrissharp123 has quit IRC 2009-12-08T06:56:14 *** AbizzalsX has quit IRC 2009-12-08T06:56:14 *** _dkyle_ has quit IRC 2009-12-08T06:56:14 *** senator has quit IRC 2009-12-08T06:59:51 *** moodaepo has joined #evergreen 2009-12-08T06:59:51 *** jamesrf has joined #evergreen 2009-12-08T06:59:51 *** rsinger has joined #evergreen 2009-12-08T06:59:51 *** brendan_ga has joined #evergreen 2009-12-08T06:59:51 *** chrissharp123 has joined #evergreen 2009-12-08T07:00:48 *** senator has joined #evergreen 2009-12-08T07:00:48 *** _dkyle_ has joined #evergreen 2009-12-08T07:00:48 *** AbizzalsX has joined #evergreen 2009-12-08T07:05:42 *** _dkyle_ has quit IRC 2009-12-08T07:05:42 *** senator has quit IRC 2009-12-08T07:05:42 *** AbizzalsX has quit IRC 2009-12-08T07:05:42 *** brendan_ga has quit IRC 2009-12-08T07:05:42 *** rsinger has quit IRC 2009-12-08T07:05:42 *** jamesrf has quit IRC 2009-12-08T07:05:42 *** moodaepo has quit IRC 2009-12-08T07:05:42 *** chrissharp123 has quit IRC 2009-12-08T07:06:28 *** AbizzalsX has joined #evergreen 2009-12-08T07:06:28 *** _dkyle_ has joined #evergreen 2009-12-08T07:06:28 *** senator has joined #evergreen 2009-12-08T07:06:28 *** moodaepo has joined #evergreen 2009-12-08T07:06:28 *** jamesrf has joined #evergreen 2009-12-08T07:06:28 *** rsinger has joined #evergreen 2009-12-08T07:06:28 *** brendan_ga has joined #evergreen 2009-12-08T07:06:28 *** chrissharp123 has joined #evergreen 2009-12-08T07:11:51 *** eguest309 has quit IRC 2009-12-08T07:12:03 *** _dkyle_ has quit IRC 2009-12-08T07:12:03 *** AbizzalsX has quit IRC 2009-12-08T07:12:04 *** senator has quit IRC 2009-12-08T07:12:04 *** brendan_ga has quit IRC 2009-12-08T07:12:04 *** rsinger has quit IRC 2009-12-08T07:12:04 *** jamesrf has quit IRC 2009-12-08T07:12:04 *** moodaepo has quit IRC 2009-12-08T07:12:04 *** chrissharp123 has quit IRC 2009-12-08T07:12:33 *** eguest309 has joined #Evergreen 2009-12-08T07:12:39 *** AbizzalsX has joined #evergreen 2009-12-08T07:12:39 *** _dkyle_ has joined #evergreen 2009-12-08T07:12:39 *** senator has joined #evergreen 2009-12-08T07:12:39 *** moodaepo has joined #evergreen 2009-12-08T07:12:39 *** jamesrf has joined #evergreen 2009-12-08T07:12:39 *** rsinger has joined #evergreen 2009-12-08T07:12:39 *** brendan_ga has joined #evergreen 2009-12-08T07:12:39 *** chrissharp123 has joined #evergreen 2009-12-08T07:15:23 *** _dkyle_ has quit IRC 2009-12-08T07:15:23 *** AbizzalsX has quit IRC 2009-12-08T07:15:23 *** senator has quit IRC 2009-12-08T07:15:23 *** brendan_ga has quit IRC 2009-12-08T07:15:23 *** rsinger has quit IRC 2009-12-08T07:15:23 *** jamesrf has quit IRC 2009-12-08T07:15:23 *** moodaepo has quit IRC 2009-12-08T07:15:23 *** chrissharp123 has quit IRC 2009-12-08T07:16:44 *** brendan_ga has joined #evergreen 2009-12-08T07:16:44 *** rsinger has joined #evergreen 2009-12-08T07:19:58 *** chrissharp123 has joined #evergreen 2009-12-08T07:22:14 *** jamesrf has joined #evergreen 2009-12-08T07:22:14 *** moodaepo has joined #evergreen 2009-12-08T07:22:32 *** senator has joined #evergreen 2009-12-08T07:22:32 *** _dkyle_ has joined #evergreen 2009-12-08T07:22:32 *** AbizzalsX has joined #evergreen 2009-12-08T07:32:20 *** error_23 has quit IRC 2009-12-08T07:32:20 *** kbeswick has quit IRC 2009-12-08T07:32:20 *** phasefx has quit IRC 2009-12-08T07:32:55 *** phasefx has joined #evergreen 2009-12-08T07:32:56 *** error_23 has joined #evergreen 2009-12-08T07:32:56 *** kbeswick has joined #evergreen 2009-12-08T07:55:54 *** mck9 has joined #evergreen 2009-12-08T08:13:34 *** rickd has joined #evergreen 2009-12-08T08:14:45 anyone run into "ERROR: no tsearch config CONTEXT: PL/pgSQL function "oils_tsearch2" line 2 at assignment" on a load of pg_loader-output.sql? i have tsearch2 enabled on the target db 2009-12-08T08:16:21 mrpeters-isl: I haven't. You may want to try emailing the list 2009-12-08T08:16:56 or rather, I have, but only when tsearch2 wasn't enabled :) 2009-12-08T08:17:04 which version of postgres? 2009-12-08T08:21:46 mmm let me check 2009-12-08T08:22:06 8.2 2009-12-08T08:23:25 at a certain point tsearch2 becomes a part of the core postgres, rather than a contrib module 2009-12-08T08:23:35 but 8.2 is still contrib 2009-12-08T08:24:12 yeah, so i enabled tsearch, pgxml, etc. on a fresh database, then did my restore from a backup and now this 2009-12-08T08:24:22 the backup also had tsearch enabled, of course 2009-12-08T08:24:30 in the target db, run this: select * from pg_ts_cfg; 2009-12-08T08:24:56 default, russian, utf8russian, simple 2009-12-08T08:27:42 yeah, I don't know. \df to_tsvector ? 2009-12-08T08:28:24 List of functions 2009-12-08T08:28:24 Schema | Name | Result data type | Argument data types 2009-12-08T08:28:24 --------+-------------+------------------+--------------------- 2009-12-08T08:28:24 public | to_tsvector | tsvector | oid, text 2009-12-08T08:28:24 public | to_tsvector | tsvector | text 2009-12-08T08:28:25 public | to_tsvector | tsvector | text, text 2009-12-08T08:28:35 how are you loading pg_loader-output.sql? 2009-12-08T08:30:45 psql -U evergreen < out/pg_loader-output.sql > log/load_pg_loader-output 2009-12-08T08:31:05 my log only gives SET 2009-12-08T08:31:05 BEGIN 2009-12-08T08:31:05 COPY 57284 2009-12-08T08:31:05 COPY 57284 2009-12-08T08:31:05 ROLLBACK 2009-12-08T08:32:18 try psql -ae -U evergreen then within \i out/pg_loader-output.sql 2009-12-08T08:33:00 or try psql -ae -U evergreen -f out/pg_loader-output.sql > log/load_pg_loader-output 2009-12-08T08:33:36 ok i can do that 2009-12-08T08:33:44 the -ae should give you more output, at least 2009-12-08T08:33:54 ok cool 2009-12-08T08:34:46 *** rickd has quit IRC 2009-12-08T08:34:57 *** rickd has joined #evergreen 2009-12-08T08:35:51 mrpeters-isl pasted "pg_loader-output.sql error" at http://paste.lisp.org/display/91765 2009-12-08T08:37:38 kinda hard to tell where its going wrong 2009-12-08T08:38:08 yeah, I don't know. What's on line 7 of pg_laoder-output.sql? 2009-12-08T08:48:38 *** gmcharlt has joined #evergreen 2009-12-08T08:52:05 *** mrpeters-isl has quit IRC 2009-12-08T09:00:42 *** bshum has joined #evergreen 2009-12-08T09:02:35 *** mrpeters-isl has joined #evergreen 2009-12-08T09:18:17 <- in 2009-12-08T09:18:23 *** jenny has joined #evergreen 2009-12-08T09:31:28 *** sfortin has joined #evergreen 2009-12-08T09:32:20 *** brendan_ga has quit IRC 2009-12-08T09:35:18 *** jatzberger has joined #evergreen 2009-12-08T09:40:47 *** jatzberger has quit IRC 2009-12-08T09:46:10 *** atz has joined #evergreen 2009-12-08T09:50:12 *** eguest309 has left #Evergreen 2009-12-08T09:54:49 *** brendan_ga has joined #evergreen 2009-12-08T10:02:30 *** sfortin has quit IRC 2009-12-08T11:04:55 *** evette-mlc has joined #evergreen 2009-12-08T11:12:16 *** [1]atz has joined #evergreen 2009-12-08T11:12:34 *** atz has quit IRC 2009-12-08T11:12:34 *** [1]atz is now known as atz 2009-12-08T11:26:19 *** jenny has quit IRC 2009-12-08T11:50:40 *** jenny has joined #evergreen 2009-12-08T11:53:04 *** jenny1 has joined #evergreen 2009-12-08T11:55:26 *** jenny has quit IRC 2009-12-08T11:55:26 *** r123 has quit IRC 2009-12-08T11:55:26 *** wjr has quit IRC 2009-12-08T11:55:26 *** Guest97300 has quit IRC 2009-12-08T11:55:26 *** greg-g has quit IRC 2009-12-08T11:57:33 *** greg-g has joined #evergreen 2009-12-08T11:59:29 *** r123 has joined #evergreen 2009-12-08T12:01:50 *** jenny has joined #evergreen 2009-12-08T12:01:50 *** wjr has joined #evergreen 2009-12-08T12:01:50 *** Guest97300 has joined #evergreen 2009-12-08T12:02:07 *** dbwells_ has joined #Evergreen 2009-12-08T12:05:00 *** bshum has quit IRC 2009-12-08T12:05:00 *** dbwells has quit IRC 2009-12-08T12:05:00 *** phasefx2 has quit IRC 2009-12-08T12:05:00 *** jmeeuwen has quit IRC 2009-12-08T12:05:00 *** wjr has quit IRC 2009-12-08T12:05:00 *** jenny has quit IRC 2009-12-08T12:05:00 *** Guest97300 has quit IRC 2009-12-08T12:05:03 *** dbwells_ is now known as dbwells 2009-12-08T12:05:40 *** bshum has joined #evergreen 2009-12-08T12:05:40 *** jmeeuwen has joined #evergreen 2009-12-08T12:07:28 *** phasefx2 has joined #evergreen 2009-12-08T12:07:28 *** jenny has joined #evergreen 2009-12-08T12:07:28 *** wjr has joined #evergreen 2009-12-08T12:07:28 *** Guest97300 has joined #evergreen 2009-12-08T12:08:44 *** bshum_ has joined #evergreen 2009-12-08T12:10:12 *** bshum has quit IRC 2009-12-08T12:10:13 *** bshum_ is now known as bshum 2009-12-08T12:12:47 *** jmeeuwen_ has joined #evergreen 2009-12-08T12:13:14 *** [1]atz has joined #evergreen 2009-12-08T12:13:30 *** jenny has quit IRC 2009-12-08T12:13:35 *** wjr has quit IRC 2009-12-08T12:13:35 *** Guest97300 has quit IRC 2009-12-08T12:13:35 *** phasefx2 has quit IRC 2009-12-08T12:14:46 *** jmeeuwen has quit IRC 2009-12-08T12:15:24 *** jmeeuwen has joined #evergreen 2009-12-08T12:15:43 *** jmeeuwen has quit IRC 2009-12-08T12:17:42 *** phasefx2 has joined #evergreen 2009-12-08T12:18:40 *** jeff_ has joined #evergreen 2009-12-08T12:18:40 *** wjr has joined #evergreen 2009-12-08T12:22:47 *** wjr has quit IRC 2009-12-08T12:22:47 *** jeff_ has quit IRC 2009-12-08T12:25:26 *** jeff__ has joined #evergreen 2009-12-08T12:27:54 *** jeff__ is now known as jeff_ 2009-12-08T12:29:34 *** wjr has joined #evergreen 2009-12-08T12:30:58 *** atz has quit IRC 2009-12-08T12:31:02 *** [1]atz is now known as atz 2009-12-08T12:32:15 *** r123 has quit IRC 2009-12-08T12:34:05 *** r123 has joined #evergreen 2009-12-08T12:45:07 *** natschil has joined #evergreen 2009-12-08T12:53:08 *** natschil has quit IRC 2009-12-08T12:53:08 *** gmcharlt has quit IRC 2009-12-08T12:53:08 *** rsinger has quit IRC 2009-12-08T12:53:08 *** natschil_ has joined #evergreen 2009-12-08T13:05:34 *** sfortin has joined #evergreen 2009-12-08T13:19:44 *** gmcharlt has joined #evergreen 2009-12-08T13:24:18 *** bshum has quit IRC 2009-12-08T13:28:22 *** bshum has joined #evergreen 2009-12-08T13:28:22 *** rsinger has joined #evergreen 2009-12-08T13:28:28 *** bshum has left #evergreen 2009-12-08T13:28:40 *** bshum has joined #evergreen 2009-12-08T14:00:49 *** jamesrf_ has joined #evergreen 2009-12-08T14:08:15 *** mck9 has quit IRC 2009-12-08T14:47:35 *** natschil_ has quit IRC 2009-12-08T14:48:26 *** wjr has quit IRC 2009-12-08T14:48:38 *** wjr has joined #evergreen 2009-12-08T14:58:08 *** pmplett has joined #evergreen 2009-12-08T15:07:42 *** sfortin has quit IRC 2009-12-08T15:13:00 *** jenny1 has quit IRC 2009-12-08T15:33:38 *** hopkinsju has quit IRC 2009-12-08T15:44:04 *** jenny has joined #evergreen 2009-12-08T15:48:59 miker_++ # local cover art in 1-line 2009-12-08T15:58:53 *** bshum has quit IRC 2009-12-08T16:03:43 *** branflakes has quit IRC 2009-12-08T16:07:45 *** hopkinsju has joined #evergreen 2009-12-08T16:08:07 *** hopkinsju has left #evergreen 2009-12-08T16:09:29 *** senator has left #Evergreen 2009-12-08T16:31:34 *** sfortin has joined #evergreen 2009-12-08T16:42:34 *** rsinger has quit IRC 2009-12-08T16:43:36 *** rsinger has joined #evergreen 2009-12-08T16:44:58 *** branflakes has joined #Evergreen 2009-12-08T16:47:57 *** Meliss has joined #Evergreen 2009-12-08T16:48:50 miker_++ # yes. for the covers. 2009-12-08T16:56:03 *** sfortin has quit IRC 2009-12-08T17:00:13 *** evette-mlc has quit IRC 2009-12-08T17:01:18 *** Meliss has quit IRC 2009-12-08T17:36:47 *** jenny has left #evergreen 2009-12-08T17:39:35 *** rsinger has quit IRC 2009-12-08T17:43:17 *** rsinger has joined #evergreen 2009-12-08T18:09:22 *** atz has quit IRC 2009-12-08T18:14:47 *** atz has joined #evergreen 2009-12-08T18:54:09 *** twirlip has joined #evergreen 2009-12-08T19:10:15 *** gmcharlt has quit IRC 2009-12-08T19:19:18 *** twirlip has left #evergreen 2009-12-08T19:43:02 *** brendan_ga has quit IRC 2009-12-08T19:47:48 *** brendan_ga has joined #evergreen 2009-12-08T20:07:49 *** gmcharlt has joined #evergreen 2009-12-08T20:28:02 *** wlayton has joined #evergreen 2009-12-08T20:52:59 *** pmplett is now known as pmp_afk 2009-12-08T21:44:13 *** branflakes has quit IRC 2009-12-08T22:15:53 *** wlayton has quit IRC 2009-12-08T23:06:33 *** pmp_afk is now known as pmplett 2009-12-08T23:53:27 *** rickd has quit IRC