Re: cannot dump structures - Mailing list pgsql-general

From Tom Lane
Subject Re: cannot dump structures
Date
Msg-id 19886.1197040347@sss.pgh.pa.us
Whole thread Raw
In response to cannot dump structures  (Martin Korous <Mortals@seznam.cz>)
Responses Re: [GENERAL] cannot dump structures
List pgsql-general
=?us-ascii?Q?Martin=20Korous?= <Mortals@seznam.cz> writes:
> and in pg_log is message:
> STATEMENT:  SELECT (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as
encoding,datpath FROM pg_database WHERE datname = 'dbname' 
> ERROR:  column "datpath" does not exist at character 113

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.

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.

> I know that this message means that pg_dump is old version, but its impossible, the pg_dump binary file is from
dbserver.

You need to reconsider "impossible".  Maybe your search path
isn't what you think it is.

            regards, tom lane

pgsql-general by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: Replication using WAL files
Next
From: Ron St-Pierre
Date:
Subject: Re: how to redirect output to a file