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 is no longer here · Accepted Answer · 2022-06-06 21:14:58Z

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 6, 2022 at 21:14

answered Jun 6, 2022 at 20:50

Dirk is no longer here

370k60 gold badges668 silver badges742 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Benjamin Talisman Over a year ago

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 Over a year ago

correct flag is: '--no-install-recommends', with 2 hyphens

Dirk is no longer here Over a year ago

Now the typo is mine :) Will fix.

Collectives™ on Stack Overflow

Problem building R api with plumber, RPostgreSQL, and docker

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related