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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jerry Asher <jerry(at)theashergroup(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?
Date: 2001-09-04 15:30:51
Message-ID: 26537.999617451@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jerry Asher <jerry(at)theashergroup(dot)com> writes:
> 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.

Hm. What does psql -l show? Can you connect to *any* database? (If
so, try "vacuum pg_database" and then "checkpoint".)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-04 15:33:30 Re: [HACKERS] getting the oid for a new tuple in a BEFORE
Previous Message Eric Kolve 2001-09-04 15:04:50 internet week article