2007/7/26, adamunno at tele2.it <adamunno at tele2.it>:
> Hi all!
> 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
> slon sql_cluster "dbname=contactdb user=postgres" &
> i obtain:
>
> 2007-07-25 22:26:01 CEST DEBUG2 slon_retry() from pid=19480
> 2007-07-25 22:26:01 CEST DEBUG1 slon: retry requested
> 2007-07-25 22:26:01 CEST DEBUG2 slon: notify worker process to shutdown
> 2007-07-25 22:26:01 CEST DEBUG2 slon: worker process created - pid = 19480
> 2007-07-25 22:26:01 CEST DEBUG2 slon: child terminated status: 0; pid:
> 19480, current worker pid: 19480
> 2007-07-25 22:26:01 CEST DEBUG1 slon: restart of worker
> 2007-07-25 22:26:01 CEST CONFIG main: slon version 1.2.1 starting up
> 2007-07-25 22:26:01 CEST DEBUG2 slon: watchdog process started
> 2007-07-25 22:26:01 CEST DEBUG2 slon: watchdog ready - pid = 18968
> 2007-07-25 22:26:01 CEST FATAL  main: Cannot connect to local database -
> could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
>
> 2007-07-25 22:26:01 CEST DEBUG2 slon_retry() from pid=19481
> 2007-07-25 22:26:01 CEST DEBUG1 slon: retry requested
> 2007-07-25 22:26:01 CEST DEBUG2 slon: notify worker process to shutdown
> 2007-07-25 22:26:01 CEST DEBUG2 slon: worker process created - pid = 19481
> 2007-07-25 22:26:01 CEST DEBUG2 slon: child terminated status: 0; pid:
> 19481, current worker pid: 19481
> 2007-07-25 22:26:01 CEST DEBUG1 slon: restart of worker
> 2007-07-25 22:26:01 CEST CONFIG main: slon version 1.2.1 starting up
> 2007-07-25 22:26:01 CEST FATAL  slon: sched_wakeuppipe create failed -(24)
> Too many open files
> 2007-07-25 22:26:01 CEST DEBUG2 slon: exit(-1)
>
> In my pg_hba.cong there is
> local all all trust
> host all all 127.0.0.1/32 trust
> and postgres run correctly on loacalhost on port 5432.
>
> Any ideas?

try to add "host=localhost port=5432" to connection strings passed to slon.
if you don't, it tries to connect via unix socket and fails.

-- 
Filip Rembiałkowski