Re: [GENERAL] pg_dump cannot connect when executing by a script

2010-05-25 Thread Tom Lane
Luca Ferrari writes: > for my case: when I executed pg_dump against a database from a script (that > will be executed by cron) I got the following error: > pg_dump: [archiver (db)] connection to database "webcalendardb" failed: could > not connect to server: No such file or directory >

Re: [GENERAL] pg_dump cannot connect when executing by a script

2010-05-25 Thread Luca Ferrari
On Tuesday 25 May 2010 01:13:40 pm A. Kretschmer's cat walking on the keyboard wrote: > Your unix-scket isn't in /tmp. > > Start psql -h localhost and type: > > show unix_socket_directory; > > This will show you the corrent path to the unix-socket. You can use that > for pg_dump with option -h

Re: [GENERAL] pg_dump cannot connect when executing by a script

2010-05-25 Thread A. Kretschmer
In response to Luca Ferrari : > Hi all, > I've found in the net a lot of problems similar to mine, but not the solution > for my case: when I executed pg_dump against a database from a script (that > will be executed by cron) I got the following error: > > pg_dump: [archiver (db)] connection to