| 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: | Whole Thread | Raw Message | 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 |