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@hollyjerry.org
1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980
Berkeley, CA 94709 Fax: (877) 311-8688