Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade pg_dump to version 15 #986

Open
pablopla opened this issue Aug 9, 2023 · 0 comments
Open

Upgrade pg_dump to version 15 #986

pablopla opened this issue Aug 9, 2023 · 0 comments
Assignees
Labels
triage Needs to be triaged

Comments

@pablopla
Copy link

pablopla commented Aug 9, 2023

When trying to use voyager in docker to import a database from PostgreSQL 15 I'm getting an error:
pg_dump: error: aborting because of server version mismatch
pg_dump --version in the voygaer container shows:
pg_dump (PostgreSQL) 14.8 (Ubuntu 14.8-0ubuntu0.22.04.1)
Since the workflow requires running analyze-schema to find incompatibilities anyway there shouldn't be a reason not support the latest PostgreSQL release.

I was able to install postgresql-15 in the container with steps from the installer script and the migration worked.

FROM golang:latest
RUN go install github.com/go-delve/delve/cmd/dlv@latest

FROM amd64/ubuntu:22.04
ARG DEBIAN_FRONTEND=noninteractive
ENV TZ=UTC
RUN apt-get update && \
    apt-get install -y lsb-release gnupg2 wget && \
    echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list && \
    wget -nv -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add - && \
    apt-get update && \
    apt-get install -y postgresql
RUN apt-get update && \
    apt-get install -y wget curl openjdk-17-jre && \
    wget https://s3.us-west-2.amazonaws.com/downloads.yugabyte.com/repos/reporpms/yb-apt-repo_1.0.0_all.deb && \
    apt-get install -y ./yb-apt-repo_1.0.0_all.deb && \
    apt-get update && \
    apt-get upgrade -y binutils && \
    curl -sL https://aka.ms/InstallAzureCLIDeb | bash && \
    mkdir -p /opt/yb-voyager && \
    apt-get install -y yb-voyager && \
    rm -rf /yb-apt-repo_1.0.0_all.deb && \
    apt-get clean
COPY --from=0 $HOME/go/bin/dlv /usr/local/bin
CMD [“yb-voyager”]
@github-actions github-actions bot added the triage Needs to be triaged label Aug 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
triage Needs to be triaged
Projects
None yet
Development

No branches or pull requests

2 participants