Skip site navigation (1) Skip section navigation (2)

Restoring from older pg_dump files

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: (view raw or whole thread)
Lists: pgsql-admin

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

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

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


pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2007-04-13 23:48:03
Subject: Re: Restoring from older pg_dump files
Previous:From: Tom LaneDate: 2007-04-13 14:08:28
Subject: Re: [GENERAL] Increasing the shared memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group