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

At 07:17 AM 9/4/01, you wrote:
>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?

Just to clarify (because I am thinking I need to do a

./configure --datadir=/usr/local/pgsql/data

The directory /usr/local/pgsql/share contains:

global.bki
global.description
pg_hba.conf.sample
pg_ident.conf.sample
pgaccess/
postgresql.conf.sample
template1.bki
template1.description

While the directory /usr/local/pgsql/data contains:

PG_VERSION
base/
global/
pg_hba.conf
pg_ident.conf
pg_xlog
postgresql.conf
postmaster.opts
postmaster.pid

How do I tell postgres where to find my databases?

Thanks,

Jerry

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