Hello,
I'm trying to run the "pg_dumpall" command from the postgresql server package, but while "pg_dump" command works fine, when I run "pg_dumpall" I get the following error:
[C:\Programs\pgsql\bin]rem pg_dump -Fc -b biblioteca | gzip -9 > dumpsql_biblioteca.tar.gz
[C:\Programs\pgsql\bin]pg_dumpall | gzip -9 1> dumpall.gz
C:/usr/bin/sh.exe: 1: cannot create nul:: Directory nonexistent
fgets failure: No such file or directory
The program "pg_dump" is needed by pg_dumpall but was not found in the same directory as "C:/Programs/pgsql/bin/pg_dumpall".
Check your installation.
Obviously there is something wrong with the line
"The program "pg_dump" is needed by pg_dumpall but was not found in the same directory as "C:/Programs/pgsql/bin/pg_dumpall". ":
the directory should be "C:/Programs/pgsql/bin", not "C:/Programs/pgsql/bin/pg_dumpall"... I'm sure it is something trivial related to sh, but I don't understant what it is... the environment for the command is:
set beginlibpath=c:\programs\pgsql\bin;c:\programs\pgsql\lib;
SET USE_HOSTS_FIRSTS=Y
set LANG=it_IT
set PGDATA=D:\var\postgres9\data
Thanks for any hint!