{"id":3001,"date":"2020-08-04T08:53:07","date_gmt":"2020-08-04T13:53:07","guid":{"rendered":"http:\/\/microsoftgeek.com\/?p=3001"},"modified":"2020-08-04T08:55:49","modified_gmt":"2020-08-04T13:55:49","slug":"how-to-install-postgresql-on-windows-servers","status":"publish","type":"post","link":"https:\/\/microsoftgeek.com\/?p=3001","title":{"rendered":"How to Install PostgreSQL on Windows Servers"},"content":{"rendered":"\n

Open a browser tab and go to the PostgreSQL -EnterpriseDB website to download the installer. Select the latest version (version 10.3 at the time of writing of this article). Then select your operating system. Finally click the “download now” <\/strong>link to complete the process.<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How to Install PostgreSQL 10<\/h2>\n\n\n\n

Download the Windows version: PostgreSQL \u2013 [10.3] \u2013windows \u2013 x64.exe <\/strong>and then open it. Navigate to the download folder location and double-click the file to run the installer.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Once you click next,<\/strong> by default, the Setup installs the PostgreSQL on the C<\/strong> directory, but you can always choose a different folder or directory on your local hardware.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select the components: by<\/strong> default – all components<\/strong> are selected.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select where you want PostgreSQL to store its data<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Enter the password for the database superuser. This password is set for security purposes and is in fact the administrator <\/strong>user.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select a port number, by default it is usually port 5432<\/strong>. You can always configure the firewall so that you can access the database from the web.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select a default locale<\/strong> or time zone and the default language. You choose your location here.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Finally, confirm the settings you have just configured. Whenever you want you can go back<\/strong> to any setting you want to redo. If satisfied click next<\/strong> to continue.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Additional utilities and add-ons can be installed using the Stack builder.<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Finally, click finish<\/strong> to complete the installation.<\/p>\n\n\n\n

Select the Postgres Server<\/strong> installed.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select the  additional configuration required and click Next <\/strong>to complete the installation.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Verifying the installation<\/h3>\n\n\n\n

The quickest way is to use the pgAdmin<\/strong>. At the search bar, search for pgAdmin<\/strong> and then click on the link.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The window shows your current installation. In this case: PostgreSQL 10<\/strong><\/p>\n\n\n\n

Connect to the PostgreSQL 10 Instance<\/h3>\n\n\n\n

Next: double click the PostgreSQL. It prompts for the admin password<\/strong> that you set up earlier during the installation process<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

If installed correctly, pgAdmin<\/strong> shows us all objects on the server.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Troubleshooting errors<\/h2>\n\n\n\n

In case you get an error do the following:<\/p>\n\n\n\n

  1. Uninstall the app and delete its data in the installation folder.<\/li>
  2. Create a new user in the Windows account and add it to the administrative group, call it postgres.<\/strong><\/li>
  3. Restart your system.<\/li>
  4. Open your command prompt using the command
    1. runas \/user:posters cmd.exe<\/li><\/ol><\/li>
    2. Finally, another window appears, and this is where you run the installer.<\/li><\/ol>\n\n\n\n

      Conclusion<\/h2>\n\n\n\n

      PostgreSQL is one of the best-performing relational databases that is available to developers today. It is an excellent choice for most business applications that consider data mining, analytics, and reporting as important requirements. Amazon is using PostgreSQL for data warehousing. Redshift, also implements a somewhat modified version of the framework.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Open a browser tab and go to the PostgreSQL -EnterpriseDB website to download the installer. Select the latest version (version 10.3 at the time of writing of this article). Then select your operating system. Finally click the “download now” link to complete the process. How to Install PostgreSQL 10 Download the Windows version: PostgreSQL \u2013 [10.3] \u2013windows […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48,63,74],"tags":[],"class_list":["post-3001","post","type-post","status-publish","format-standard","hentry","category-microsoft-windows-server-2012","category-server-2016-2016","category-windows-server-2019"],"_links":{"self":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/3001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3001"}],"version-history":[{"count":2,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/3001\/revisions"}],"predecessor-version":[{"id":3003,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/3001\/revisions\/3003"}],"wp:attachment":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}