I am trying to connect to postgreSQL database using R but I am getting an error :
pg_connect(): Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above.
I have looked at few pages including this link I tried changing
password_encryption = md5
and restarted PostgreSQL application but it did not work and still giving me the same error.
Could anyone please help me in resolving in error.
I am using PostgreSQL version 15.3
Output of sessionInfo()
R version 4.2.3 (2023-03-15 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19045)
Matrix products: default
locale:
[1] LC_COLLATE=English_India.utf8 LC_CTYPE=English_India.utf8
LC_MONETARY=English_India.utf8
[4] LC_NUMERIC=C LC_TIME=English_India.utf8
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] RPostgreSQL_0.7-5 DBI_1.1.3
loaded via a namespace (and not attached):
[1] compiler_4.2.3 tools_4.2.3