Re: Catch-22

Woops, sorry....

mmdcc228> more global/pg_database
"postgres" 10819 1663 524
"template1" 1 1663 524
"template0" 10818 1663 524
"cells_dev" 823888 1663 524
"stdb2" 19810 1663 524
"stdb" 597974 1663 524
"stdb_standby" 19882 1663 524
"cells" 16384 1663 524

mmdcc228> ls base/
1 10818 10819 16384 16460 19810 19882 597974 823888

-----Original Message-----
From: Erik Jones [mailto:erik(at)myemma(dot)com]
Sent: Monday, March 17, 2008 12:20 PM
To: Gauthier, Dave
Cc: Tom Lane; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Catch-22

> "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
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(r)
erik(at)myemma(dot)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