Unable to update package from sources with compilation

[wacekk]

For some time now, I've been trying to update the package from version 0.7-7 to 0.7-8. Unfortunately, the update attempt fails. I get the following message:

> install.packages("RPostgreSQL")
Instalowanie pakietu w ‘C:/Users/XXX/AppData/Local/R/win-library/4.4’
(ponieważ ‘lib’ nie jest określony)

  Jest dostępna wersja binarna ale wersja ze źródłami jest późniejsza:
            binary source needs_compilation
RPostgreSQL  0.7-7  0.7-8              TRUE

instalowanie pakietu źródłowego ‘RPostgreSQL’
próbowanie adresu URL 'https://cran.rstudio.com/src/contrib/RPostgreSQL_0.7-8.tar.gz'
Content type 'application/x-gzip' length 565218 bytes (551 KB)
downloaded 551 KB

* installing *source* package 'RPostgreSQL' ...
** pakiet 'RPostgreSQL' został pomyślnie rozpakowany oraz sumy MD5 zostały sprawdzone
** using staged installation
** libs
using C compiler: 'gcc.exe (GCC) 13.2.0'
gcc  -I"C:/PROGRA~1/R/R-44~1.3/include" -DNDEBUG -I/include     -I"C:/rtools44/x86_64-w64-mingw32.static.posix/include"     -O2 -Wall  -mfpmath=sse -msse2 -mstackrealign  -c RS-DBI.c -o RS-DBI.o
gcc  -I"C:/PROGRA~1/R/R-44~1.3/include" -DNDEBUG -I/include     -I"C:/rtools44/x86_64-w64-mingw32.static.posix/include"     -O2 -Wall  -mfpmath=sse -msse2 -mstackrealign  -c RS-PQescape.c -o RS-PQescape.o
gcc  -I"C:/PROGRA~1/R/R-44~1.3/include" -DNDEBUG -I/include     -I"C:/rtools44/x86_64-w64-mingw32.static.posix/include"     -O2 -Wall  -mfpmath=sse -msse2 -mstackrealign  -c RS-PostgreSQL.c -o RS-PostgreSQL.o
gcc  -I"C:/PROGRA~1/R/R-44~1.3/include" -DNDEBUG -I/include     -I"C:/rtools44/x86_64-w64-mingw32.static.posix/include"     -O2 -Wall  -mfpmath=sse -msse2 -mstackrealign  -c RS-pgsql-copy.c -o RS-pgsql-copy.o
gcc  -I"C:/PROGRA~1/R/R-44~1.3/include" -DNDEBUG -I/include     -I"C:/rtools44/x86_64-w64-mingw32.static.posix/include"     -O2 -Wall  -mfpmath=sse -msse2 -mstackrealign  -c RS-pgsql-getResult.c -o RS-pgsql-getResult.o
gcc  -I"C:/PROGRA~1/R/R-44~1.3/include" -DNDEBUG -I/include     -I"C:/rtools44/x86_64-w64-mingw32.static.posix/include"     -O2 -Wall  -mfpmath=sse -msse2 -mstackrealign  -c RS-pgsql-pqexec.c -o RS-pgsql-pqexec.o
gcc  -I"C:/PROGRA~1/R/R-44~1.3/include" -DNDEBUG -I/include     -I"C:/rtools44/x86_64-w64-mingw32.static.posix/include"     -O2 -Wall  -mfpmath=sse -msse2 -mstackrealign  -c RS-pgsql-pqexecparams.c -o RS-pgsql-pqexecparams.o
gcc -shared -s -static-libgcc -o RPostgreSQL.dll tmp.def RS-DBI.o RS-PQescape.o RS-PostgreSQL.o RS-pgsql-copy.o RS-pgsql-getResult.o RS-pgsql-pqexec.o RS-pgsql-pqexecparams.o -L/lib -lpq -lpgcommon -lpgport -lssl -lcrypto -lm -lssl -lcrypto -lz -lpthread -lshell32 -lws2_32 -lsecur32 -LC:/rtools44/x86_64-w64-mingw32.static.posix/lib/x64 -LC:/rtools44/x86_64-w64-mingw32.static.posix/lib -LC:/PROGRA~1/R/R-44~1.3/bin/x64 -lR
C:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: C:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x64): undefined reference to `__imp_CertFreeCertificateContext'
C:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: C:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x86): undefined reference to `__imp_CertCloseStore'
C:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: C:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x137): undefined reference to `__imp_CertOpenSystemStoreW'
C:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: C:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x14f): undefined reference to `__imp_CertFreeCertificateContext'
C:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: C:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x372): undefined reference to `__imp_CertFindCertificateInStore'
C:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: C:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x5fa): undefined reference to `__imp_CertFreeCertificateContext'
C:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: C:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x66f): undefined reference to `__imp_CertFindCertificateInStore'
collect2.exe: error: ld returned 1 exit status
nie utworzono pliku DLL
ERROR: compilation failed for package 'RPostgreSQL'
* removing 'C:/Users/XXX/AppData/Local/R/win-library/4.4/RPostgreSQL'
* restoring previous 'C:/Users/XXX/AppData/Local/R/win-library/4.4/RPostgreSQL'

Pobrane pakiety źródłowe są w
	‘C:\Users\XXX\AppData\Local\Temp\RtmpiocSEU\downloaded_packages’
Komunikat ostrzegawczy:
W poleceniu 'utils::install.packages("RPostgreSQL")':
  instalacja pakietu ‘RPostgreSQL’ miała niezerowy status wyjścia

The problem has been occurring for several months. I'm using R 4.4.3 and RStudio - always the most up-to-date version. Windows system.