Don't understand the algorithm of connecting database to the web application. What steps should be?

I have a website written in vue.js + C#. The database is PostgreSQL, the developers of the website have left a backup file format .sql . How to run the website locally so that podgruzilo database with the backup? The site has admin panel to manage the managers. Maybe somehow through it will be possible to load the backup right?

Downloaded pgAdmin for these cases.

I don't quite understand how separate sozdana database can communicate with the app, maybe you need something to prescribe for this in the application files?

PS the Database is locally created, superuser too.
P. S. S. the Operating system is Ubuntu LTS 18
March 23rd 20 at 19:36
1 answer
March 23rd 20 at 19:38
Install the DBMS.
Create database.
Create user (root access is not always safe even on LAN).
You dump that into sql format database.

Plug your app.
www.codeproject.com/KB/database/afppostgresqlintro.aspx
The first four steps done, only connect app - noemy commented on March 23rd 20 at 19:41
The answer is not suitable, I'm asking about the 5th step in detail - noemy commented on March 23rd 20 at 19:44
@noemy, what is the difficulty? - fernando.Strei commented on March 23rd 20 at 19:47
Found in the project file appsettings.json and there are settings for the database connection. Fields to populate with data taken about the creation of a local database? - noemy commented on March 23rd 20 at 19:50
@noemy, of course - Alice.Ha commented on March 23rd 20 at 19:53

Find more questions by tags PostgreSQL