Re: Catch-22

> "Gauthier, Dave" <dave.gauthier@intel.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
On Mar 17, 2008, at 10:45 AM, Gauthier, Dave wrote:

> stdb=# select oid,ctid,xmin,xmax,datname from pg_database
> stdb-# ;
>  oid   |  ctid  |  xmin   | xmax |   datname
> --------+--------+---------+------+--------------
>  10819 | (0,1)  |     592 |    0 | postgres
>      1 | (0,6)  |     585 |    0 | template1
>  10818 | (0,7)  |     586 |    0 | template0
> 823888 | (0,13) |  761678 |    0 | cells_dev
>  19810 | (0,49) |  497579 |    0 | stdb2
> 597974 | (3,2)  | 2346578 |    0 | stdb
>  19882 | (3,3)  | 2346580 |    0 | stdb_standby
>  16384 | (3,4)  | 2364457 |    0 | cells
> (8 rows)
>
> mmdcc228> dropdb stdb
> ERROR:  database "stdb" does not exist
> STATEMENT:  DROP DATABASE stdb;
>
> dropdb: database removal failed: ERROR:  database "stdb" does not
> exist
> mmdcc228>

You left out the directory listings Tom asked for.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com