Tom Lane wrote:
Cyril SCETBON <scetbon@xxxxxxx> writes:
Tom Lane wrote:
So which database has OID 100456?
select datname from pg_database where oid = 100456;
it's not a database oid but a tablespace oid
[ squint... ] There shouldn't be any files directly under a tablespace
directory, except possibly a PG_VERSION marker file. What should be
there are per-database directories, and those are what contain the
files. So that's why I assumed 100456 must be a database directory.
under the tablespace directory I got :
PG_VERSION file and oidtbs directory
You sure it isn't?
sure
regards, tom lane
--
Cyril SCETBON