"Gauthier, Dave" <[EMAIL PROTECTED]> writes:
> 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
> "ce
9882 1663 524
"cells" 16384 1663 524
mmdcc228> ls base/
1 10818 10819 16384 16460 19810 19882 597974 823888
-Original Message-
From: Erik Jones [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 12:20 PM
To: Gauthier, Dave
Cc: Tom Lane; pgsql-general@postgresq
On Mon, Mar 17, 2008 at 08:45:59AM -0700, 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)
"Gauthier, Dave" <[EMAIL PROTECTED]> 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,x
.org
Subject: Re: [GENERAL] Catch-22
"Gauthier, Dave" <[EMAIL PROTECTED]> 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
"Gauthier, Dave" <[EMAIL PROTECTED]> 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
Hi:
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"), I've done a full
dump of the DB and want to delete/recreate it with the backup. But I
can't "dr
