hypopg icon indicating copy to clipboard operation
hypopg copied to clipboard

Published 20 hours ago • verified publisher icon HypoPG

any plans for windows?

Open liyunMS opened this issue 7 years ago • 15 comments

do we have any plans to support window in the near future?

Thanks!

liyunMS avatar Jan 31 '18 08:01 liyunMS

Hi,

As far as I know the code should be supported on windows. Do you encounter any issue?

rjuju avatar Jan 31 '18 10:01 rjuju

Not yet. I just did not find any instruction on how to install this extension on windows. Can you give me some guidance on that?

Thanks!

liyunMS avatar Jan 31 '18 17:01 liyunMS

The most difficult part is probably to compile the extension, everything else will work the same. I don't use windows myself, so I can't really help you on the compiling part. You can check this documentation which should help you compile extensions on windows.

rjuju avatar Feb 01 '18 00:02 rjuju

@liyunMS, did you succeeded? Can you give me some guidance? Thank you.

marmiskeje avatar Apr 23 '18 04:04 marmiskeje

@marmiskeje you can try this: https://github.com/kmosolov/hypopg/tree/win32 There are hardcoded paths to PostgreSQL libs in vcxproj file, you should check and fix them.

kmosolov avatar Jul 06 '18 09:07 kmosolov

@kmosolov oh, thanks for working on windows compatibility!

Is there some way to ease this work by adding specific code in the main tree? I looked at your modifications and think I could at least add the __declspec(dllexport) options (though using extern PGDLLEXPORT). Anything else would be worthwhile ?

rjuju avatar Jul 06 '18 11:07 rjuju

@marmiskeje you can try this: https://github.com/babalubas090/hypopg-windows Just insert these files in your PostgreSQL directory. They are organized in subdirectories just like your PostgreSQL installation.

babalubas090 avatar Jan 02 '19 13:01 babalubas090

I wanted to run HypoPG on Windows. I took the changes from @kmosolov and applied them to 2.0.0beat. Necessary changes:

  • Add PGDLLEXPORT to some functions.
  • Some conditional compilation as MSVC doesnt like INT32_MAX
  • Some explicit type-cast to silence compiler warnings.

Godwottery avatar Jan 19 '19 11:01 Godwottery

@marmiskeje you can try this: https://github.com/kmosolov/hypopg/tree/win32 There are hardcoded paths to PostgreSQL libs in vcxproj file, you should check and fix them.

@kmosolov, @babalubas090, thanks. What version of visual c++ redistributable packages do I need? I am getting this error: ERROR: could not load library "C:/Program Files/PostgreSQL/11/lib/hypopg.dll": The specified procedure could not be found. SQL state: XX000

Windows server 2019 Posgtresql 11

Thank you.

marmiskeje avatar Mar 09 '19 15:03 marmiskeje

Never mind, I build it by myself in upgraded bubalubas´ project (upgraded for Visual Studio 2017). Kmosolov´s library didn´t worked for me. Thank you, guys.

marmiskeje avatar Mar 10 '19 09:03 marmiskeje

Thanks for sharing an update!

rjuju avatar Mar 10 '19 10:03 rjuju

Getting this error for Postgres 12 installation could not load library "C:/Program Files/PostgreSQL/12/lib/hypopg.dll": The specified procedure could not be found. I took the link shared by @babalubas090 . @marmiskeje can you please help as you had same issue.

anupkumarmishra avatar Apr 30 '20 11:04 anupkumarmishra

@Godwottery Can you please help ?

anupkumarmishra avatar May 04 '20 06:05 anupkumarmishra

FYI: See also issue #50 .

sfkeller avatar May 24 '20 08:05 sfkeller

I spent some time setting up a build environment on Windows. As far as I can see there was one problem which prevented compilation with msvc, and I just pushed a fix for that.

I'm now working on providing zip archives / installers. If anyone is interested in Windows packages, I'm interested in feedback with the packages I just generated for the current HEAD, which is currently version 1.3.2 but the "real" version 1.3.2 will likely have other changes, so that should be kept in mind.

hypopg-1.3.2-pg10-x64.zip hypopg-1.3.2-pg11-x64.zip hypopg-1.3.2-pg12-x64.zip hypopg-1.3.2-pg13-x64.zip

rjuju avatar Aug 15 '21 12:08 rjuju

is there a possible windows build of hypopg for pg14 in the works?

d1g1talpump avatar Jun 29 '23 10:06 d1g1talpump

@d1g1talpump I just uploaded installers for pg versions 9.6 to 15 for the latest versions at https://github.com/HypoPG/hypopg/releases/tag/1.4.0

Let me know if that's working as expected.

rjuju avatar Jun 29 '23 11:06 rjuju

@d1g1talpump I just uploaded installers for pg versions 9.6 to 15 for the latest versions at https://github.com/HypoPG/hypopg/releases/tag/1.4.0

Let me know if that's working as expected.

brilliant, seems to be working as expected. Thanks so much for the lightening response

d1g1talpump avatar Jun 29 '23 11:06 d1g1talpump

Excellent news, thanks a lot for the feedback!

I will keep uploading the windows installer for the next releases then! Feel free to open an issue if I forget to do so at some point.

rjuju avatar Jun 29 '23 12:06 rjuju