PostgreSQL

About PostgreSQL

PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. Also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

For more information please visit PostgreSQL web site.

 
PostgreSQL in our program

In our program PostgreSQL is an optional database system you can use. Before use, you must have PostgreSQL server installed on your computer.
If you do not have it installed please download and install free PostgreSQL Server

Our Databases Maintenance feature will take care about everything else, it can create our databases for you on PostgreSQL server and transfer data from other database systems.
You do not have to do anything else, however there is a tool named pgAdmin4 which lets you manage databases in PostgreSQL server.
You can download and install it if you want to use the server for advanced use.

 
PostgreSQL can be used locally only. PostgreSQL server can be used for all of software databases.

PostgreSQL Configuration

The software is already preconfigured to use PostgreSQL database, you can change the following options:

Server
Here you can set database server's name.

The PostgreSQL database server's name typically refers to the hostname or IP address of the server where the PostgreSQL database is hosted.
This server's name is provided to establish a connection to the PostgreSQL database from a client application or another server.
The server's name can vary depending on how the PostgreSQL database is set up in your environment. If you're connecting to a PostgreSQL database hosted on your local machine, the server's name might be "localhost" or "127.0.0.1".

Port

The default port number for PostgreSQL database servers is 5432, this port number can be configured during the PostgreSQL installation process or modified later using pgAdmin app.
 

Username

In PostgreSQL, a  username is a unique identifier used to grant permissions and control access to the PostgreSQL database server. 
When you install PostgreSQL server, an username is already set along with a password and define the host from which the user can connect.
Default username is postgres, using pgAdmin you can change username.

Password
Enter your password here, the same password when you set during server installation.

Confirm Password
Reenter here your password

Backup Location
Here you can set database backup folder. After you change database backup folder it is advisable to move existing backup files to that new folder or create new backup.
Backup location can be a local folder, network folder or ftp server address.
 
If you want to use ftp server as your backup location then you must configure ftp server in software main options in FTP section
If you have it already configured enter into Backup Location text box a server address.

Notes:
Do not enter or look for any database names, software manages it, you only must set or select folder names.
After changing any settings here please do not forget to click the Save Settings button to save the changes.