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

On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave
<dave(dot)gauthier(at)intel(dot)com> wrote:
>
>
> V8.2.0 on Linux

Look into updating, there were some serious bugs fixed between 8.2.0
and 8.2.6 It's a pretty simple thing, since you don't need to dump /
reload for it.

>
> 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
>
> mmdcc228_SETUP(121)% psql -l
>
> List of databases
>
> Name | Owner | Encoding
>
> --------------+----------+----------
> stdb | dfgauthi | UTF8
>
> stdb2 | dfgauthi | UTF8
>
> stdb_standby | dfgauthi | UTF8

Very strange. maybe the name has a space in it?

Try running this query:
select '|'||datname||'|' from pg_database ;
and see if you have a space or something in there. can you run the
alter database rename from the command line and just not from psql?