Compile static postgres.lib for postgres 15.3 on Windows

Started by Priess Stefanover 2 years ago8 messagesgeneral

stefan.priess@nexus-chili.com

over 2 years ago

Hi all,

up to version 9.6.22 there was a win32.mak file in the src/interfaces/libpw folder which could be used to compile a static postgres.lib using nmake. Since Postgres 10 this file has been removed.

Is it still possilbe to build a static postgres.lib for windows ? And if so, how do I do it.

Thanks!

Stefan

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

NEXUS / CHILI GmbH, Friedrich-Ebert-Str. 2, 69221 Dossenheim/Heidelberg
www.nexus-chili.com<http://www.nexus-chili.com/>

Eingetragene Gesellschaft beim Registergericht Mannheim, HRB 337363
Geschäftsführer: Dr. Uwe Engelmann, Dr. Heiko Münch

Tom Lane

tgl@sss.pgh.pa.us

over 2 years ago

In reply to: Priess Stefan (#1)

Re: Compile static postgres.lib for postgres 15.3 on Windows

Priess Stefan <stefan.priess@nexus-chili.com> writes:

up to version 9.6.22 there was a win32.mak file in the src/interfaces/libpw folder which could be used to compile a static postgres.lib using nmake. Since Postgres 10 this file has been removed.

Yup. It didn't really work right and there was insufficient interest
in maintaining it.

Is it still possilbe to build a static postgres.lib for windows ? And if so, how do I do it.

Run the normal build process using MSVC, and then just take libpq.lib
from the results. On any modern machine that's just going to take
a few minutes, so it's not worth maintaining a separate libpq-only
build path.

regards, tom lane

Priess Stefan

stefan.priess@nexus-chili.com

over 2 years ago

In reply to: Tom Lane (#2)

AW: Compile static postgres.lib for postgres 15.3 on Windows

Thanks Tom!

I also need to change the default port from 5433 to 5432 (--with-pgport=5433). How can I do this using the build.bat toolchain? I don't see the pgport parameter in the config_default.pl file.

Best,

Stefan

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

NEXUS / CHILI GmbH, Friedrich-Ebert-Str. 2, 69221 Dossenheim/Heidelberg
www.nexus-chili.com

Eingetragene Gesellschaft beim Registergericht Mannheim, HRB 337363
Geschäftsführer: Dr. Uwe Engelmann, Dr. Heiko Münch

-----Ursprüngliche Nachricht-----
Von: Tom Lane <tgl@sss.pgh.pa.us>
Gesendet: Freitag, 28. Juli 2023 14:48
An: Priess Stefan <stefan.priess@nexus-chili.com>
Cc: pgsql-general@lists.postgresql.org
Betreff: Re: Compile static postgres.lib for postgres 15.3 on Windows

Priess Stefan <stefan.priess@nexus-chili.com> writes:

up to version 9.6.22 there was a win32.mak file in the src/interfaces/libpw folder which could be used to compile a static postgres.lib using nmake. Since Postgres 10 this file has been removed.

Yup. It didn't really work right and there was insufficient interest in maintaining it.

Is it still possilbe to build a static postgres.lib for windows ? And if so, how do I do it.

Run the normal build process using MSVC, and then just take libpq.lib from the results. On any modern machine that's just going to take a few minutes, so it's not worth maintaining a separate libpq-only build path.

regards, tom lane

Adrian Klaver

adrian.klaver@aklaver.com

over 2 years ago

In reply to: Priess Stefan (#3)

Re: AW: Compile static postgres.lib for postgres 15.3 on Windows

On 7/28/23 07:26, Priess Stefan wrote:

Thanks Tom!

I also need to change the default port from 5433 to 5432 (--with-pgport=5433). How can I do this using the build.bat toolchain? I don't see the pgport parameter in the config_default.pl file.

1) The default port is 5432.

2) Why do you want to change it?

Best,

Stefan

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

--
Adrian Klaver
adrian.klaver@aklaver.com

Tom Lane

tgl@sss.pgh.pa.us

over 2 years ago

In reply to: Priess Stefan (#3)

Re: AW: Compile static postgres.lib for postgres 15.3 on Windows

Priess Stefan <stefan.priess@nexus-chili.com> writes:

I also need to change the default port from 5433 to 5432 (--with-pgport=5433). How can I do this using the build.bat toolchain? I don't see the pgport parameter in the config_default.pl file.

I don't use MSVC myself, but a quick look at the code suggests that
you want to add

"--with-pgport" => 5433

(with the quotes, probably).

regards, tom lane

Priess Stefan

stefan.priess@nexus-chili.com

over 2 years ago

In reply to: Adrian Klaver (#4)

AW: AW: Compile static postgres.lib for postgres 15.3 on Windows

Sorry, I meant that I need to change the default port from 5432 to 5433.

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

NEXUS / CHILI GmbH, Friedrich-Ebert-Str. 2, 69221 Dossenheim/Heidelberg
www.nexus-chili.com

Eingetragene Gesellschaft beim Registergericht Mannheim, HRB 337363
Geschäftsführer: Dr. Uwe Engelmann, Dr. Heiko Münch

-----Ursprüngliche Nachricht-----
Von: Adrian Klaver <adrian.klaver@aklaver.com>
Gesendet: Freitag, 28. Juli 2023 16:44
An: Priess Stefan <stefan.priess@nexus-chili.com>; Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Betreff: Re: AW: Compile static postgres.lib for postgres 15.3 on Windows

On 7/28/23 07:26, Priess Stefan wrote:

Thanks Tom!

I also need to change the default port from 5433 to 5432 (--with-pgport=5433). How can I do this using the build.bat toolchain? I don't see the pgport parameter in the config_default.pl file.

1) The default port is 5432.

2) Why do you want to change it?

Best,

Stefan

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

--
Adrian Klaver
adrian.klaver@aklaver.com

Priess Stefan

stefan.priess@nexus-chili.com

over 2 years ago

In reply to: Tom Lane (#5)

AW: AW: Compile static postgres.lib for postgres 15.3 on Windows

Good morning Tom,

I tried adding

pgport => 5433, # --with-pgport=<path>

to the config_default.pl file. And

$config->{pgport} = 5433;

to the config.pl file.

But the default port is still 5432...

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

NEXUS / CHILI GmbH, Friedrich-Ebert-Str. 2, 69221 Dossenheim/Heidelberg
www.nexus-chili.com

Eingetragene Gesellschaft beim Registergericht Mannheim, HRB 337363
Geschäftsführer: Dr. Uwe Engelmann, Dr. Heiko Münch

-----Ursprüngliche Nachricht-----
Von: Tom Lane <tgl@sss.pgh.pa.us>
Gesendet: Freitag, 28. Juli 2023 17:01
An: Priess Stefan <stefan.priess@nexus-chili.com>
Cc: pgsql-general@lists.postgresql.org
Betreff: Re: AW: Compile static postgres.lib for postgres 15.3 on Windows

Priess Stefan <stefan.priess@nexus-chili.com> writes:

I also need to change the default port from 5433 to 5432 (--with-pgport=5433). How can I do this using the build.bat toolchain? I don't see the pgport parameter in the config_default.pl file.

I don't use MSVC myself, but a quick look at the code suggests that you want to add

"--with-pgport" => 5433

(with the quotes, probably).

regards, tom lane

Priess Stefan

stefan.priess@nexus-chili.com

over 2 years ago

In reply to: Priess Stefan (#7)

AW: AW: Compile static postgres.lib for postgres 15.3 on Windows

Tom,

i followed your instructions exactly and put

"--with-pgport" => 5433

in the config_default.pl and now it is working!

Thanks!

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

NEXUS / CHILI GmbH, Friedrich-Ebert-Str. 2, 69221 Dossenheim/Heidelberg
www.nexus-chili.com

Eingetragene Gesellschaft beim Registergericht Mannheim, HRB 337363
Geschäftsführer: Dr. Uwe Engelmann, Dr. Heiko Münch

-----Ursprüngliche Nachricht-----
Von: Priess Stefan <stefan.priess@nexus-chili.com>
Gesendet: Montag, 31. Juli 2023 09:52
An: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Betreff: AW: AW: Compile static postgres.lib for postgres 15.3 on Windows

Good morning Tom,

I tried adding

pgport => 5433, # --with-pgport=<path>

to the config_default.pl file. And

$config->{pgport} = 5433;

to the config.pl file.

But the default port is still 5432...

nexus / chili

Stefan Priess
Softwareentwicklung

Tel: +49 6221 18079-10
E-Mail: stefan.priess@nexus-chili.com

NEXUS / CHILI GmbH, Friedrich-Ebert-Str. 2, 69221 Dossenheim/Heidelberg www.nexus-chili.com

Eingetragene Gesellschaft beim Registergericht Mannheim, HRB 337363
Geschäftsführer: Dr. Uwe Engelmann, Dr. Heiko Münch

Priess Stefan <stefan.priess@nexus-chili.com> writes:

I also need to change the default port from 5433 to 5432 (--with-pgport=5433). How can I do this using the build.bat toolchain? I don't see the pgport parameter in the config_default.pl file.

I don't use MSVC myself, but a quick look at the code suggests that you want to add

"--with-pgport" => 5433

(with the quotes, probably).

regards, tom lane