From: | craig(at)tool(dot)net |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Dump from Postgresql95 |
Date: | 2001-07-12 19:11:38 |
Message-ID: | 20010712151138.B15080@tool.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)tool(dot)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(at)tool(dot)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(at)tool(dot)net
/_/_/_/_\ (502) 584-8665 ext 108
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-07-12 20:07:29 | Re: Dump from Postgresql95 |
Previous Message | Guy Fraser | 2001-07-12 19:06:55 | Re: A small question about Red Hat |