Re: Getting weird pg_tblspc error, has anyone seen this before?

Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:
> The exact error is(as reported from PG Admin III):
> ERROR: could not open tablespace directory "pg_tblspc": No such file or
> directory

This must be coming from calculate_database_size(). Is
$PGDATA/pg_tblspc actually missing? If the guy has no custom
tablespaces, I can believe that nothing except pg_database_size()
or pg_tablespace_size() would try to touch that subdirectory, so
he might not otherwise notice that it'd gone missing.

> The user also claims that the error only occurs when running the query
> locally i.e. localhost, but when he runs the query from a different PC
> it works and he gets a result set back.

That's kind of in the category of "I don't believe it". I suspect pilot
error, ie he was talking to a different postmaster.

regards, tom lane