Thread: using pg_dump version lower than server version
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?
Thanks
Saranya
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?
Thanks
Saranya
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Saranya Sivakumar <sarlavk@yahoo.com> writes: > I am having trouble to dump a table on postgres 8.1.5 version using pg_dump 7.3/7.4. Why would you expect that to work? An old pg_dump can't be expected to understand system catalog changes that happened after it came out. > 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 tomanually edit and comment out the lines causing problem. Going backwards is always going to cause problems, especially across multiple releases --- there's a pretty large feature gap between 7.3 and 8.1. Why in the world would you want to, anyway? regards, tom lane