Search Postgresql Archives

Re: pg_dump cannot connect when executing by a script

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Luca Ferrari <fluca1978@xxxxxxxxxxx> 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
>         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

Well, um, that command line can't possibly give rise to that error
message.  pg_dump is evidently trying to connect via Unix socket,
which it absolutely won't do if given a "-h host" argument.

> 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.

I suspect that the command is being misparsed, perhaps because your
fooling with IFS is having more effect than you realize.  You might want
to try inserting "echo", or some other way of debugging exactly how the
command arguments are getting divided up.

Another theory: the script you're executing is not the one you think it 
is.  We've seen more than one person waste a lot of time that way :-(

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux