| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | stevefoss <sfossum(at)autotraninc(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Migration/Upgrade Problems |
| Date: | 2009-04-17 21:53:38 |
| Message-ID: | 29339.1240005218@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> Your library problems are likely because you just copied the binary? I
> assume you didn't actually install postgresql.
That's what it looked like to me --- you can't just copy an executable
that's been built on a far newer platform. However, you could run
pg_dumpall on the newer machine and have it connect to the old server
across the network.
> As far as running older
> versions of pg_dumpall, I am not even sure 8.3 will work on 7.0.
It's supposed to, and I do test it on occasion ;-). The main gotcha I'd
watch out for is that you should probably use --column-inserts instead
of relying on COPY mode for a server that old.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaśkiewicz | 2009-04-17 22:34:46 | Re: Common table expressions and threaded comments |
| Previous Message | Scott Marlowe | 2009-04-17 17:24:39 | Re: Set search_path for session |