How to use postgres as accessory #518
-
|
Trying to use postgres as an accessory, but keep seeing the following error on the app container when trying to deploy: Here's what I have in the Dockerfile: RUN apt-get update -qq && \
apt-get install --no-install-recommends -y build-essential curl git libvips libpq-dev node-gyp pkg-config python-is-python3Shouldn't installing the Any suggestions? |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 4 replies
-
|
Add the libpq5 package as well, and it should solve the issue |
Beta Was this translation helpful? Give feedback.
-
|
@floydj You're missing |
Beta Was this translation helpful? Give feedback.
-
|
I'm still getting this error after installing all of RUN apt-get update -qq && \
apt-get install --no-install-recommends -y build-essential git libpq-dev postgresql-client libpq5 pkg-config && \
rm -rf /var/lib/apt/lists /var/cache/apt/archivesHere's the full error output: |
Beta Was this translation helpful? Give feedback.
-
|
@disbelief Do you have multiple This issue isn't specific to Kamal but Docker, here are the multi-stage build docs. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks Nick. I'm new to both 😂 I do have multiple FROM lines but the |
Beta Was this translation helpful? Give feedback.
-
|
That seems to have solved it. I should mention for others experiencing this that it's a Ruby on Rails application using the Dockerfile that framework generated for me. I had switched the app from mysql to postgres and I think the script to do this didn't update the Dockerfile correctly. Here is my full Dockerfile in its current working state: # syntax=docker/dockerfile:1
# check=error=true
# This Dockerfile is designed for production, not development. Use with Kamal or build'n'run by hand:
# docker build -t ref .
# docker run -d -p 80:80 -e RAILS_MASTER_KEY=<value from config/master.key> --name ref ref
# For a containerized dev environment, see Dev Containers: https://guides.rubyonrails.org/getting_started_with_devcontainer.html
# Make sure RUBY_VERSION matches the Ruby version in .ruby-version
ARG RUBY_VERSION=3.4.1
FROM docker.io/library/ruby:$RUBY_VERSION-slim AS base
# Rails app lives here
WORKDIR /rails
# Install base packages
RUN apt-get update -qq && \
apt-get install --no-install-recommends -y curl libpq-dev postgresql-client libpq5 libjemalloc2 libvips && \
rm -rf /var/lib/apt/lists /var/cache/apt/archives
# Set production environment
ENV RAILS_ENV="production" \
BUNDLE_DEPLOYMENT="1" \
BUNDLE_PATH="/usr/local/bundle" \
BUNDLE_WITHOUT="development"
# Throw-away build stage to reduce size of final image
FROM base AS build
# Install packages needed to build gems
RUN apt-get update -qq && \
apt-get install --no-install-recommends -y build-essential git pkg-config && \
rm -rf /var/lib/apt/lists /var/cache/apt/archives
# Install application gems
COPY Gemfile Gemfile.lock ./
RUN bundle install && \
rm -rf ~/.bundle/ "${BUNDLE_PATH}"/ruby/*/cache "${BUNDLE_PATH}"/ruby/*/bundler/gems/*/.git && \
bundle exec bootsnap precompile --gemfile
# Copy application code
COPY . .
# Precompile bootsnap code for faster boot times
RUN bundle exec bootsnap precompile app/ lib/
# Final stage for app image
FROM base
# Copy built artifacts: gems, application
COPY --from=build "${BUNDLE_PATH}" "${BUNDLE_PATH}"
COPY --from=build /rails /rails
# Run and own only the runtime files as a non-root user for security
RUN groupadd --system --gid 1000 rails && \
useradd rails --uid 1000 --gid 1000 --create-home --shell /bin/bash && \
chown -R rails:rails db log storage tmp
USER 1000:1000
# Entrypoint prepares the database.
ENTRYPOINT ["/rails/bin/docker-entrypoint"]
# Start server via Thruster by default, this can be overwritten at runtime
EXPOSE 80
CMD ["./bin/thrust", "./bin/rails", "server"]
|
Beta Was this translation helpful? Give feedback.
@floydj You're missing
postgresql-clientin the Dockerfile, you'll need that in the final stage of your build.