Thu Jun 10 14:00:10 PDT 2004
- Previous message: [Slony1-general] RE: [HACKERS] Slony-I goes BETA
- Next message: [Slony1-general] Multiple slaves
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Just built and tested the beta using the sample scripts provided -- great
stuff folks, nice job!
Assuming I'm not missing a limitation of Slony-I, current or otherwise,
could someone suggest a slonik setup for single master multiple slaves
please? I'm currently running on a single host with a single postmaster.
If nodes 2 and 3 are both slaves of node 1, what paths and listen entries
should I establish?
I've tried setting up paths and listeners 1<->2 and 1<->3 but as soon as I
subscribe node 2 to the set, slon on node 3 dies with:
PGRES_FATAL_ERROR ERROR: insert or update on table "sl_subscribe" violates
foreign key constraint "sl_subscribe-sl_path-ref"
DETAIL: Key (sub_provider,sub_receiver)=(1,2) is not present in table
"sl_path".
psql stest3 -c 'select * from _test1.sl_path'
pa_server | pa_client | pa_conninfo |
pa_connretry
-----------+-----------+------------------------------------------+---------
-----
1 | 3 | dbname=stest1 host=localhost user=julian |
10
2 | 1 | dbname=stest2 host=localhost user=julian |
10
3 | 1 | dbname=stest3 host=localhost user=julian |
10
(3 rows)
(Full report on request if I'm not doing something Obviously Dumb!).
Thanks
Julian Scarfe
- Previous message: [Slony1-general] RE: [HACKERS] Slony-I goes BETA
- Next message: [Slony1-general] Multiple slaves
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list