pg_dump cannot connect when executing by a script - Mailing list pgsql-general

From Luca Ferrari
Subject pg_dump cannot connect when executing by a script
Date
Msg-id 201005251243.01255.fluca1978@infinito.it
Whole thread Raw
Responses Re: pg_dump cannot connect when executing by a script  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: pg_dump cannot connect when executing by a script  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Sam Mason
Date:
Subject: Re: Hiding data in postgresql
Next
From: "A. Kretschmer"
Date:
Subject: Re: pg_dump cannot connect when executing by a script