postgres 9.1 pgsql_tmp directory location of specific database?

shehab adean sherif wrote:

where should be the location of pgsql_tmp directory of specific

database i've searched in

/var/lib/postgresql/9.1/main/base/database OID and i didn't find it,

should i create it by my self?

This directory does not belong to a database, but to a tablespace.
For the default tablespace, it would be in $PGDATA/base.

You shouldn't create the directory, it will be created when it
is needed.

Yours,
Laurenz Albe