Upgrading a database with pg_dumpall / psql ...

From: "Marc G(dot) Fournier From": <scrappy(at)hub(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrading a database with pg_dumpall / psql ...
Date: 2007-11-15 04:12:33
Message-ID: fhggvh$26dp$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This is one of those 'stupid questions I hate to ask' ... I've rechecked the
docs to make sure I haven't missed something stupid, and unless I'm blind,
I haven't ...

I'm trying to upgrade a database from 8.1 -> 8.2 ... on a seperate server,
with 8.2 pg_dump already installed, I do:

pg_dumpall -U pgsql -h <host> > dump.sql

Works great.

Then I upgrade the 8.1 server to 8.2, initdb, and try and do the restore
doing:

psql -U pgsql -h <host> template1 < dump.sql

And get a whack of:

invalid command \n
invalid command \
invalid command \ni
invalid command \
invalid command \n
invalid command \n
invalid command \.

and other errors ... so I'm obviously missing something that is probably
obvious to everyone else ... am I dumping wrong? If I use '--inserts',
it, of course, works like a charm, its only when I try and use COPY ...

--
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2007-11-15 05:21:59 Re: postgres bogged down beyond tolerance
Previous Message Tomeh, Husam 2007-11-15 01:32:21 Error: duplicate key violates unique constraint - "pg_toast_3270368541_index