Corrupted Postgresql Microsoft Binaries
Hello, 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?
Re: Corrupted Postgresql Microsoft Binaries
Thank you Adrian, I was able to unzip the files using powershell, my OS is Windows 10 and I had been using Windows' 'Extract All' to try to get the files. As well, simply double clicking to open the files showed an error stating that windows cannot open this file. I had download the zip files from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads . On Tue, Aug 23, 2022 at 3:27 PM Adrian Klaver wrote: > On 8/23/22 11:58, Hillary Masha wrote: > > Hello, > > > > 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 > > <https://www.enterprisedb.com/download-postgresql-binaries> and found > > that there was an error with opening the zip files. Does anyone else use > > I could unzip the file on Linux with no errors. > > What OS are you on Windows or MacOS and what version? > > How did you download? > > What software are you using to unzip the file? > > > these files and found that they ran into the same issue? If so, where > > else can I get the files? > > > > There are the installers: > > https://www.enterprisedb.com/downloads/postgres-postgresql-downloads > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: Corrupted Postgresql Microsoft Binaries
It looks like Windows 10 is unable to open the zip files for windows versions of the binaries 14.5, 13.8, 12.12, 11.17, 10.22. I get this error message when I double click the zip file or when I right click and select 'Extract All..'. [image: image.png] I was able to successfully unzip files in powershell using the command below. [image: image.png] On Wed, Aug 24, 2022 at 2:40 PM Adrian Klaver wrote: > On 8/24/22 09:17, Hillary Masha wrote: > > Thank you Adrian, I was able to unzip the files using powershell, my OS > > is Windows 10 and I had been using Windows' 'Extract All' to try to get > > the files. As well, simply double clicking to open the files showed an > > error stating that windows cannot open this file. I had download the zip > > files from > > https://www.enterprisedb.com/downloads/postgres-postgresql-downloads > > The files you where trying to open where unzipped with PowerShell or > 'Extract All'(assuming this means from the right click context menu for > the zip file)? > > Show commands/steps used in each case. > > Which file(s) exactly? > > What is the complete error message? > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: Corrupted Postgresql Microsoft Binaries
Thank you for sending the email to them, i had sent an email to techsupp...@enterprisedb.com last week but haven't heard back. I need the zip files as my team uses a script that installs the postgres versions to multiple machines using the binaries. On Wed, Aug 24, 2022 at 4:09 PM Adrian Klaver wrote: > On 8/24/22 12:22, Hillary Masha wrote: > > It looks like Windows 10 is unable to open the zip files for windows > > versions of the binaries 14.5, 13.8, 12.12, 11.17, 10.22. I get this > > error message when I double click the zip file or when I right click and > > select 'Extract All..'. > > image.png > > > > I was able to successfully unzip files in powershell using the command > > below. > > image.png > > > > I sent an email to: > > webmas...@enterprisedb.com > > explaining the issue. > > Is there a reason you can't use the installer? > > Can you do what you need with the files unzipped in PowerShell? > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: Corrupted Postgresql Microsoft Binaries
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 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 > > >
Re: 10.22 Windows binaries download? (zip "invalid" on Enterprisedb)
Hi Richard, I ran into this issue as well, the issue is with the length of the paths for the subdirectories,windows is unable to open them, they can be unzipped in powershell and 7-zip see https://www.postgresql.org/message-id/CA+RCjaw=GH-Lyxe5=5-un6sqjo-cqjhtebdomixowqdrvvy...@mail.gmail.com On Wed, Sep 21, 2022 at 9:34 AM Thomas, Richard < richard.tho...@atkinsglobal.com> wrote: > I’m trying to download the Windows x64 binaries only for PostgreSQL 10.22 > in order to perform a minor upgrade. However, the download > (postgresql-10.22-1-windows-x64-binaries.zip) from my usual go-to place: ( > https://www.enterprisedb.com/download-postgresql-binaries) gives me a > file that Windows zip declares invalid. Other zip files (e.g. the 32-bit > version) download and unzip quite happily. I’ve dropped Enterprise an > email, but in the meantime wonder if there are any other (reputable!) > binaries download sites I could use? > > > > Richard > > > > *At Atkins - member of the SNC-Lavalin Group, we work flexible hours > around the world. Although I have sent this email at a time convenient for > me, I don't expect you to respond until it works for you. * > > NOTICE – This email message and any attachments may contain information or > material that is confidential, privileged, and/or subject to copyright or > other rights. Any unauthorized viewing, disclosure, retransmission, > dissemination, or other use of or reliance on this message or anything > contained therein is strictly prohibited and may be unlawful. If you > believe you may have received this message in error, kindly inform the > sender by return email and delete this message from your system. Thank you. >
