cannot create temporary directory "pg_tblspc/16386/PG_16_202307071/pgsql_tmp": No such file or directory

Venugopal Ajith 0

While trying to create index receiving this error "cannot create temporary directory "pg_tblspc/16386/PG_16_202307071/pgsql_tmp": No such file or directory"

Adithya Prasad K 90 Reputation points Microsoft External Staff

2025-03-04T13:20:56.6333333+00:00

Hi Venugopal Ajith,
Thank you for reaching out and posting the query.
The error "cannot create temporary directory 'pg_tblspc/16386/PG_16_202307071/pgsql_tmp': No such file or directory" typically indicates that PostgreSQL is unable to create a temporary directory needed for index creation. This can occur due to Missing Directory, Insufficient Permissions, Disk Space Issues.
Check Disk Space: Ensure that there is enough free space on the disk where PostgreSQL is installed. You can use commands like df -h on Linux to check disk usage.
Verify Directory Structure: Manually check if the directory pg_tblspc/16386/PG_16_202307071/ exists. If not, you may need to recreate it or adjust your PostgreSQL configuration.
Adjust Permissions: Ensure that the PostgreSQL user has the necessary permissions to write to the data directory. You can change permissions using chmod or change ownership using chown.
Review PostgreSQL Configuration: Check the postgresql.conf file for any settings that might limit temporary file creation, such as temp_file_limit.
Restart PostgreSQL: Sometimes, simply restarting the PostgreSQL service can resolve temporary issues related to file creation.
Consult Logs: Review PostgreSQL logs for any additional error messages that might provide more context about the issue. Logs can often be found in the pg_log directory within the data directory.
I would request you to refer the below mentioned links for more information.
https://pganalyze.com/docs/install/azure_database/01_configure_azure_instance
https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview
https://learn.microsoft.com/en-us/azure/postgresql/

I hope this information helps. Please do let us know if you have any further queries. 
Adithya Prasad K 90 Reputation points Microsoft External Staff

2025-03-05T08:39:44.49+00:00

Hi Venugopal Ajith,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Adithya Prasad K 90 Reputation points Microsoft External Staff

2025-03-06T08:42:08.53+00:00

Hi Venugopal Ajith,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

cannot create temporary directory "pg_tblspc/16386/PG_16_202307071/pgsql_tmp": No such file or directory

Your answer