I found the problem. The CREATE TABLE statements from the
Postgre95 dump had "archive = none" at the end, right before
the semicolon. Once I took these out to fix those errors,
the import went smoothly.
So, out of curiosity, what is the "archive = none" all about
and why is it no longer valid?
On Thu, Jul 12, 2001 at 01:00:27PM -0400, craig@tool.net wrote:
> Is it possible to import a dump from Postgresql95
> into Postgres 7.x? I get plenty of errors from the
> old dumpfile, so I assume there is a trick to it
> or it can not be done directly. If you could give
> me a quick point in the right direction I will be
> your best friend :)
>
> Later,
> --
> \ Craig "Cowboy" McDaniel
> /_\ Software Engineer
> /_/_\ Internet Tool & Die
> /_/_/_\ craig@tool.net
> /_/_/_/_\ (502) 584-8665 ext 108
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
\ Craig "Cowboy" McDaniel
/_\ Software Engineer
/_/_\ Internet Tool & Die
/_/_/_\ craig@tool.net
/_/_/_/_\ (502) 584-8665 ext 108