Restoring from older pg_dump files - Mailing list pgsql-admin

From Brooks, Jason
Subject Restoring from older pg_dump files
Date
Msg-id 796EF5B39103EE45A04CC2FFFCF130B9D80790@ala-mail08.corp.ad.wrs.com
Whole thread Raw
Responses Re: Restoring from older pg_dump files
Re: Restoring from older pg_dump files
List pgsql-admin
Hello,

I have a data file dumped from a pgsql database version 7.1.2.  I am
having troubles restoring this data to a new database server version
8.1.5.  Are there some gotcha's involved, did the format change, or some
such?

I have used the createdb command to make the basic database.  it's when
I use the \i option in psql that I see invalid commands, syntax errors,
invalid roles, etc.

The original file was created with pg_dump -cou.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jason Brooks ~ (503) 641-3440 x1861
      Direct ~ (503) 924-1861
Email to: jason.brooks@windriver.com
Twiki: http://twiki.wrs.com/do/view/Main/JasonBrooks

Senior Systems Administration Analyst
Wind River Systems
8905 SW Nimbus ~ Suite 255
Beaverton, Or 97008

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Increasing the shared memory
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Restoring from older pg_dump files