pg_dump cannot connect when executing by a script
| От | Luca Ferrari |
|---|---|
| Тема | pg_dump cannot connect when executing by a script |
| Дата | |
| Msg-id | 201005251243.01255.fluca1978@infinito.it обсуждение |
| Ответы |
Re: pg_dump cannot connect when executing by a script
Re: pg_dump cannot connect when executing by a script |
| Список | pgsql-general |
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 database "webcalendardb" failed: could
not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
and the line the script is executing is the following:
/usr/local/bin/pg_dump -f
/backup/sedeldap/postgresql//webcalendardb2010_05_25.sql -h sedeldapa -U
postgres webcalendardb
and of course, if executed interactively, the above line works. The pg_dump is
for 8.4.0 (installed from freebsd ports).
Moreover, if in the script I add the option -F t than the script complains
that:
pg_dump: too many command-line arguments (first is "webcalendardb")
and of course the following:
/usr/local/bin/pg_dump -F t-f
/backup/sedeldap/postgresql//webcalendardb2010_05_25.sql -h sedeldap -U
postgres webcalendardb
works.
Any idea? The only thing I suspect is that I change the IFS in the shell
script, but I also restore it back before trying to pg_dump.
Luca
В списке pgsql-general по дате отправления: