upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?

Поиск
Список
Период
Сортировка
От Jerry Asher
Тема upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?
Дата
Msg-id 4.3.2.7.2.20010904071651.00dcf340@hollyjerry.org
обсуждение исходный текст
Ответы Re: upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?
Список pgsql-general
I upgraded from 7.1.2 to 7.1.3.  Upon starting 7.1.3, I tried to use psql
to access my databases.  But whether I use psql -U foo, or psql -d foo, I
am told that:

   psql: FATAL 1: Database "foo" does not exist in the system catalog.

When I examine /usr/local/pgsql/data, it certainly looks as though my
databases are still on the disk.  How do I get postgresql to recognize them?

More details:

Since I was upgrading from 7.1.2 to 7.1.3, I didn't bother (my mistake)
backing up the system.  I didn't call initdb explicitly.  I did:

./configure --with-x --with-tcl
make
make check
make install

I am worried that the make check may have done an initdb.

Would initdb wipe out my existing databases?

How do I get my existing databases to be reentered into the system catalog?

Thank you,

Jerry Asher


=====================================================
Jerry Asher                       jerry@hollyjerry.org
1678 Shattuck Avenue Suite 161    Tel: (510) 549-2980
Berkeley, CA 94709                Fax: (877) 311-8688


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: nested SQL with SPI
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Unexpected Behavior Using a Rule With Multiple Actions (Long)