Talk:Londiste Tutorial (Skytools 2)

From PostgreSQL wiki

Jump to: navigation, search

Thanks, this is highly appreciated. I also have some docs on slony and WAL shipping which I'll contribute soon. - Robe 15:25, 4 March 2009 (UTC)

While this is indeed highly appreciated, I suggest a bit more context. It's not clear the state of the subscriber database and server when we start. It'd be good to put in a paragraph indicating whether the tables have been created in the subscriber, and whatever else had to be done to prepare for this. --Edgreenberg 17:52, 18 September 2009 (UTC)

This HOWTO has indeed enabled me to start up a londiste replicator (where the docs in the distribution failed). It does the job in telling me what to DO. I can likely help make it clearer still as I have just finished the installation and remember my problems: (1) the ticker daemon para contains data meaningless and confusing to a newcomer - queue? What queue? Many queues? I don't want many of anything when I start, and telling me about many and using the word IF too is a big no-no at this point. (2) the logfile and pidfile formats in the ticker.ini para are not particularly good nor safe - some people might not know what a directory is and not make a log or pid directory! ~/londiste.%(job_name)s.log is probably safe, but then logs anywhere in one's home (WHOSE home?) are weird anyway. At this point we don't know what machine we are on nor which user we are running as. (3) it's already too late, but we needed to know which machine to be working from and giving the instructions from (it doesn't seem to matter, but what do I know ..) and which user we are working as. Which user seems to matter since some instructions launch daemons, and they seem to try and write logs and pids in system dirs (/var/log/londiste/, /var/log/run/). I solved that by running all daemons as myself, adding myself to group adm, changing group of the londiste system dirs mentioned in the parentheses to adm, and giving write permission to group on them. Come to that, I had to create the dirs in the first place - obviously my skytools install was defective, but then I had to improvise a lot of it for python2.5 and postgres 8.4. (4) this replication daemon - this para is all wishy-washy about where to run daemons from. One needs instructions, not philosophy. I seem to remember I ran the daemon on the subscriber and something is certainly making log noise there, but what with the ticker daemon I don't remember clearly. Again where and who is not clear. (5) installing londiste - the tenses are not clear. You probably mean "you had installed the whole skytools package" (PAST subjunctive tense), not "you install the whole .." (FUTURE subjunctive tense), as written. (6) adding tables and sequences - what's a sequence? Never heard of one and the text doesn't say which command is for tables and which for sequences. Never mind .. it's clear to me, but probably not to all. Anyway, not all adds work for me - anything on a big table times out. I've tried altering the timeout in but it just takes longer to timeout. Here you are: psycopg.ProgrammingError: ERROR: canceling statement due to statement timeout CONTEXT: SQL statement "create trigger londiste_replica_logger after insert or update or delete on ptb.user_calls_353 for each row execute procedure pgq.logtriga('londiste.replica', 'kvvvvvvv', 'ptb.user_calls_353')". PL/pgSQL function "provider_create_trigger" line 12 at EXECUTE statement SQL statement "SELECT londiste.provider_create_trigger( $1 , $2 , $3 )" PL/pgSQL function "provider_add_table" line 27 at PERFORM PL/pgSQL function "provider_add_table" line 2 at RETURN. Shorter tables are OK. --Peter 10:25, 16 October 2009 (UTC)

Personal tools