Postgres Pro
Downloads
Home   >   mailing lists

Thread: Dump from Postgresql95

Dump from Postgresql95

From
craig@tool.net
Date:
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

Re: Dump from Postgresql95

From
craig@tool.net
Date:
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

Re: Dump from Postgresql95

From
Bruce Momjian
Date:
> 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?

That was an old Berkeley feature, never used by us.  Something about
archiving to cdrom.  We silently ignored it for many releases, then
finally ripped it out.  We never anticipated a Postgres95 users still
having useful data.  :-)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026