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

Jerry Asher <jerry@theashergroup.com> writes:
> How do I tell postgres where to find my databases?

A -D switch when starting the postmaster is sufficient.  If you are not
using one then the configure-time default is assumed.  Is it possible
that you built 7.1.3 with a different default than 7.1.2 had, and it's
now running in some other data directory than you think it is?

If you are getting as far as "Database "foo" does not exist in the
system catalog" then the postmaster is in a valid data directory,
but perhaps it's one that's leftover from a test setup, or some such?

            regards, tom lane