Problem building R api with plumber, RPostgreSQL, and docker

Question

I'm trying to install plumber and RPostgreSQL into my docker image. Here's my dockerFile:

FROM rocker/r-base


RUN R -e "install.packages('plumber')"
RUN R -e "install.packages('RPostgreSQL')"

RUN mkdir -p /code
COPY ./plumber.R /code/plumber.R

CMD Rscript --no-save /code/plumber.R

The only thing my plumber script does is try to reference the RPostgreSQL package:

library('RPostgreSQL')

When I build, it appears to successfully install both packages, but when my script runs, it complains that RPostgreSQL doesn't exist. I've tried other base images, I've tried many things.

Any help appreciated. Thanks!

Dirk Eddelbuettel · Accepted Answer · 2022-06-06T21:14:58.317

2

You are trying to install RPostgres and then trying to load RPostgreSQL -- these are different packages. Hence the error.

Next, as you are on r-base, the latter is installed more easily as sudo apt install r-cran-rpostgresql (maybe after an intial sudo apt update). While you're at it, you can also install plumber as a pre-made binary (along with its dependencies). So

RUN apt update -qq \
     && apt install --yes --no-install-recommends \
            r-cran-rpostgresql \
            r-cran-plumber

is easier and faster.

edited Jun 06 '22 at 21:14

answered Jun 06 '22 at 20:50

Dirk Eddelbuettel

360,940
56
644
725

Sorry for typo above, i was in fact trying to install RPostgreSQL package, so that was not the problem. However, your apt command does the trick. Thanks! – Benjamin Talisman Jun 06 '22 at 21:07
correct flag is: '--no-install-recommends', with 2 hyphens – Benjamin Talisman Jun 06 '22 at 21:12
Now the typo is mine :) Will fix. – Dirk Eddelbuettel Jun 06 '22 at 21:14

Problem building R api with plumber, RPostgreSQL, and docker

1 Answers1