Hi, While testing for a feature I got this tablespace related error while running script. The Issue is not reproducible everytime, but If I am running the same set of commands after 2-3 runs I am able to reproduce the same error.
--first run - pass # master slave setup + mkdir /tmp/test_bkp/tblsp01 + ./psql postgres -p 5432 -c 'create tablespace tblsp01 location '\''/tmp/test_bkp/tblsp01'\'';' CREATE TABLESPACE + ./psql postgres -p 5432 -c 'create table test (a text) tablespace tblsp01;' CREATE TABLE #cleanup --next #master-slave setup + mkdir /tmp/test_bkp/tblsp01 + ./psql postgres -p 5432 -c 'create tablespace tblsp01 location '\''/tmp/test_bkp/tblsp01'\'';' CREATE TABLESPACE + ./psql postgres -p 5432 -c 'create table test (a text) tablespace tblsp01;' ERROR: could not open file "pg_tblspc/16384/PG_13_202004074/13530/16388": No such file or directory Attaching command and script which help to reproduce it. [edb@localhost bin]$ while sh pg_tblsp_wal.sh; do :; done Thanks & Regards, Rajkumar Raghuwanshi
pg_tblsp_wal.sh
Description: application/shellscript
