After further investigation, it was determined that the issue was with the length of the path of some subdirectories in the zip file for the new binaries. Windows has a max path length of 260 characters, hence the issue with unzipping. Postgres V 14.3 had a max file path length of 226 [image: image.png] Postgres V 14.5 has a max file path length of 321 [image: image.png]
My team uses powershell v5 in our code to unzip these files, we needed to enable 'Long Path' for the files to be successfully unzipped. This was added as an opt-in by Microsoft for Windows 10 ( https://docs.microsoft.com/en-us/windows/win32/fileio/maximum-file-path-limitation?tabs=powershell ). Note that the files were successfully unzipped in Powershell v7 without making any changes. On Wed, Aug 24, 2022 at 5:36 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 8/24/22 2:23 PM, Thomas Kellerer wrote: > > Hillary Masha schrieb am 23.08.2022 um 20:58: > >> I downloaded the microsoft postgresql binaries for versions 14.5, > >> 13.8, 12.12, 11.17, 10.22 from > >> https://www.enterprisedb.com/download-postgresql-binaries and found > >> that there was an error with opening the zip files. Does anyone else > >> use these files and found that they ran into the same issue? If so, > >> where else can I get the files? > > > > I have no problems unzipping them on Windows 10 using TotalCommander > > or the Info-ZIP "unzip" tool > > > > I did some searching to see if there was a fix and the results where: > > From MS the usual: > a) It's your problem > b) Upgrade > c) Reboot. > > From others: > > a) The builtin unzip program is buggy don't use. > b) Use just about any other program. > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > >
