In this blog post we are going to create Azure PostgreSQL database.
Login to your Azure portal and click on Create a resource.
Login to your Azure Portal.
Click on + Create a resource
Choose Databases -> Azure Database for PostgreSQL
Choose Single server and click on Create.
Choose Subscription and choose existing Resource group or create a new one.
Provide Server details
I call my Server name as sergeydotnetdemoserver, there are three rules for the name
Choose Location, I am living in Norway, so I chose West Europe. I also picked up latest version of PostgreSQL: 11 and default Computer + storage.
Now provide Administrator account details
There are also three rules for username
And three rules for password
And click on Create.
Navigate to your server and click on Connection Security.
And click on + Add current client IP address. Don't forget to click on Save.
Download and install PostgreSQL from here.
Start PgAdmin and right click on Servers -> Create -> Server...
Provide Name and click on Connection
Provide host name and your Username and Password
Click on Save.
And observe that you are connected to your Azure PostgreSQL server.
Congratulations you just created your first PostgreSQL server and default postgres database.
If you like my post image, you can free download it from here.
Don't forget to subscribe to get latest news from Sergey .NET directly to your mail.