PostgeSQL unable to restore database from previous version 7.2 to 7.3

Поиск
Список
Период
Сортировка
От Martin_Hurst@dom.com
Тема PostgeSQL unable to restore database from previous version 7.2 to 7.3
Дата
Msg-id OF57C1F6DE.4E52D6BA-ON85256C93.0071D049@pa.dominionnet.com
обсуждение исходный текст
Список 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@postgresql.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




В списке pgsql-cygwin по дате отправления:

Предыдущее
От: Martin_Hurst@dom.com
Дата:
Сообщение: PostgeSQL unable to restore database from previous version 7.2 to 7.3
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: PostgeSQL unable to restore database from previous version 7.2 to 7.3