< 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
