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 [EMAIL PROTECTED] 1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980 Berkeley, CA 94709 Fax: (877) 311-8688 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
