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>
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 ?! |