pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16813: error to solve the problem "Windows could not stat file - over 4GB"
2+ messages / 2 participants
[nested] [flat]
* BUG #16813: error to solve the problem "Windows could not stat file - over 4GB"
@ 2021-01-07 14:02 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-01-07 14:02 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: c_michal@poczta.onet.pl
The following bug has been logged on the website:
Bug reference: 16813
Logged by: Michal C
Email address: c_michal@poczta.onet.pl
PostgreSQL version: 13.1
Operating system: Windows 10 64 bit
Description:
Sorry my english is terrible
I tested part of the solution https://commitfest.postgresql.org/30/2189/
for error
https://www.postgresql.org/message-id/15942-58fbac022aa82a2f@postgresql.org
the above solution should solve this problem as well
my PG version: PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
testing method
step 1:
show data_directory;
step 2:
copy (select
to_char(number,'0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000')
from generate_series(1,1024*1024*2,1) d(number)) to 'C:\Program
Files\PostgreSQL\13\data\my_data_01.txt';
step 3:
with files as (select * from pg_ls_dir('.') f(file) where file ilike
'my_data_01.txt')
, files_info as (select file, (pg_stat_file(file)).* from files)
select * from files_info;
Result is: could not stat file "my_data_01.txt": Unknown error
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16813: error to solve the problem "Windows could not stat file - over 4GB"
@ 2021-01-08 01:59 Michael Paquier <michael@paquier.xyz>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Paquier @ 2021-01-08 01:59 UTC (permalink / raw)
To: c_michal@poczta.onet.pl; pgsql-bugs@lists.postgresql.org
On Thu, Jan 07, 2021 at 02:02:06PM +0000, PG Bug reporting form wrote:
> my PG version: PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
> testing method
> select * from files_info;
> Result is: could not stat file "my_data_01.txt": Unknown error
bed9075 will be available in PG14. We may consider a backpatch but
I'd rather have more dust settle on what has been committed on HEAD
before doing such a move (as known as wait for 14 to be released at
least in beta to get this code tested more extensively in the field).
Or are you saying that you tested the patch on top of some 13 code and
it did not work?
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-01-08 01:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-07 14:02 BUG #16813: error to solve the problem "Windows could not stat file - over 4GB" PG Bug reporting form <noreply@postgresql.org>
2021-01-08 01:59 ` Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox