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. You sure it isn't? regards, tom lane
