Re: Upgraded to Red Hat 7.1, now my DB is toast?

Поиск
Список
Период
Сортировка
От Nabil Sayegh
Тема Re: Upgraded to Red Hat 7.1, now my DB is toast?
Дата
Msg-id 991833144.3700.0.camel@billy.labor.localnet
обсуждение исходный текст
Ответ на Upgraded to Red Hat 7.1, now my DB is toast?  ("J. J. Franzen" <jfranzen@cinenet.net>)
Список pgsql-novice
On 02 Jun 2001 00:51:56 -0700, J. J. Franzen wrote:
> dir...  Does this mean that DBs made with 6.whatever are incompatible
> with 7.whatever?  And if so, is there a way to recover/upgrade/save the
> db I already have?  Thanks in advance for any advice.  Later,

Exactly. Upgrading to 7.1 requires an initdb.
I'd recommend:

pg_dump -D dbname >dbname.sql (or use pg_dumpall)

and after installing 7.1 (and initdb)

psql -f dbname.sql

--
 Nabil Sayegh



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL problem with functions
Следующее
От: "Shawhan, Douglas (GEAE, GECC)"
Дата:
Сообщение: selecting a column average into table