how to upgrade PostgreSQL client in azure cloud shell

S, P1686MS (623-WIPRO LIMITED) 0

Hi,

I have run the below command and getting below error.

pg_dump -Fc -v --host=XXXXXXX --username=XXXXX --dbname=XXX -f test_dev_flexi_psqllogtim.dump

Password:

pg_dump: error: server version: 15.7; pg_dump version: 14.13

pg_dump: error: aborting because of server version mismatch

Vijayalaxmi Kattimani 985 Reputation points Microsoft Vendor

2025-01-23T11:47:51.19+00:00

Hi @S, P1686MS (623-WIPRO LIMITED),

Just checking in to see if the below answer provided by @Khalid Badawi helped.

I hope this information helps. Please do let us know if you have any further queries.

3 answers

Khalid Badawi 0 Reputation points

2025-01-22T11:36:40.1333333+00:00
how to upgrade PostgreSQL client in azure cloud shell

To upgrade your PostgreSQL client in Azure Cloud Shell, follow these steps:

Open Azure Cloud Shell.

Check Current Version: First, check the current version of your PostgreSQL client by running:

bash

psql --version

Update PostgreSQL Client: If an update is available, you can upgrade the PostgreSQL client using the package manager. For example, if you're using Ubuntu, you can run:

bash

sudo apt-get update sudo apt-get install postgresql-client

Verify Upgrade: After the installation, verify the upgrade by checking the version again:

bash

psql --version

Restart Cloud Shell.
Please sign in to rate this answer.
Vijayalaxmi Kattimani 985 Reputation points Microsoft Vendor

2025-01-23T18:20:25.8666667+00:00

Hi @S, P1686MS (623-WIPRO LIMITED),

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
S, P1686MS (623-WIPRO LIMITED) 0 Reputation points

2025-01-24T10:28:16.7666667+00:00

I ran this command in the Dockerfile, but the pg_dump version is not upgraded. It's showing the same version.
Please sign in to rate this answer.
Sai Raghunadh M 1,915 Reputation points Microsoft Vendor

2025-01-24T11:53:43.03+00:00

Hi @S, P1686MS (623-WIPRO LIMITED)

Thanks for your response.

It appears that running the command in the Dockerfile does not change the version. Please try the following steps:

# Use a base image with Ubuntu FROM ubuntu:latest # Update package lists, remove older PostgreSQL client versions, and install the required version RUN apt-get update && \ apt-get remove -y postgresql-client-14 && \ apt-get install -y postgresql-client-15 # Verify the installation RUN pg_dump --version # Set the working directory WORKDIR /app # Copy application files into the container COPY . . # Set the correct path for the PostgreSQL client ENV PATH /usr/lib/postgresql/15/bin:$PATH

By using this Dockerfile, the version mismatch error should be resolved, updating pg_dump to version 15 to match your PostgreSQL server

I hope this information helps, please do let us know if you have any Queries.

Sai Raghunadh M 1,915 Reputation points Microsoft Vendor

2025-01-27T02:54:16.65+00:00

Hi @S, P1686MS (623-WIPRO LIMITED)

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
S, P1686MS (623-WIPRO LIMITED) 0 Reputation points

2025-01-24T10:50:34.1266667+00:00

I ran this command in the Dockerfile, but the pg_dump version is not upgraded. It's showing the same version.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer