How to install PostgreSQL client on Azure Web App (Windows)?

Question

Hi,
I have Azure Web App (Windows), and I wanted to do some db automations. Our database is postgresql database.
I want to use pg_dump command to run on our Azure Web App. And for that we need to install PostgreSQL client on Azure web app. How to do that?

Answer 1

Hi @Abdul Rehman Aftab ,

Do you have an app code similar to this?
https://www.c-sharpcorner.com/article/developing-web-applications-with-asp-net-core-dotvvm-and-postgresql/

here is a thread on using that on c#:
https://stackoverflow.com/questions/23026949/how-to-backup-restore-postgresql-using-code

to get started you would need to add the nugets:

Answer 2

Download and install PostgreSQL windows package from PostgreSQL website.

Unpack the zip archive, then you can use psql and pg_dump under bin directory.