Re: Can't rename an existnig DB because it doesn't exist???

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" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can't rename an existnig DB because it doesn't exist???
Date: 2008-03-13 19:02:28
Message-ID: 27308.1205434948@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:
> Can't rename a db, complains that it doesn't exist. Yet psql -l
> shows that it does and I can connect to it ???
>
> mmdcc228_SETUP(120)% psql stdb2 -c "alter database stdb rename to
> stdb_tmp"
>
> ERROR: database "stdb" does not exist

Hmm, I wonder if this could be a corrupt-index problem. If you
try "select * from pg_database where datname = 'stdb'", do you
get a row? Does "REINDEX pg_database" help?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2008-03-13 19:02:36 Re: postgre vs MySQL
Previous Message Joshua D. Drake 2008-03-13 18:32:29 Re: Recomendations on raid controllers raid 1+0