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