<  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

Reply via email to