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