Oliver Siegmar <[EMAIL PROTECTED]> writes:
> On Tuesday 02 August 2005 19:49, Tom Lane wrote:
>> Would you look at pg_class in particular (file 1259) and confirm that it
>> contains only names of Postgres system catalogs and indexes, no tables
>> of your own?
> Everything in this file seems to be
On Tuesday 02 August 2005 19:49, Tom Lane wrote:
> Oliver Siegmar <[EMAIL PROTECTED]> writes:
> > I did a hexdump on the files within the tabelspace directory...no
> > business data at all, only postgres internals (I saw a lot of function
> > names and datatypes).
>
> Would you look at pg_class in
Oliver Siegmar <[EMAIL PROTECTED]> writes:
> I did a hexdump on the files within the tabelspace directory...no business
> data at all, only postgres internals (I saw a lot of function names and
> datatypes).
Would you look at pg_class in particular (file 1259) and confirm that it
contains only n
On Tuesday 02 August 2005 18:42, Tom Lane wrote:
> > I dropped the database with 'DROP DATABASE xxx;' without any problems
> > (after the tablespace run out of space).
>
> How exactly do you know that OID 595675173 is the database you dropped,
> and not that of some other DB?
I don't know that for
Michael Fuhr <[EMAIL PROTECTED]> writes:
> ... Is there any danger in Oliver removing the directory if
> pg_database doesn't know about the database oid?
No, but I'd counsel not doing so until we're certain we can't learn any
more about what happened.
> Should he shut down the postmaster before r
Oliver Siegmar <[EMAIL PROTECTED]> writes:
> On Tuesday 02 August 2005 17:01, Michael Fuhr wrote:
>> Hmmm...based on the file names, it looks like the directory contains
>> only system tables. Do you know what database this was?
> Yes, a business database - not a system one. The database were c
On Tuesday 02 August 2005 17:01, Michael Fuhr wrote:
> Hmmm...based on the file names, it looks like the directory contains
> only system tables. Do you know what database this was?
Yes, a business database - not a system one. The database were created using
template0.
> Did you
> explicitly
On Tue, Aug 02, 2005 at 03:25:53PM +0200, Oliver Siegmar wrote:
> On Tuesday 02 August 2005 15:16, Michael Fuhr wrote:
> > > This directory indeed contains a subdirectory named 595675173 (the
> > > ghost's database oid ;-))
> >
> > Does that subdirectory contain anything? That's part of why I aske
On Tuesday 02 August 2005 15:16, Michael Fuhr wrote:
> > This directory indeed contains a subdirectory named 595675173 (the
> > ghost's database oid ;-))
>
> Does that subdirectory contain anything? That's part of why I asked
> for the "ls -alR" output; I was also curious to see if there were
> an
On Tue, Aug 02, 2005 at 08:00:28AM +0200, Oliver Siegmar wrote:
> On Monday 01 August 2005 22:15, Michael Fuhr wrote:
> > On Mon, Aug 01, 2005 at 09:28:07PM +0200, Oliver Siegmar wrote:
> > > How may I delete the tablespace manually?
> >
> > Perhaps a better question to ask is: why does pg_tablespa
On Monday 01 August 2005 22:15, Michael Fuhr wrote:
> On Mon, Aug 01, 2005 at 09:28:07PM +0200, Oliver Siegmar wrote:
> > template1=# select * from pg_tablespace_databases(594611987);
> > pg_tablespace_databases
> > -
> > 595675173
> > (1 row)
> >
> > Aha...so there seems
On Mon, Aug 01, 2005 at 09:28:07PM +0200, Oliver Siegmar wrote:
>
> template1=# select * from pg_tablespace_databases(594611987);
> pg_tablespace_databases
> -
> 595675173
> (1 row)
>
> Aha...so there seems to be a database associated to this tablespace - lets
> see
>
Hello,
I'm unable to drop a recently created tablespace (the partition on which the
tablespace relies on, run out of space - postgresql seems to have a problem,
now):
template1=# drop tablespace disk1;
ERROR: tablespace "disk1" is not empty
Huh? Okay...lets dig into...
template1=# select
13 matches
Mail list logo
