Re: 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