<div id="_htmlarea_default_style_" style="font:10pt arial,helvetica,sans-serif">Hi all!<br>I'm testing slony 1.2.1 on postgresql 8.1 and ubuntu 8 on a virtual machine of vmware following the example on http://www.linuxjournal.com/article/7834. I created two db on the same machine and I run the script cluster_setup.sh. Then when I run slon daemon with<br>slon sql_cluster "dbname=contactdb user=postgres" &<br>i obtain: <br> <br>2007-07-25 22:26:01 CEST DEBUG2 slon_retry() from pid=19480<br>2007-07-25 22:26:01 CEST DEBUG1 slon: retry requested<br>2007-07-25 22:26:01 CEST DEBUG2 slon: notify worker process to shutdown<br>2007-07-25 22:26:01 CEST DEBUG2 slon: worker process created - pid = 19480<br>2007-07-25 22:26:01 CEST DEBUG2 slon: child terminated status: 0; pid: 19480, current worker pid: 19480<br>2007-07-25 22:26:01 CEST DEBUG1 slon: restart of worker<br>2007-07-25 22:26:01 CEST CONFIG main: slon version 1.2.1 starting up<br>2007-07-25 22:26:01 CEST DEBUG2 slon: watchdog process started<br>2007-07-25 22:26:01 CEST DEBUG2 slon: watchdog ready - pid = 18968<br>2007-07-25 22:26:01 CEST FATAL main: Cannot connect to local database - could not connect to server: No such file or directory<br> Is the server running locally and accepting<br> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?<br><br>2007-07-25 22:26:01 CEST DEBUG2 slon_retry() from pid=19481<br>2007-07-25 22:26:01 CEST DEBUG1 slon: retry requested<br>2007-07-25 22:26:01 CEST DEBUG2 slon: notify worker process to shutdown<br>2007-07-25 22:26:01 CEST DEBUG2 slon: worker process created - pid = 19481<br>2007-07-25 22:26:01 CEST DEBUG2 slon: child terminated status: 0; pid: 19481, current worker pid: 19481<br>2007-07-25 22:26:01 CEST DEBUG1 slon: restart of worker<br>2007-07-25 22:26:01 CEST CONFIG main: slon version 1.2.1 starting up<br>2007-07-25 22:26:01 CEST FATAL slon: sched_wakeuppipe create failed -(24) Too many open files<br>2007-07-25 22:26:01 CEST DEBUG2 slon: exit(-1)<br><br>In my pg_hba.cong there is <br>local all all trust<br>host all all 127.0.0.1/32 trust<br>and postgres run correctly on loacalhost on port 5432.<br><br>Any ideas?<br>Thanx in
advance.<br>ADaM<br></div>