Re: pg_dumpall question
Johann Spies wrote:
>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
/usr/lib/postgresql/dumpall is where the binaries of the previously-
installed release are saved so that they can be used in upgrading.
>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
It looks as though the path has got dropped; this should have been
/usr/lib/postgresql/dumpall/psql
The reason is probably that you are running these commands directly
rather than under the control of the postgresql-dump script.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And he said to them all, If any man will come after
me, let him deny himself, and take up his cross daily,
and follow me." Luke 9:23
Reply to: