Postgres Pro
Downloads
Home   >   mailing lists

PostgeSQL unable to restore database from previous version 7.2 to 7.3 - Mailing list pgsql-cygwin

From Martin_Hurst@dom.com
Subject PostgeSQL unable to restore database from previous version 7.2 to 7.3
Date
Msg-id OF5C9D6508.3AD1E031-ON85256C93.00708B45@pa.dominionnet.com
Whole thread Raw
List pgsql-cygwin
Tree view 
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

pgsql-cygwin by date:

Previous
From: "King_Henree@yahoo.com"
Date:
Subject: PostgeSQL equivalent to Oracle RAW column type???
Next
From: Martin_Hurst@dom.com
Date:
Subject: PostgeSQL unable to restore database from previous version 7.2 to 7.3