Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
