Tue Nov 27 16:07:39 PST 2007
- Previous message: [Slony1-general] A Best Practices Question
- Next message: [Slony1-general] Problem compiling slony 1.2 - scan.c ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All, yestarday one of the db boxes we in our cluster died. It took the db with it. After a fresh install I added it to the cluster (basically - drop node 3, store node 3). And then when I tried to start slony I got: 2007-11-28 12:55:43 NZDT ERROR cannot get sl_local_node_id - ERROR: schema "_radiuscluster" does not exist 2007-11-28 12:55:43 NZDT FATAL main: Node is not initialized properly However if I try to connect to the db with the same privileges slony uses (postgres admin user) I can see the tables: postgres at raddb3:~$ psql -H akl-grafton-raddb3.ihug.net -U postgres radbackend psql: warning: extra command-line argument "radbackend" ignored psql: FATAL: database "akl-grafton-raddb3.ihug.net" does not exist postgres at raddb3:~$ psql -h akl-grafton-raddb3.ihug.net -U postgres radbackend Welcome to psql 8.1.9, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) radbackend=# select * from _radiuscluster.sl_node _radiuscluster.sl_node _radiuscluster.sl_nodelock_nl_conncnt_seq _radiuscluster.sl_nodelock radbackend=# select * from _radiuscluster.sl_node; no_id | no_active | no_comment | no_spool -------+-----------+-------------------------------------------------+---------- 3 | t | Node 3 - radbackend at akl-grafton-raddb3 | f 2 | t | Node 2 - radbackend at akl-grafton-raddb2 | f 1 | t | Node 1 - radbackend at akl-grafton-raddb1 | f 4 | t | Node 4 - radbackend at akl-grafton-raddb4 | f (4 rows) A few days ago I re-provisioned node 4 exactly the same way and everything seems to be fine. What might be the problem? Configuration files (slony1.conf is set to all defaults), or something in the database? I use slony 1.2.1. kind regards Pshem
- Previous message: [Slony1-general] A Best Practices Question
- Next message: [Slony1-general] Problem compiling slony 1.2 - scan.c ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list