Re: Dump from Postgresql95

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

In response to

Responses

Browse pgsql-admin by date

  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