< You're running a 7.something pg_dump against an 8.something server.
< This will not work because that pg_dump doesn't know about 8.x
< catalog layout.
its standard answer for message `ERROR: column "datpath"....`
but I wrote:
DATABASE:
#/var/pgsql/bin/pg_dump --version
pg_dump (PostgreSQL) 8.2.5
and
WEBSERVER in CHROOT:
#chroot /usr/local/chroot/apache_phpPgAdmin /var/pgsql/bin/pg_dump --version
pg_dump (PostgreSQL) 8.2.5
< My advice is never, never, never use the -i option to pg_dump.
< It is generally only useful for shooting yourself in the foot,
< as is happening here.
dump only data is not good too, works only with -i
< You need to reconsider "impossible". Maybe your search path
< isn't what you think it is.
I dont use search path, i wrote absolute path:
$cmd = '/var/pgsql/bin/pg_dump dbname -U username -h hostname -s -i';
pg_dump out of chroot work
in chroot doesnt work...mystery
regards
Martin Korous