Re: Catch-22

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Catch-22
Date: 2008-03-17 15:33:15
Message-ID: 10587.1205767995@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> writes:
> After running intoa problem last week where I cannot rename an existing
> DB because it's reported to not exist (I can attach to it and query OK,
> but rename gives... "database foo does not exist"),

Would you show the results of

select oid,ctid,xmin,xmax,datname from pg_database

as well as the contents of $PGDATA/global/pg_database and a directory
listing of $PGDATA/base?

regards, tom lane

In response to

  • Catch-22 at 2008-03-17 14:58:44 from Gauthier, Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dee 2008-03-17 15:34:30 Re: beginner: what permissions required to install on windows 2000+
Previous Message A. Kretschmer 2008-03-17 15:33:05 Re: Get info about indexes