Jamie,

On Mon, Apr 18, 2005 at 03:27:07AM +0100, Jamie L. Penman-Smithson wrote:
> I'm running slon 1.1.0 beta1 and I think I've got everything setup, I'm
> just getting errors when running slon:
> 
> 2005-04-18 02:19:23 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23
> 2005-04-18 02:19:23 BST DEBUG2 localListenThread: Received event 2,23
> SYNC
> 2005-04-18 02:19:31 BST ERROR  cannot get sl_local_node_id - ERROR:
> permission denied for relation sl_local_node_id

I think this is where your error is. You should take a look at the user
that you're using to connect to the database. Make sure that they're a
superuser and have permission to update system catalog tables (usesuper
and usecatupd in pg_user). 

eg.

slony_test=# SELECT * FROM pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
 valuntil | useconfig
 ----------+----------+-------------+----------+-----------+----------+----------+-----------
  postgres |        1 | t           | t        | t         | ******** |
  |
   slony   |      100 | t           | t        | t         | ******** |
   |
    (2 rows)


> 2005-04-18 02:19:31 BST ERROR  remoteListenThread_1: db_getLocalNodeId()
> returned -1 - wrong database?
> 2005-04-18 02:19:33 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 24
> 2005-04-18 02:19:33 BST DEBUG2 localListenThread: Received event 2,24
> SYNC
> 
> I've read the documentation and the bit regarding "wrong database"
> errors, however I'm _not_ using localhost as the hostname..
> 
> The output of 'select * from *.sl_local_node_id' is at:
> http://www.silverdream.org/sl_local_node_id
> 
> If there's any other information that's relevant, let me know.
> 
> Thanks,
> 
> -j

> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
Tim Goodaire    416-673-4126    tgoodair at ca.afilias.info
Database Administrator, Afilias Canada Corp.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050418/262f35ac/attachment.bin