From: | "Brooks, Jason" <Jason(dot)Brooks(at)windriver(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Restoring from older pg_dump files |
Date: | 2007-04-13 23:04:54 |
Message-ID: | 796EF5B39103EE45A04CC2FFFCF130B9D80790@ala-mail08.corp.ad.wrs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)brooks(at)windriver(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-04-13 23:48:03 | Re: Restoring from older pg_dump files |
Previous Message | Tom Lane | 2007-04-13 14:08:28 | Re: [GENERAL] Increasing the shared memory |