we try to create a directory running version 11.3. on windows 2012 r2.
The pg_dump output lists an error for 2 files:
pg_dump: could not stat file "(file_path)": Unknown error
The files are 5.8 GB and 2.2 GB in size.
We reproduced the behaviour on 11.4 and 10.9.
A pg_restore however works fine and lists no error.
Has anybody an explanation, ideas on this?
It looks like it is a bug, you can refer the below mail thread.
Could you please confirm the Postgresql binary version, which you are using to take a dump.
thanks for the quick reply.
The original error occured on windows 2012 r2 using postgresql version
"PostgreSQL 11.3, compiled by Visual C++ build 1914, 64-bit"
Then I reran the pg_dump on my notebook (Windows 10 Pro 1803) twice.
Once on PostgreSQL 11.3, then on PostgreSQL 10.9.
...I always used the pg_dump binary that comes with the postgresql server on the server itself.