uuid-ossp source or binaries for Windows

Started by Mark Hillalmost 3 years ago4 messages

Mark.Hill@sas.com

almost 3 years ago

I've downloaded the PostgreSQL 14.7 source and building it on Windows 64bit and 32bit.

I'm using the Visual Studio tools in the src/tools/msvc folder.

I'm trying to build with the uuid extension but it looks like I need uuid-ossp installed in order
to get it to work.

The source download referenced in the Postgresql doc here, https://www.postgresql.org/docs/current/uuid-ossp.html#id-1.11.7.58.6
this source download, ftp://ftp.ossp.org/pkg/lib/uuid/uuid-1.6.2.tar.gz, is Unix-specific as far as I can tell.

Where can I find uuid-ossp for Windows, 32 and 64 bit, either the source so I can build it or
prebuilt libraries?

Thanks, Mark

Daniel Gustafsson

daniel@yesql.se

almost 3 years ago

In reply to: Mark Hill (#1)

Re: uuid-ossp source or binaries for Windows

On 15 Mar 2023, at 19:31, Mark Hill <Mark.Hill@sas.com> wrote:

I’ve downloaded the PostgreSQL 14.7 source and building it on Windows 64bit and 32bit.

I’m using the Visual Studio tools in the src/tools/msvc folder.

I’m trying to build with the uuid extension but it looks like I need uuid-ossp installed in order
to get it to work.

Do you need the extension specifically or does the built-in generator function
do what you need?

The source download referenced in the Postgresql doc here, https://www.postgresql.org/docs/current/uuid-ossp.html#id-1.11.7.58.6
this source download, ftp://ftp.ossp.org/pkg/lib/uuid/uuid-1.6.2.tar.gz, is Unix-specific as far as I can tell.

Where can I find uuid-ossp for Windows, 32 and 64 bit, either the source so I can build it or
prebuilt libraries?

I don't know windows at all, but uuid-ossp.dll is provided in the EDB packages
(looking at the binary zip bundle) so it's clearly available to be built.
Maybe someone from EDB can chime in with pointers for building on Windows so we
can update the docs accordingly?

--
Daniel Gustafsson

Mark Hill

Mark.Hill@sas.com

almost 3 years ago

In reply to: Daniel Gustafsson (#2)

RE: uuid-ossp source or binaries for Windows

Hey Daniel,

Thanks for getting back to me.

I think the issue I'm having is that my build of Postgres is missing uuid pieces needed by our users.

They're executing the command: CREATE EXTENSION "uuid-ossp"

and getting the error

ERROR: could not open extension control file "<Postgres-Install-Home>/share/extension/uuid-ossp.control"

The only file matching "*uuid*" in my build of Postgres is: <Postgres-Install-Home>/include/server/utils/uuid.h

I should have in addition:
<Postgres-Install-Home>/include/uuid.h
<Postgres-Install-Home>/lib/uuid-ossp.dll
<Postgres-Install-Home>/share/extension/uuid-ossp--1.1.sql
<Postgres-Install-Home>/share/extension/uuid-ossp.control
<Postgres-Install-Home>/share/extension/uuid-ossp--unpackaged--1.0.sql
<Postgres-Install-Home>/share/extension/uuid-ossp--1.0--1.1.sql

I need a Windows-specific install of uuid-ossp for the Postgres build to use, for both 32bit and 64bit Windows.

Thanks, Mark

-----Original Message-----
From: Daniel Gustafsson <daniel@yesql.se>
Sent: Wednesday, March 15, 2023 3:16 PM
To: Mark Hill <Mark.Hill@sas.com>
Cc: pgsql-general@lists.postgresql.org; Ken Peressini <Ken.Peressini@sas.com>; Michael King <Michael.King@sas.com>
Subject: Re: uuid-ossp source or binaries for Windows

EXTERNAL

On 15 Mar 2023, at 19:31, Mark Hill <Mark.Hill@sas.com> wrote:

I've downloaded the PostgreSQL 14.7 source and building it on Windows 64bit and 32bit.

I'm using the Visual Studio tools in the src/tools/msvc folder.

I'm trying to build with the uuid extension but it looks like I need
uuid-ossp installed in order to get it to work.

Do you need the extension specifically or does the built-in generator function do what you need?

The source download referenced in the Postgresql doc here,
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.
postgresql.org%2Fdocs%2Fcurrent%2Fuuid-ossp.html%23id-1.11.7.58.6&data
=05%7C01%7CMark.Hill%40sas.com%7C5acf51786dd5440ea0ed08db2589a9fd%7Cb1
c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145045990073139%7CUnknown%
7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJX
VCI6Mn0%3D%7C3000%7C%7C%7C&sdata=TSRqdrvImMLf6Pr8XWqRSUkCWUDaAjFtziykz
Czt5Sc%3D&reserved=0 this source download,
https://nam02.safelinks.protection.outlook.com/?url=ftp%3A%2F%2Fftp.ossp.org%2Fpkg%2Flib%2Fuuid%2Fuuid-1.6.2.tar.gz&data=05%7C01%7CMark.Hill%40sas.com%7C5acf51786dd5440ea0ed08db2589a9fd%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145045990073139%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ry3iJshaFPSegaIrmaJzA0%2BIKgEfXbJwmasBA8ZdWQ8%3D&reserved=0, is Unix-specific as far as I can tell.

Where can I find uuid-ossp for Windows, 32 and 64 bit, either the
source so I can build it or prebuilt libraries?

I don't know windows at all, but uuid-ossp.dll is provided in the EDB packages (looking at the binary zip bundle) so it's clearly available to be built.
Maybe someone from EDB can chime in with pointers for building on Windows so we can update the docs accordingly?

--
Daniel Gustafsson

Mark Hill

Mark.Hill@sas.com

almost 3 years ago

In reply to: Mark Hill (#3)

FW: uuid-ossp source or binaries for Windows

I posted this to pgsql-general but I think that's more for Postgres users. I'm trying to build Postgres
with the uuid-ossp extension on Windows using the msvc toolset provided with the Postgres source
in <postgresSourceHome>/src/tools/msvc, e.g. postgresql-14.7/src/tools/msvc.

I think I need uuid-ossp installed. The uuid-ossp source located here: ftp://ftp.ossp.org/pkg/lib/uuid/uuid-1.6.2.tar.gz
is Unix-specific.

Is there uuid-ossp source download for Windows or are uuid-ossp prebuilt binaries for Windows available?

Thanks, Mark

-----Original Message-----
From: Mark Hill <Mark.Hill@sas.com>
Sent: Wednesday, March 15, 2023 11:15 PM
To: 'Daniel Gustafsson' <daniel@yesql.se>
Cc: pgsql-general@lists.postgresql.org; Ken Peressini <Ken.Peressini@sas.com>; Michael King <Michael.King@sas.com>
Subject: RE: uuid-ossp source or binaries for Windows

EXTERNAL

Hey Daniel,

Thanks for getting back to me.

I think the issue I'm having is that my build of Postgres is missing uuid pieces needed by our users.

They're executing the command: CREATE EXTENSION "uuid-ossp"

and getting the error

ERROR: could not open extension control file "<Postgres-Install-Home>/share/extension/uuid-ossp.control"

The only file matching "*uuid*" in my build of Postgres is: <Postgres-Install-Home>/include/server/utils/uuid.h

I need a Windows-specific install of uuid-ossp for the Postgres build to use, for both 32bit and 64bit Windows.

Thanks, Mark

EXTERNAL

On 15 Mar 2023, at 19:31, Mark Hill <Mark.Hill@sas.com> wrote:

I've downloaded the PostgreSQL 14.7 source and building it on Windows 64bit and 32bit.

I'm using the Visual Studio tools in the src/tools/msvc folder.

I'm trying to build with the uuid extension but it looks like I need
uuid-ossp installed in order to get it to work.

Do you need the extension specifically or does the built-in generator function do what you need?

The source download referenced in the Postgresql doc here,
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww%2F&data=05%7C01%7Cmark.hill%40sas.com%7C2fe3e6f033eb4de4506708db25cca633%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145333114215621%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4dfMYruL3rZjCY8ScPUM70xOk%2FM2WJIs8FPw4xXrUI0%3D&reserved=0.
postgresql.org%2Fdocs%2Fcurrent%2Fuuid-ossp.html%23id-1.11.7.58.6&data
=05%7C01%7CMark.Hill%40sas.com%7C5acf51786dd5440ea0ed08db2589a9fd%7Cb1
c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145045990073139%7CUnknown%
7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJX
VCI6Mn0%3D%7C3000%7C%7C%7C&sdata=TSRqdrvImMLf6Pr8XWqRSUkCWUDaAjFtziykz
Czt5Sc%3D&reserved=0 this source download,
https://nam02.safelinks.protection.outlook.com/?url=ftp%3A%2F%2Fftp.ossp.org%2Fpkg%2Flib%2Fuuid%2Fuuid-1.6.2.tar.gz&data=05%7C01%7Cmark.hill%40sas.com%7C2fe3e6f033eb4de4506708db25cca633%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145333114215621%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=t9AVwe32CRgcW9oH%2Fmjj0lC8SSIAw0cBrQXmH1GKcNc%3D&reserved=0, is Unix-specific as far as I can tell.

Where can I find uuid-ossp for Windows, 32 and 64 bit, either the
source so I can build it or prebuilt libraries?

I don't know windows at all, but uuid-ossp.dll is provided in the EDB packages (looking at the binary zip bundle) so it's clearly available to be built.
Maybe someone from EDB can chime in with pointers for building on Windows so we can update the docs accordingly?

--
Daniel Gustafsson