Re: Compiling PostgreSQL for WIndows with 16kb blocksize

Hi,

On January 19, 2022 9:07:50 AM PST, Yannick Collette <yannickcollette@gmail.com> wrote:
>Hello,
>
>For test purposes I need to compile PostgreSQL 14.1 using a 16kb blocksize.
>
>CFLAGS="-D WINVER=0x0600 -D _WIN32_WINNT=0x0600" LIBS="-ladvapi32"
> ./configure --host=x86_64-w64-mingw32 --with-blocksize=16
>--with-wal-blocksize=16 --with-openssl --with-libxml
>--prefix=/c/postgresql/pg14/ 2>&1 | tee configure.log
>
>Below is the beginning of my configure.log, with no errors:  make and make
>install ok also.
>
>configure: loading site script /etc/config.site
>checking build system type... x86_64-pc-msys
>checking host system type... x86_64-w64-mingw32
>checking which template to use... win32
>checking whether NLS is wanted... no
>checking for default port number... 5432
>checking for block size... 16kB
>checking for segment size... 1GB
>checking for WAL block size... 16kB
>checking for x86_64-w64-mingw32-gcc... x86_64-w64-mingw32-gcc
>checking whether the C compiler works... yes
>...
>
>DB created successfully using initdb.
>
>Unfortunately my blocksize is still 8kb when checking in DB.
>
>postgres=# show block_size;
> block_size
>------------
> 8192
>(1 row)
>
>
>postgres=# select version();
>                                                           version

>-----------------------------------------------------------------------------------------------------------------------------
> PostgreSQL 14.1 on x86_64-w64-mingw32, compiled by
>x86_64-w64-mingw32-gcc.exe (Rev9, Built by MSYS2 project) 10.2.0, 64-bit
>(1 row)
>
>Is there anything additional step I'm missing?

Any chance this is from an older build? You might need to make clean, if you previously ./configured differently.

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.