pg_dumpall question
Thanks to Oliver (and maybe others who helped him) for the binary
packages for postgresel 7.1 for potato.
I have struggled a bit to get my old data (6.5.3) into 7.1 because the
dump script would not dump my old data. So I restored the old data
from previous dumps I made.
I tried out the (for me new ) /usr/lib/postgresql/dumpall/pg_dumpall
on my 7.1 database which resulted in the following error.
---------------------------------------
$/usr/lib/postgresql/dumpall/pg_dumpall
/usr/lib/postgresql/dumpall/pg_dumpall: /psql: No such file or
directory
\connect template1
select datdba into table tmp_pg_shadow from pg_database where
datname = 'template1';
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
drop table tmp_pg_shadow;
copy pg_shadow from stdin;
/usr/lib/postgresql/dumpall/pg_dumpall: /psql: No such file or
directory
--------------------------------
I do not see any reference to /psql in /etc/postgresql/postgresql.env
which is used by pd_dumpall.
pg_dump js -o -c -f /home/js/psql/jsdb.out
works without a problem.
Any ideas to eliminate the problem with pg_dumpall trying to use a
directory named /psql?
Johann
--
J.H. Spies - Tel. 082 782 0336. Posbus 4668, Tygervallei 7536
"Thy word have I hid in mine heart, that I might not
sin against thee." Psalm 119:11
Reply to: