PostgeSQL unable to restore database from previous version 7.2 to 7.3

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

Browse pgsql-cygwin by date

  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