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 [EMAIL PROTECTED] 1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980 Berkeley, CA 94709 Fax: (877) 311-8688 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
