Skip to content

RPostgreSQL

R Interface to the 'PostgreSQL' Database System

v0.7-8 · Mar 28, 2025 · GPL-3 | file LICENSE

Description

Database interface and 'PostgreSQL' driver for 'R'. This package provides a Database Interface 'DBI' compliant driver for 'R' to access 'PostgreSQL' database systems. In order to build and install this package from source, 'PostgreSQL' itself must be present your system to provide 'PostgreSQL' functionality via its libraries and header files. These files are provided as 'postgresql-devel' package under some Linux distributions. On 'macOS' and 'Microsoft Windows' system the attached 'libpq' library source will be used.

Downloads

26.9K

Last 30 days

673rd

26.9K

Last 90 days

26.9K

Last year

CRAN Check Status

2 ERROR
2 WARNING
10 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 ERROR
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 ERROR
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 WARNING
r-release-macos-x86_64 WARNING
r-release-windows-x86_64 OK
Check details (14 non-OK)
OK r-devel-linux-x86_64-debian-clang

*


            
OK r-devel-linux-x86_64-debian-gcc

*


            
OK r-devel-linux-x86_64-fedora-clang

*


            
OK r-devel-linux-x86_64-fedora-gcc

*


            
ERROR r-devel-macos-arm64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/sonoma-arm64/results/4.6/RPostgreSQL.Rcheck/00install.out’ for details.
OK r-devel-windows-x86_64

*


            
OK r-oldrel-macos-arm64

*


            
OK r-oldrel-macos-x86_64

*


            
ERROR r-oldrel-windows-x86_64

whether package can be installed

Installation failed.
See 'd:/Rcompile/CRANpkg/local/4.4/RPostgreSQL.Rcheck/00install.out' for details.
OK r-patched-linux-x86_64

*


            
OK r-release-linux-x86_64

*


            
WARNING r-release-macos-arm64

compiled code

File ‘RPostgreSQL/libs/RPostgreSQL.so’:
  Found ‘___sprintf_chk’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘___stderrp’, possibly from ‘stderr’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_abort’, possibly from ‘abort’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_sprintf’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’

Compiled code should not call entry points which might terminate R nor
write to stdout/stderr instead of to the console, nor use Fortran I/O
nor system RNGs nor [v]sprintf.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual.
WARNING r-release-macos-x86_64

compiled code

File ‘RPostgreSQL/libs/RPostgreSQL.so’:
  Found ‘___sprintf_chk’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘___stderrp’, possibly from ‘stderr’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_abort’, possibly from ‘abort’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_sprintf’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’

Compiled code should not call entry points which might terminate R nor
write to stdout/stderr instead of to the console, nor use Fortran I/O
nor system RNGs nor [v]sprintf.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual.
OK r-release-windows-x86_64

*


            

Additional Issues

Check History

ERROR 10 OK · 0 NOTE · 2 WARNING · 2 ERROR · 0 FAILURE Mar 9, 2026
ERROR r-devel-macos-arm64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/sonoma-arm64/results/4.6/RPostgreSQL.Rcheck/00install.out’ for details.
WARNING r-release-macos-arm64

compiled code

File ‘RPostgreSQL/libs/RPostgreSQL.so’:
  Found ‘___sprintf_chk’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘___stderrp’, possibly from ‘stderr’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_abort’, possibly from ‘abort’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_sprintf’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’

Compiled code should not call entry points which might terminate R nor
write to stdout/stderr instead of to the console, nor use Fortran I/O
nor system 
WARNING r-release-macos-x86_64

compiled code

File ‘RPostgreSQL/libs/RPostgreSQL.so’:
  Found ‘___sprintf_chk’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘___stderrp’, possibly from ‘stderr’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_abort’, possibly from ‘abort’ (C)
    Object: ‘libpq/libpq.a’
  Found ‘_sprintf’, possibly from ‘sprintf’ (C)
    Object: ‘libpq/libpq.a’

Compiled code should not call entry points which might terminate R nor
write to stdout/stderr instead of to the console, nor use Fortran I/O
nor system 
ERROR r-oldrel-windows-x86_64

whether package can be installed

Installation failed.
See 'd:/Rcompile/CRANpkg/local/4.4/RPostgreSQL.Rcheck/00install.out' for details.

Reverse Dependencies (23)

Dependency Network

Dependencies Reverse dependencies DBI BIEN OpenRange RRedshiftSQL rpostgis NetSimR birdscanR clintrialx lucas obm sejmRP ProjectTemplate dbplyr dbx dittodb geoflow +8 more reverse deps RPostgreSQL

Version History

new 0.7-8 Mar 9, 2026