From: | Martin_Hurst(at)dom(dot)com |
---|---|
To: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | PostgeSQL unable to restore database from previous version 7.2 to 7.3 |
Date: | 2002-12-18 20:44:11 |
Message-ID: | OF57C1F6DE.4E52D6BA-ON85256C93.0071D049@pa.dominionnet.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
I answered my own question:
I need to issue this command,
psql template1 < backup
----- Forwarded by Martin Hurst/CAMP/DC/CNG on 12/18/2002 03:45 PM -----
Martin Hurst
To: pgsql-cygwin(at)postgresql(dot)org
12/18/2002 cc:
03:33 PM Subject: [CYGWIN] PostgeSQL unable to restore database from previous
version 7.2 to 7.3
I created the backup of the 7.2 database, removed the 7.2 database, and
installed the 7.3 database.
When I try to restore into the new 7.3 version, I'm getting this message:
------------------------------------------------------
$ psql < backup
FATAL: Database "hurstm2" does not exist in the system catalog.
psql: FATAL: Database "hurstm2" does not exist in the system catalog.
------------------------------------------------------
The 7.3 Postgres was created in the eact same location as the 7.2 cluster.
The user "hurstm2" issued the "initdb -D ..." command to created the
cluster.
So what would be causing this type of error message?
Thanks,
-Martin
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-12-18 22:59:26 | Re: PostgeSQL unable to restore database from previous version 7.2 to 7.3 |
Previous Message | Martin_Hurst | 2002-12-18 20:33:47 | PostgeSQL unable to restore database from previous version 7.2 to 7.3 |