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

28.9K

Last 30 days

680th

103.8K

Last 90 days

646.5K

Last year

Trend: +1.9% (30d vs prior 30d)

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 (4 non-OK)
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.
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.
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.

Additional Issues

Check History

ERROR 10 OK · 0 NOTE · 2 WARNING · 2 ERROR · 0 FAILURE Mar 10, 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)
    Obj
...[truncated]...
pq.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)
    Obj
...[truncated]...
pq.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.
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 10, 2026
updated 0.7-8 ← 0.7-7 diff Mar 27, 2025
updated 0.7-7 ← 0.7-6 diff Sep 29, 2024
updated 0.7-6 ← 0.7-5 diff Jan 10, 2024
updated 0.7-5 ← 0.7-4 diff Feb 9, 2023
updated 0.7-4 ← 0.7-3 diff Aug 8, 2022
updated 0.7-3 ← 0.7-2 diff Oct 21, 2021
updated 0.7-2 ← 0.7 diff Oct 5, 2021
updated 0.7 ← 0.6-2 diff Jul 26, 2021
updated 0.6-2 ← 0.4-1 diff Jun 23, 2017
updated 0.4-1 ← 0.4 diff May 7, 2016
updated 0.4 ← 0.3-3 diff Mar 26, 2013
updated 0.3-3 ← 0.3-2 diff Oct 4, 2012
updated 0.3-2 ← 0.3-1 diff Jan 28, 2012
updated 0.3-1 ← 0.3-0 diff Jan 2, 2012
updated 0.3-0 ← 0.2-1 diff Dec 29, 2011
updated 0.2-1 ← 0.2-0 diff Nov 16, 2011
updated 0.2-0 ← 0.1-7 diff Oct 3, 2011
updated 0.1-7 ← 0.1-6 diff Oct 16, 2010
updated 0.1-6 ← 0.1-5 diff Oct 19, 2009