| From: | Jerry Asher <jerry(at)theashergroup(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | upgrade from 7.1.2 to 7.1.3 and uh, where are my databases? |
| Date: | 2001-09-04 14:17:25 |
| Message-ID: | 4.3.2.7.2.20010904071651.00dcf340@hollyjerry.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)hollyjerry(dot)org
1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980
Berkeley, CA 94709 Fax: (877) 311-8688
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-09-04 14:25:21 | Re: Unexpected Behavior Using a Rule With Multiple Actions (Long) |
| Previous Message | Jan Wieck | 2001-09-04 14:10:48 | Re: Is it possible to default all number data to numeric type? |