I have WPF application which using Postgresql as Database engine. I want to install Postgresql engine and restore/attach application-Db to it.
The application's users are non-technical people and they can not install Postgresql individually.
First, go to the PostgreSQL download page where you can download the application using this link: EnterpriseDB. The page should look something like this: Then, select the version that’s compatible with your system. In this case, we will be selecting PostgreSQL Version 12.2 for Windows system 64bit.
Install the latest version of Postgres, install pgadmin4, install python3, and pip3 install sqlalchemy and psycopg2 The first step to deploying our free Postgres database is to create a free account on Heroku. Heroku is a cloud platform that you can deploy your apps and databases to.
Let’s learn how to connect to your new Postgres database! To connect to your new database, return to the “Resources” page of your Heroku app. You should see the attached add-on “Heroku Postgres”. Click the “Heroku Postgres” link on the bottom right of the below picture to go to the database management page.
PostgreSQL is one of the most popular relational database management systems in the world powering some of the biggest businesses. If you download Postgres, you may be annoyed to find that you can only host it on your machine’s localhost server unless you pay a recurring fee to host it on a platform like AWS or Azure.
The application's users are non-technical people and they can not install Postgresql individually.
then try this , silently install PostgreSQL, we are using the similar code in our software deployment
C:\Installer\postgresql-9.0.2-1-windows.exe --serverport 5432 --servicename postgres_service --locale C --superaccount Myadmin --superpassword Mypassword --unattendedmodeui minimal --debuglevel 2 --mode unattended
run this as the bat file , install in the background
- postgresql-9.0.2-1-windows.exe
This is your exe
- serverport 5432
This is your port number where you want to install Postgres
- superaccount Myadmin
You use account name
- superpassword Mypassword
Your user password
keep the rest same.
This will directly install to c:\Program Files
I presume you want to deploy on Windows, so you can include PostgrSQL in your application installer, you can create an application installer for example with InnoSetup ...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With