| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Saranya Sivakumar <sarlavk(at)yahoo(dot)com> |
| Cc: | pgsqlnovice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: using pg_dump version lower than server version |
| Date: | 2007-01-03 16:37:51 |
| Message-ID: | 11810.1167842271@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Saranya Sivakumar <sarlavk(at)yahoo(dot)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 to manually 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Cox | 2007-01-03 21:51:55 | Excess idle processes, leaking WAL logs? |
| Previous Message | Saranya Sivakumar | 2007-01-03 16:25:01 | using pg_dump version lower than server version |