Christopher Browne wrote:
> Tilman Baumann <tilman.baumann at collax.com> writes:
> [...]
>> 2006-08-16 13:34:44 CEST ERROR  remoteListenThread_1:
>> db_getLocalNodeId() returned 2 - wrong database?
>>
>> The last line repeating over and over.
>> No idea what this is about. Looks not good. :)
> 
> Probably not.
> 
> The trouble is probably with the contents of sl_path, and specifically
> with the value of the conninfo, most precisely with the value
> 'host=localhost'.
> 
> Using 'localhost' only works if you have only one database server
> where all the databases will live, which represents an assumption that
> is only true when doing things like regression tests.

Oh, that sounds reasonable. Thank you.

>> The next thing i'm nost sure of is in which direction i need tcp
>> connect to the db.  I would prefer if the client must not be able to
>> connect to the master.  Would this work?  Can i push the data from
>> the master or do they have cross-connections?
> 
> They need cross-connections.  In the case of a 2 node setup, you need
> a complete set of connections.
> 
> If you had more nodes, it might be sensible to have *somewhat* limited
> sets of connections, but it's still mandatory for there to be paths to
> allow events to get from any one node in the cluster to any other
> node.

Hm, that makes it difficult for me.
It looks like i have won a vpn setup. :)
One is a exposed internret hosts the other is internal...

>> And a note that you need superuser permissions on the tb and a note
>> how to use .pgpass would be usefull.
> 
> The superuser issues are definitely addressed in the FAQ...
>   http://linuxfinances.info/info/faq.html

Yea, i got stuck with the whole docu thing. I found a bit more yet after
digging a bit more on the linuxfinances.info page.

I came through the gborg site and the only thing that told me what do do
was http://gborg.postgresql.org/project/slony1/genpage.php?howto_basic
It told me what do do, not why. :)

Maybe i should give the slon-tools a try...
I assume there is no way to auto-generate a slon_tools.conf?
There are some promising maintenance tools...

-- 
Tilman Baumann
Software Developer
Collax GmbH . Boetzinger Strasse 60 . 79111 Freiburg . Germany

p: +49 (0) 89-990157-0
f: +49 (0) 89-990157-11