Contents of data/base/<oid> and no corresponding entry in pg_database

From: Kjetil Jørgensen <kjetijor(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Contents of data/base/<oid> and no corresponding entry in pg_database
Date: 2013-05-21 20:21:51
Message-ID: CAHt21WjuanAhdJgAvxNCdyF5Bi42h2iOSchv-pAGLgF_9Cf5mA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

(We're running postgres 9.2.X)

from reading
http://www.postgresql.org/docs/9.2/static/storage-file-layout.html the
directories under $PG_DATADIR/data/base should correspond to an actual
database. I've however found a few directories in $PG_DATADIR/data/base
where select datname from pg_database where oid = <oid> returns 0 rows.

The machine does have "high churn" on databases and have suffered a few
crashes, is it possible for things to get left behind in
$PG_DATADIR/data/base after recovery ? or am I possibly missing things
still in use, that's reflected elsewhere ?

Additionally, the directory and it's contents haven't been touched in quite
a while as well, and some of them do correspond to being touched at the
machine having had a hard crash.

The reason I'm asking is that space used as reported by pg_database_size is
off by a LOT compared to df on the filesystem (4-5TB as oposed to df/du
agreeing on 9-ish TB).

Cheers,
--
Kjetil Jørgensen <kjetijor(at)gmail(dot)com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2013-05-21 20:42:45 Re: replanning Prepared Statements ?
Previous Message hubert depesz lubaczewski 2013-05-21 20:17:44 SR Slave leaves off every 32nd wal segment ?!