[Skytools-users] Skytools 3.0 alpha1 - Error and some questions

[Marko Kreen]

On 4/28/09, RW <skytools at tauceti.net> wrote:
>  I'am currently testing Londiste from Skytools 3.0a and try to write some Mini-Howto. Works very well so far. Some things in the documentation were not obviuos to me at first especially how to design and where to place/use the connector strings if you run two databases on two different hosts (connecting over TCP/IP).

Indeed, the docs are mostly missing yet.  Hopefully the situation
is improved at alpha2.

>  My setup is simple. One database is the provider (called master) and the other database on another host is the subcriber (called slave).
>
>  Today I've got an error:
>
>  postgres at master> londiste -v  londiste_hbmi_master.ini missing
>
>  2009-04-27 12:50:18,501 529 DEBUG display_table: select * from londiste.node_show_missing('hbmi')
>  2009-04-27 12:50:18,503 529 ERROR Job londiste_hbmi_master crashed: psycopg2.ProgrammingError: function londiste.node_show_missing(unknown) does not exist
>  LINE 1: select * from londiste.node_show_missing(E'hbmi')
>                       ^
>  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
>  Traceback (most recent call last):
>   File "usr/local/lib64/python2.4/site-packages/skytools/scripting.py", line 558, in run_once
>   File "usr/local/lib64/python2.4/site-packages/skytools/adminscript.py", line 57, in work
>   File "usr/local/lib64/python2.4/site-packages/londiste/setup.py", line 288, in cmd_missing
>   File "usr/local/lib64/python2.4/site-packages/skytools/adminscript.py", line 76, in display_table
>   File "/usr/local/lib64/python2.4/site-packages/psycopg2/extras.py", line 89, in execute
>     return _cursor.execute(self, query, vars, async)
>  ProgrammingError: function londiste.node_show_missing(unknown) does not exist
>  LINE 1: select * from londiste.node_show_missing(E'hbmi')
>                       ^
>  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
>
>  This function doesn't exist anywhere in the two databases. How can I install it? I'm using psycopg2 2.0.9 if this helps.
>

Yeah, this is simply unimplemented...  But it also seems missing from
TODO list, so thanks for pointing it out.

>  Then another question: How can I remove a database from replication entirely? Deleting schema londiste, pgq and pgq_node alone will certainly won't do it ;-) If I'm right I've to remove every replicated table from the queue, delete the queue itself and finally drop the schema's mentioned above.
>
>  BTW: I can't get the "--all" option to work:
>  londiste -v --all londiste_webadr_master.ini add-table
>  Is this the right usage? Tried different positions but none worked. No table get's added. Adding single tables works.

Ok, another feature that was lost from 2.1.  Hopefully we can fix it soon.

>  I'm currently running londiste/pgqadm daemons on the provider. Makes this sense? What is the pefered setup? Our firewall setup allows only that the master can connect to the slave on port 5432 but not the other way round. So i suspect that I haven't any choise either?

Well, there is not much difference in 2.1, but in 3.0 the replay
process will be "logically" tied to subscriber, because it can change
the provider host on-the-fly.  But even then you can run it on
provider if needed.

-- 
marko