Skip site navigation (1) Skip section navigation (2)

using pg_dump version lower than server version

From: Saranya Sivakumar <sarlavk(at)yahoo(dot)com>
To: pgsqlnovice <pgsql-novice(at)postgresql(dot)org>
Subject: using pg_dump version lower than server version
Date: 2007-01-03 16:25:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi All,

I am having trouble to dump a table on postgres 8.1.5 version using pg_dump 7.3/7.4. 

I get the following message

pg_dump: server version: 8.1.5; pg_dump version: 7.4.14
pg_dump: proceeding despite version mismatch
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  column "datpath" does not exist
pg_dump: The command was: 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'

I have tried dumping using the 8.1.5 version of pg_dump and restore using 7.3, but that gives errors too, and I have to manually edit and comment out the lines causing problem.

Is there a workaround for this?


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


pgsql-novice by date

Next:From: Tom LaneDate: 2007-01-03 16:37:51
Subject: Re: using pg_dump version lower than server version
Previous:From: Bruno Wolff IIIDate: 2007-01-02 17:12:57
Subject: Re: Write to file from pgplsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group