ABOUT THIS SOFTWARE
PostgreSQL is an advanced database system widely used in both educational and professional applications. It supports SQL and includes extensions for JSON, XML, geospatial data (PostGIS) and more. PostgreSQL is suitable for storing and managing structured data and is often used in combination with analytics tools, web application backends and data processing applications. The server runs locally or in a server environment, and users can connect via tools such as pgAdmin.
download software
PostgreSQL is completely free and open-source, with no need for a license or registration.
The installation instructions for this software will be explained during the lessons.
Installation manual
Choose the correct installation file for your operating system
- Download and open the installer (e.g. from EDB)
- Follow the steps of the wizard: choose an installation folder, set a password for the "postgres" user and select a port number (default is 5432)
- After installation, the server starts automatically in the background
- Use a management tool such as pgAdmin to connect to the database