Re: [GENERAL] cannot dump structures

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

In response to

Responses

Browse pgsql-general by date

  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?