From: | Martin Korous <Mortals(at)seznam(dot)cz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] cannot dump structures |
Date: | 2007-12-10 15:07:36 |
Message-ID: | 1824.2729-29882-315633005-1197299256@seznam.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
< 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-12-10 15:30:20 | Re: Re: [GENERAL] cannot dump structures |
Previous Message | Tom Lane | 2007-12-10 15:07:16 | Re: Simpler dump? |