PostgreSQL Installation and Configuration
Also referred to as Postgres, PostgreSQL is an object-relational database management system with emphasis on extensibility and standards compliance.
PostgreSQL can handle workloads ranging from small single-machine applications to large Internet-facing applications, or for data warehousing, with many concurrent users. PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable views and materialized views, triggers, foreign keys, supports functions and stored procedures, and offers other expandability.
PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors. It is free and open-source, released under the terms of the PostgreSQL License, a permissive software license. For more information, visit https://www.postgresql.org/.
Prerequisites
System Requirements
Platform | 64 Bit | 32 Bit |
---|---|---|
Windows Version | 2016; 2012 R2 and R1; 2008 R2, 7, 8, and 10 | 2008 R1, 7, 8, and 10 |
PostgreSQL Installer
Use the following installer to set up PostgreSQL: postgresql-10.1-2-windows-x64.exe or later version. The PostgreSQL executable is installed as part of the HyperMesh software installation. You will see another installer along with Altair Simulation products for installing PostGresDB.
Install PostgreSQL
In this section you will learn how to install PostgreSQL.
It is recommended to perform the installation using the values and options as detailed below. Also, when prompted for a Windows admin password, create a new password.
Connect to Shared Library
In this task you will learn how to connect to the PostgreSQL Shared Library.
-
To create a shared library:
-
To add an existing library: