Обсуждение: upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?

Поиск
Список
Период
Сортировка

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

От
Jerry Asher
Дата:
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


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

От
Tom Lane
Дата:
Jerry Asher <jerry@theashergroup.com> writes:
> 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.

Hm.  What does psql -l show?  Can you connect to *any* database?  (If
so, try "vacuum pg_database" and then "checkpoint".)

            regards, tom lane