* using log directory 'd:/Rcompile/CRANpkg/local/4.4/RPostgreSQL.Rcheck' * using R version 4.4.3 (2025-02-28 ucrt) * using platform: x86_64-w64-mingw32 * R was compiled by gcc.exe (GCC) 13.3.0 GNU Fortran (GCC) 13.3.0 * running under: Windows Server 2022 x64 (build 20348) * using session charset: UTF-8 * checking for file 'RPostgreSQL/DESCRIPTION' ... OK * this is package 'RPostgreSQL' version '0.7-8' * checking package namespace information ... OK * checking package dependencies ... OK * checking if this is a source package ... OK * checking if there is a namespace ... OK * checking for hidden files and directories ... OK * checking for portable file names ... OK * checking whether package 'RPostgreSQL' can be installed ... ERROR Installation failed. See 'd:/Rcompile/CRANpkg/local/4.4/RPostgreSQL.Rcheck/00install.out' for details. * DONE The installation logfile: * installing *source* package 'RPostgreSQL' ... ** package 'RPostgreSQL' successfully unpacked and MD5 sums checked ** using staged installation ** libs using C compiler: 'gcc.exe (GCC) 13.3.0' make[1]: Entering directory '/d/temp/2025_05_04_01_50_00_20595/RtmpAT7oKc/R.INSTALL70fc30b61210/RPostgreSQL/src' gcc -I"D:/RCompile/recent/R-4.4.3/include" -DNDEBUG -ID:/rtools44/x86_64-w64-mingw32.static.posix/include -I"d:/rtools44/x86_64-w64-mingw32.static.posix/include" -pedantic -Wstrict-prototypes -O2 -Wall -mfpmath=sse -msse2 -mstackrealign -c RS-DBI.c -o RS-DBI.o gcc -I"D:/RCompile/recent/R-4.4.3/include" -DNDEBUG -ID:/rtools44/x86_64-w64-mingw32.static.posix/include -I"d:/rtools44/x86_64-w64-mingw32.static.posix/include" -pedantic -Wstrict-prototypes -O2 -Wall -mfpmath=sse -msse2 -mstackrealign -c RS-PQescape.c -o RS-PQescape.o gcc -I"D:/RCompile/recent/R-4.4.3/include" -DNDEBUG -ID:/rtools44/x86_64-w64-mingw32.static.posix/include -I"d:/rtools44/x86_64-w64-mingw32.static.posix/include" -pedantic -Wstrict-prototypes -O2 -Wall -mfpmath=sse -msse2 -mstackrealign -c RS-PostgreSQL.c -o RS-PostgreSQL.o gcc -I"D:/RCompile/recent/R-4.4.3/include" -DNDEBUG -ID:/rtools44/x86_64-w64-mingw32.static.posix/include -I"d:/rtools44/x86_64-w64-mingw32.static.posix/include" -pedantic -Wstrict-prototypes -O2 -Wall -mfpmath=sse -msse2 -mstackrealign -c RS-pgsql-copy.c -o RS-pgsql-copy.o gcc -I"D:/RCompile/recent/R-4.4.3/include" -DNDEBUG -ID:/rtools44/x86_64-w64-mingw32.static.posix/include -I"d:/rtools44/x86_64-w64-mingw32.static.posix/include" -pedantic -Wstrict-prototypes -O2 -Wall -mfpmath=sse -msse2 -mstackrealign -c RS-pgsql-getResult.c -o RS-pgsql-getResult.o gcc -I"D:/RCompile/recent/R-4.4.3/include" -DNDEBUG -ID:/rtools44/x86_64-w64-mingw32.static.posix/include -I"d:/rtools44/x86_64-w64-mingw32.static.posix/include" -pedantic -Wstrict-prototypes -O2 -Wall -mfpmath=sse -msse2 -mstackrealign -c RS-pgsql-pqexec.c -o RS-pgsql-pqexec.o gcc -I"D:/RCompile/recent/R-4.4.3/include" -DNDEBUG -ID:/rtools44/x86_64-w64-mingw32.static.posix/include -I"d:/rtools44/x86_64-w64-mingw32.static.posix/include" -pedantic -Wstrict-prototypes -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 -LD:/rtools44/x86_64-w64-mingw32.static.posix/lib -lpq -lpgcommon -lpgport -lssl -lcrypto -lm -lssl -lcrypto -lz -lpthread -lshell32 -lws2_32 -lsecur32 -Ld:/rtools44/x86_64-w64-mingw32.static.posix/lib/x64 -Ld:/rtools44/x86_64-w64-mingw32.static.posix/lib -LD:/RCompile/recent/R-4.4.3/bin/x64 -lR D:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: D:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x64): undefined reference to `__imp_CertFreeCertificateContext' D:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: D:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x86): undefined reference to `__imp_CertCloseStore' D:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: D:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x137): undefined reference to `__imp_CertOpenSystemStoreW' D:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: D:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x14f): undefined reference to `__imp_CertFreeCertificateContext' D:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: D:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x372): undefined reference to `__imp_CertFindCertificateInStore' D:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: D:/rtools44/x86_64-w64-mingw32.static.posix/lib/libcrypto.a(libdefault-lib-winstore_store.obj):winstore_store:(.text+0x5fa): undefined reference to `__imp_CertFreeCertificateContext' D:\rtools44\x86_64-w64-mingw32.static.posix\bin/ld.exe: D:/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 make[1]: Leaving directory '/d/temp/2025_05_04_01_50_00_20595/RtmpAT7oKc/R.INSTALL70fc30b61210/RPostgreSQL/src' make[1]: Entering directory '/d/temp/2025_05_04_01_50_00_20595/RtmpAT7oKc/R.INSTALL70fc30b61210/RPostgreSQL/src' make[1]: Leaving directory '/d/temp/2025_05_04_01_50_00_20595/RtmpAT7oKc/R.INSTALL70fc30b61210/RPostgreSQL/src' no DLL was created ERROR: compilation failed for package 'RPostgreSQL' * removing 'd:/Rcompile/CRANpkg/lib/4.4/RPostgreSQL' * restoring previous 'd:/Rcompile/CRANpkg/lib/4.4/RPostgreSQL'